First off, I'd like to say that it's fantastic to see the recent feature update. I've gone through the accompanying blog post and the documentation, but I'm having a bit of difficulty figuring out how to set it up for my specific use case.
Here's what I'm aiming for:
- Workspace Setup for Role: I want to configure a Retool workspace specifically for a role named 'agent'.
- Company Assignment for Each Agent: Each agent would be associated with a 'company', which in our context, is a B2B entity within Retool.
- Expected Workflow: Ideally, a company would have multiple agents. When these agents utilize the Retool app, their specific company ID should drive their interactions and the components they interact with.
The challenge: When a user signs in, I imagine we'd need to initiate a database query to fetch the user's associated 'company'. This company ID is assigned externally, in another application, which presumably the company admin has access to.
End Goal: Our vision is to develop a portal where users can sign in, get associated with a company (akin to a franchisee), and then operate the Retool dashboard from the perspective of that company. I'm leaning towards setting up a dedicated company database and manually assigning users to their respective companies.
Has anyone implemented something similar or have insights on the best way to approach this? I'd greatly appreciate any guidance or best practices!
