I've built my app and only need to rerun it daily as I have new data, so I don't need to rebuild the app daily but that's what I'm doing. I'm not technical so please bear with me. How do I keep the app intact and attach the new data sets daily as not do consume too much of my AI credits?
1 Like
Hi @Elio_Lombardi, Welcome to the Retool Community!
I understand your use case. There are a couple of common approaches you can take, depending on how your data is updated.
Option 1: Use a Retool Workflow (Recommended)
If you need to periodically fetch new data from an external source and store it in your database, you can create a Retool Workflow and schedule it using a cron trigger.
For example, you can configure it to run:
- Once a day (e.g., 12:00 AM)
- Twice or three times a day
- Or at any interval that suits your requirements
The workflow can read the latest data, process it if needed, and insert or update your database automatically.
Option 2: Auto-refresh the Query
If your data is already being updated in the database and you only need your Retool app to display the latest records, you can use the query's built-in auto-refresh feature.
Go to the query's Advanced tab and configure the Period Interval. Set the refresh interval (in milliseconds), and the query will automatically re-run at that interval without requiring manual execution.
This approach works well for dashboards or monitoring pages that need to stay up to date.
If your use case is different—for example, you're looking for real-time updates, event-driven synchronization, or another workflow—feel free to share a bit more about your setup. The community can help suggest the most appropriate approach.
Hope this helps!