Hi @simpletech
Thanks for reaching out!
As far as a true authentication system, it might be worth looking into a resource that has configurable auth options, such as a rest api. Unless you're using a public app that anyone with the link can access, all users accessing your app will also already be authenticated through Retool's log in system. Since they're authenticated, you can use the current_user object to dynamically identify who is viewing an app.
Set button action to "Go to app" (how would that then SELECT
only the data for the signed-in user?)
- You could have a url param that passes the current user information to the newly opened app & then filter all of your app queries for that user
Make the Sign-in canvas disappear upon successful sign-in, then show the queried data according to who's signed-in.
- You could make the button's hidden field dependent on whether the auth query has successfully returned data: