Set Variable onStart VS with Timer

[i2p0]

I'm looking to setup a preload for my app where the app read the user preferences from a SQL and store it into a global variable. then fire the app according the setting. But these need to be consequente one to the other.

Set(_VisLoad; true);; //Set visibility of a spinner 
Set(_UserPref;Filter('[pa_userpreferences]'; UserId = User().Email));; // Read from the SQL
Set(_VarStart; TrimEnds(LookUp(_UserPref;Preference = 1;Value)));; // Get the default screen name

Switch(

_VarStart; 
"Home Page"; Set(_VisLoad; false);
"First Page"; Navigate(FirstPage);

);; //Go to page saved in setting

Placed into OnStart event works fine on Edit mode, but when published is not working at all.

is it better to use onStart or to place some Timers on load?

Thanks everybody for the support.

[Pstork1]

I would use a timer and a splash screen.  Then load the variable while the splash screen is active.  I don't think you'll be able to use a SQL connector during the OnStart.  But you should be able to use it during OnLoad for a screen.

[i2p0]

It doesn't seems working as expected.

into Home Page OnVisible i have placed the variable to set the visibility of the splash screen with the spinner

Set(_VisLoad; true);;

 Then i have created a Timer that Autostart and OnTimerStart I have placed the call to SQL

Set(_UserPref;Filter('[saisef].[pa_userpreferences]';  UserId = User().Email));;

and OnTimerEnd to set the variable from the SQL call

Set(_VarSito; Value(LookUp(_UserPref;Preference = 2;Value)));;
Set(_VarStart; TrimEnds(LookUp(_UserPref;Preference = 1;Value)));;
Switch(
    _VarStart; 
    "Home Page"; Set(_VisLoad; false);

unfortunately it still doesn't work properly...

I have also tried to change Set with UpdateContext... 

Looking into monitor it seems to fire properly the SQL call but i get an alert on Filter...

[Pstork1]

Is Home page the splash screen or the home page for the app?   For this to work properly the splash screen needs to be the first page to load. Then on Timer end navigate to the home page.

I also would recommend turning off Delayed Load and Use Non-blocking OnStart rule in the App settings.

[i2p0 · Accepted solution]

I finally got it working:

into APP OnStart i was able to fire the SQL call, but i had to create first a variable with the user email to reference as ID.

Set(_UserEmail; User().Email);;
Set(_UserPref;Filter('[pa_userpreferences]';  UserId = _UserEmail));;

if I was using directly User().Email into the filter was not working... i have not understood why.

then into the loading screen (1st screen running) I did set a timer and at TimerEND i run the other variable that are filtering the parameters from SQL call 

[Pstork1]

I can explain why the filter doesn't work until you save the email as a variable.  User().Email inside a function is non-delegable.  I suspect that was holding up the Filter() call.  But saving it first and using a variable makes the call delegable.