Working with dates and sql queries

Hi lovely folks!

We have a table tied to a sql query, the query includes some date parameters (example: show rows between yesterday and tomorrow).

How can we ensure that the app refreshes regularly so that we're only seeing today's data?

This app will be displayed on a tablet in Kiosk mode, so users are not able to refresh the webpage.

Any thoughts appreciated.

Hi @mjamil, If a query is set to 'Run query automatically when inputs change', you can set the query to run periodically on the Advanced tab of the query editor.

I hope this helps!