Show tables with loaded data when opening the app?

Hi,

I am now using postgresql to fill my tables, I also enabled caching. Is there a way to have the data already in the tables when a user opens the app? Or does it always need to be loaded the first time?

Thanks
Sander

You can create a transformer with the data and then set the table default value to that transformer.... or you can just put all the data in the default value field of the table

hmm what do you mean with default value field of the table?

if you mean the Data field, yes that is my query but I want to see data already when you open the app, without first having to wait to load the data.

You would have to run the query at some point and store the data somewhere in the app....
I know that Retool team is working on being able to schedule queries.... similar to workflows -- if I recall correctly