Continuously update table?

[hanni]

Is it possible to continuously refresh table data on a set interval (~1min)? We have two tables (used separately in different apps), one pulling from Google Sheets and one pulling from a postgres database and would like update the table on a set frequency to pull in any new data. Is this possible? If so, how would I go about doing that?

[ScottR]

See this post:

How do I schedule my queries to run every hour or day?

A common use case we see in Retool apps is scheduling queries to run every time period (an hour, a day, a week, etc.). Retool supports periodically running queries, with two important caveats (for now): Retool natively supports running queries periodically while your app is open, but not while it's closed. In your query, head over to the advanced tab and you should see a checkbox titled "Run this query periodically?" [image] Once you check the box, you'll be able to enter a period interval…