I'm working on an app that pulls information in from a Google Sheet on page load, and then performs certain checks and validations and then populates a List View where the user can perform some operations. There are a bunch of different tabs for working on different aspects of the data.
I have this query set to run on page load.
The problem is, the UI components load immediately, while the query takes a brief amount of time to run (since it's waiting for those other two queries to run). So when I pull up the app, the ListView is completely blank. I made a button that manually runs the query; when I press it, the UI components are then populated with data.
I feel though that this isn't the best way - I'm assuming there's some way to design this so that the components will show the data as soon as it becomes available without need for a manual refresh? Or is there a way to trigger a refresh of the components when the query is done running? Or am I going about this all wrong?