Hi there!
I have an app that has a table (this is part of the 35 or so lines):

based on this video:
https://www.youtube.com/watch?v=3DhShmNKHmc
ETC, I have a login screen

but I need to check that the Facility and Password match before the navigation part. in the video, it only covers the password match. I have fumbled for hours trying to get the context variable to load the screen part, like it does in the video, but cant seem to do it if the password and facility match.
It was an attempt to also combine this video:
https://www.youtube.com/watch?v=BN74SsN4mm8
which doesn't have the dynamic navigation part.
is there a way to check that the facility and password match, then dynamically navigate to the screen on the table?
this is my 50'th attempt, there were better ones but i stopped saving all the variations somewhere along the way:
btnOnStart://redirect and notify
If(
IsBlank(
LookUp(
colRedirect,
Facility_Location = VarGlobalFacilityBox.Selected.Value && Key = UserKey.Text
)
),
UpdateContext({locResult: UserKey.Text}),
Notify(
"Sorry, that combo is incorrect",
NotificationType.Error,
3000
)
);
Navigate(locResult.Screen,ScreenTransition.CoverRight);
Set(
GlobalPassword,
UserKey.Text
);
//preload contraband log information
Select(ContrabandLogButton)