Ability to add arrays as row owners would be a great improvement. Right now the only way to have more than one row owner is either by creating multiple row owner columns or using roles.
Multiple use cases for this:
- Customer portal for multiple members of the same company or family.
- Securing access to multiple people on a project, task, folder, contract, quote, etc. in a CRM.
- Anything that requires multiple specific users access to a secured row of data.
You can make an “array” column if you use Google Sheet and simple columns like:
Role 1, Role 2, Role 3, Role 4, Role n,…
Glide will create a Role (array) column with these “n” columns. Pretty useful when you need multiple roles on users!
I still agree that it should be native in Glide Tables!
bump, maybe the text array column that is in preview is designed to tackle this?
Yes, the new multiple texts column replaces the previous procedure I described.
1 Like
Fantastic! Can’t wait to use it once it hits production!
1 Like
I already use it, and it is safe, secure and amazing!
1 Like
Is there a way, and maybe this is a new thread. Use Case:
User has three roles (as admin, access to three locations). I want them to be able to select between the roles inside the app from the array of roles in the glide text array role column, this way role owners in the database functions properly to calculate based on each location.
currently how I am doing this is they click a button, which sends a webhook to make.com, changing their actual role in the user table, however it is slow, you have to refresh, and the data only updates when the data see’s a “change”
You can actually use webhook/manual/slack/scheduled or mail triggered workflows since these are executed from the backend. You will be able to change the user’s roles. I recommend you to use array to set, remove from array, make array and set column values actions to change the multiple texts column. Another tip is that if you need to remove all roles, don’t set column values with empty string. It won’t work. Use clear value in the set column values instead.
1 Like
I do currently use webhook but perhaps you can elaborate on manual
I tried to have a button switch the role column but it doesn’t work it just reverts back to the original role.
Can you show me your current workflow?
Note that you can’t change roles from app interaction workflow. You need to use backend workflows (email, schedule, webhook, slack and manual).
1 Like