I am using the "list of values in in " block to retrieve the data into a list and then use it (say the # of entries(rows) is 10) when the screen starts/opens and I get it perfectly working.
But when a new row is created while using the app and when still being in the app when I query again , I still see the same 10 entries and I am not able to retrieve the 11th entry which was made. If I exit the app completely and then restart, I get the 11th entry also. Is there any way while still being in the app, I can get the updated google sheet content ?
Thank you so much !!!