Update formula checkbox based on role
I need to check the role of a user adding or updating a record. If the user is in one of four roles, a checkbox needs to be checked the the record is saved. However, I am not able to find a Quickbase ...
Forum Discussion
Another way to do this is to create a "User" table, separate from the default, and assign roles there.
It will have a 'User' field on the table, that is also the key field.
Then you create a formula relationship between that table, and any other table you'd like, and pull the role as a lookup. Then you can use roles in formula to direct workflow beyond what the native solutions provide. (i.e. User Role specific forms)
It will have a 'User' field on the table, that is also the key field.
Then you create a formula relationship between that table, and any other table you'd like, and pull the role as a lookup. Then you can use roles in formula to direct workflow beyond what the native solutions provide. (i.e. User Role specific forms)
good idea. I will see if this is a possibility. If it takes too long, I will just use the API method.