Bit confused by this; I know I can of course work with users from inside the Retool admin interface but how do I do it from inside my app?
I'm trying to figure out how to create new users from inside my app; edit them; allow users to change their name; reset their password etc.
You cannot at this time (on cloud). Unless you have your own database table with users in there
How do you query the users table? Or can you not even do that? For example, I want to be able to put who someone's manager is, like a User/User relationship for permissions, or who their director is. I need a way for a manager for example to be able to log in and view all records that belong to their subordinates and so on.
Or am I supposed to create a Users table in the database and do things like that in there, and have it look up against that able by the email address or user ID type of thing?
Yes, this.
Hey @lmonroe! As @ScottR has mentioned, this functionality isn't available on the cloud offering as you don't have direct access to the underlying database with your Retool users. Additionally, even with an on-premise installation, we don't recommend that you make any modifications to any of the db tables as they are occasionally altered by migrations upon update. We have seen issues with customers changing the schema and getting errors when attempting to get on a more recent version. You can definitely use Retool db to create your own table with user / manager connections etc, and use that in apps.