Using Xano
Imagine you have multiple companies, within those companies multiple users of my app (sometimes 1 or 2, other times up to 1000 users)
Also, there are none company related users who will also have access to a different section of the app.
Company users and none company users have slightly different tables so, right now, the parts not used are left blank.
Should I create
1, One table for all companies and 1 for all non company related users?
2, Shove them all in 1 table?
3, Doesn’t matter, stop wasting our time with silly questions 
If I have a company admin section that allows these companies to add their own users, will they need their own DB table too?
Thank you
Oh, so i guess I cant have multiple login tables. Hmmm
Should I create a different workspace for the company and non company side or I guess continue keeping it all in 1 xano table and separate them by role?
The proper DB structure should be one table for many tenants, which keeps the relationships. Something along these lines.
As for the forms, you can even have two separate, it doesn’t really matter front-end wise, but more like UX and DB wise.
Oh, I did not set mine up like this but this makes sense.
I think I have to go back and set this up again.
I have company and non company users in 1 table, its a big table.
Thank you
If I have everyone in one form, how do I get the different roles to get sent to a different pages?
I have 3 roles and I want each role to go to a different dashboard when they login.
since I have everyone in one table I might aswell use the same login form, but then I have the issue of them all navigating to the same dashboard.
This is how it should be
You could use a Multi option split to check that in the Workflow
I thought that but for some reason I dont see the role as an option after login.
its weird
I have access to only last name, id, email and profile pic.
no first name, no role, etc
I was being an idiot and forgot what I learned yesterday. I now have access to the role.
Did I set this up wrong?
Its not working.
I also tried adding a “fetch collection” to be sure the user data was there. that also didnt work
also tried this
i gave up and just used 2 consecutive true/false splits. it worked and was easier to work out
