[SOLVED] Procedure displays data when fired by a Button, not when called by ScreenInit

[TwoCanes_LLC]

The AirTables data is gathered and put into an SQLite DB during a Spreadsheet .Got Column. After the .Got Column has finished, the Screen Init fires off the procedure “showDB”, but the only data displayed is the “0” for number of table rows. Then, when “Show DB” button is pressed, the data from the DB is found and displayed and the number of table rows is “14”, which is correct.

Why won’t the procedure “showDB” find the data without pressing the “Show DB” button? Here are the blocks:

Waiting a second or three after Spreadsheet1 has finished makes no difference.

The data is available immediately during the Spreadsheet1 .Got Column with an SQLite Select statement (left out for brevity).

I tried this with Kodular’s SQLite and it made no difference, got the same “results”.

Any help would be greatly appreciated.

[ADDYLIN]

You can try using Clock -

[Rogerio_Rios (Professional Support)]

Asynchronous. Try to simulate a click on your button and make it invisible.

[TwoCanes_LLC]

Beautiful. Simple, but elegant solution, thank-you!

I knew there had to be a way to trigger that data outside the .Got Column; been banging my head against my desk for weeks!

Thank-you, thank-you, thank-you.

[Rogerio_Rios (Professional Support)]

I suggested because everything indicates asynchrony, everything is running without having to wait for the other task to finish.
I really don’t know if it’s the best solution.

[TwoCanes_LLC]

Seems to work only out of the .Got Column, but hey, it does work. I like Addylin’s Clock solution best. Better to have two possible solutions than zero solutions.

Thanks for your help, I appreciate it.

[Taifun]

this would be the correct asynchronous solution…

• no need for a delay…
• no need for a clock…
• display the result after it has been downloaded from the Airtable
• also make sure to enable Button1 only after the data has been downloaded…

Taifun

[Titan_geek]

I considered myself as bad koder after doing this but now I know it’s best solution thank you