Google Spreadsheet - Data Update - Return Without Reboot App

Hello everyone
I need a tip from you guys…please.

When updating data in a Google spreadsheet, I want this value to be returned in my list_view_image as soon as the data changes. But what’s happening is I need to restart the app for the data to show up in my list.

Remembering that the app is correctly updating my data in the spreadsheet. I would just like this update to appear immediately in my list_view_image

This block is the refresh button.

blocks(1)

Can I see screen initialized block

blocks(3)

I am not able to understand what is happening.

There are 2 cases

If Once app reopens the data is updated then it means there is something in this initialize block updating the data and it is missing Spreadsheet column updated block.

Or

The spreadsheet update block is not working

To Know which case. examine the update block. Update the data and one spreadsheet updated event fires set any label text to xyz, then you will know which case it is

This is not a big issue, may i?

1 Like

will be welcome

Just try this methodology.

Create a procedure , in that add

  1. Web url
  2. Web.get
  3. List view elements to create empty list

Add this procedure in screen initialise as well as in when spreadsheet get updated

So it will solve your problem i hope.

Just try and let me know. Still problems persists just tell us, we will suggest you

So after column updation you no need to reopen the app

1 Like

@Still-learning
Thank you for the tips. I will try here

1 Like

Is this like what you are expecting?

Record_2021-07-14-22-55-31

Exactly :smiley: :blush:

@Still-learning
Thanks for solving my problem… Now it works exactly as I want…
Thanks

Below are the blocks that solved the problem
blocks

blocks(1)

blocks(2)

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.