I understand that currently if we want to assign a role to a user from within the app then the limitation is that the assigning user must be of the same role, else glide resets the data value for security reasons. @Darren_Murphy some of your old replies on related queries show that you use Make.com integration with the app to ensure that any user can assign any role.
I was wondering if you have tried achieving this via the new multiple text entry column feature(still under preview) ?
Also which method would you say is more cost effective - Make.com or multiple text entry column method, since both consume updates during workflow runs.
Yes, the Multiple Texts can be used if you need to assign multiple roles per user. The best way to do it is with a server side workflow (Manual or Webhook Trigger). There is no need to use Make. Multiple Texts is an array type column, so you must prepare an array of role values, and write that using Set Column Values.
Just to clarify, lets assume John Doe is an admin of the app. Essentially there are 3 roles - Admin, Manager and Agent which are assigned to various app users.
Up until now (before the multiple text column feature) John doe being an admin could only assign āAdminā role to a new user through the app(i had a āadd new userā button which would open up a form linked to the users table having the Role column) because role here are actual ROLES.
But i would like John Doe to be able to assign roles of Manager and Agent also to users(which was possible only via Make up until now)
But now i can have John Doe(or any other admin) use the in app form to add a new user and assign any 'ROLEā to this new user different from admin(Manager or Agent) because now there is a āmultiple rolesā column in my users table with John Doe having an array of roles of Admin, Manager and Agent.
Is my understanding correct ?
Also, can i not enter the data array manually in a multiple texts column i.e. do i have to use a workflow always? Iām trying to click on the cells to add stuff, but nothing is happening.
This has nothing to do with the Multiple Texts column. You could always assign any role to any user via the API, and more recently via server side workflows.
No, you cannot add data manually, because it is an array type column.
Thank you.
Just a side question - Implementing workflows creates these data tables that have all this workflow log meta data. Do these rows in these auto generated tables count towards my row limits on my plan?
Additionally on another side note, in my usage settings - big table rows count donāt show, does that mean all data using big tables is exluded from the row limit limitation ?