Forum Discussion
MCFNeil
8 years agoQrew Captain
You will want to create a "Task Options" table.
Connect it to your "Task" table, where each Option has many Tasks.
Then you have essentially created your options dropdown.
Each Option will need to be its own record, but here is where you adjust the 'visibility'.
On the Options table, you will want a 2nd field called "role". Then have a multiple choice for your 2 roles. Create all the Options with the appropriate role assignment.
Then in the Roles & Permissions setting for those two roles, make the view option a custom rule, to only show when the field 'role' matches 'x'.
Now you have dropdown that is filtered by roles.
Cheers,
Connect it to your "Task" table, where each Option has many Tasks.
Then you have essentially created your options dropdown.
Each Option will need to be its own record, but here is where you adjust the 'visibility'.
On the Options table, you will want a 2nd field called "role". Then have a multiple choice for your 2 roles. Create all the Options with the appropriate role assignment.
Then in the Roles & Permissions setting for those two roles, make the view option a custom rule, to only show when the field 'role' matches 'x'.
Now you have dropdown that is filtered by roles.
Cheers,