Multi-tenant and users
I am struggling to set up and app that has multiple clients each with their own set of users and data. The biggest issue is the inviting of new users. I’ve set up a ClientUsers table that supposedly syncs with the built-in Users table but it’s not working. The user is invited. The user is provided a sign up link with token. But when the user goes to sign up the User record is updated from pending but it won’t store the client id and it will not update the ClientUser record status nor add the user id. I’ve gone rounds of this.
Anyone successfully overcome this? Any approach that seems to work best? Should I look at this differently?
By the way, the reason for the ClientUser table is because I want to be open to the possibility that one user could belong to multiple Client teams over time.