Response time from filtered data in spreadsheet

Questions about Thunkable
1

I am working on app and I stuck with filtered data from spreadsheet.
Here is code how I add uniqe dates into spreadsheet FilteredDates in Sheet2 column ‘uniqedates’.

image
image945×471 108 KB

That works fine.
I connect dataviewer with same spreadsheet and sheet and all data are visible. That is good to.

Next step is problem. When user click on date in dateviewer it should parse date on next screen but it does not. I just got blank label.
Here is code.

image
image945×345 73.4 KB

I can get row id but can’t get value from column ‘uniqedates’. Label on next screen (or same screen just for attempt) is blank.
image

Does it in call refresh data but then how is row id visible. Maybe is problem with response time but I waited for few minutes and nothing show up.

Thanks for help.

2

Hi @robert.newton.442rpp , welcome to Thunkable! :tada:

In general, I would suggest you use a local table to save the Filtered Dates to avoid too many calls to Google Sheets.

Also, after you create new rows on the data source you could try to refresh the Data Viewer.

Be sure to check out How to ask Great Questions v2.0, the Community Guidelines, and our Getting Started Guide to make the best of your Thunkable Community experience!

3

I rewrite entire code and done it on local level. I didn’t use local table just lists. Now I have one call to Spreadsheet and entire filtering is done on user side. It is much faster code.

You can close topic.

1 Like