I need to populate a form with data from a retool database.
Issue:
The database doesn’t update before the next page is loads, so I need to put in a delay to allow the database to update.
Steps I've taken to troubleshoot:
I’ve tried increasing the On Page Load delay, but it doesn’t seem to have any effect, changing the query to run periodically does work, but it’s not what I require (the form just keeps refreshing losing data being entered)
Is this process something like Submit → Update → Redirect? How is the event structure handled? If you are already chaining the events via Success Handlers in each step you might need to explicitly trigger the queries in a JS Code resource and use await calls before the redirect.
I resolved the issue, I fired off the query after the form was submitted but before the record was added, I guess the query needed to be fired off on the first page before the navigation? Not sure why, either-way this ticket is resolved for me.