Hi, I want to create an app for multiple business activities with multiple user types. Say I have users that do production, other users that do deliveries, vendors that open the app and see their purchase orders / submit invoice. Can I only use the “Users” table with different role “production”, “…

[image] locked_with_key Secure Your Data with Row Owners and Public Profiles Community Resources wave Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that. …

[image] as1said: Can I only use the “Users” table with different role “production”, “courier”, “vendors”? Yes, you can. [image] as1said: Each with their own related fields connecting “Production/Production ID”, “Courier/Delivery ID”, “Vendor/PO ID” / “Vendor/Invoice ID”. Subsequently, th…

[image] ThinhDinh: I don’t really see that as a problem. You should keep the users in one place. However, I’m not entirely sure about your ID columns. What do they represent? Noted on keeping them in one place. Thank you so much for your response. Say, for example, I want to keep track of d…

Actually, I came across another problem regarding security. I need row owners to make sure personal details are protected. But I need to look up a list of users for assigning tasks. If they’re all in the same table, how do I display the list of “users”? Say on the dispatch page, I want to look up …

Multiple User Types with Different Relation Fields

Ask for Help

Darren_Murphy June 9, 2023, 2:50am 5

Topic		Replies	Views
Row Owners Shared Between Glide Tables Ask for Help	11	436	April 30, 2023
Another Roles/Row Owners/Public Users/Private Users question Ask for Help	8	612	January 2, 2023
Problems with relations columns and users Ask for Help	12	418	January 11, 2022
Row access based on company's users Ask for Help	20	416	July 14, 2023
Row owners - quick security question Ask for Help	7	94	August 5, 2024

Multiple User Types with Different Relation Fields

Related topics