Form based on groups
Permalink Browser Info Environment
Hi
I have a situation and was wondering if there is a way to do this with advanced forms/data display. I've been playing around with it but can't figure if this is even possible, or what the best way to do it would be. So this is the setup:
1. Different managers within the company have vehicles they are responsible for so I have a form where they add vehicle details.
2. Under each manager is a group of drivers
3. I have a form for drivers to fill for vehicle inspections with drop down list populated by registration number from the add vehicle form
is there a way to limit vehicles visible in drop down on driver form to only those their manager put in? Or if I create groups with all drivers in that group with their manager is there a way to limit what is on the form that way?
I would have up to 20 groups so I'm trying to think of the most efficient way to do it.
Thanks in advance for anyone even taking the time to think about how this could be done!
Adam
I have a situation and was wondering if there is a way to do this with advanced forms/data display. I've been playing around with it but can't figure if this is even possible, or what the best way to do it would be. So this is the setup:
1. Different managers within the company have vehicles they are responsible for so I have a form where they add vehicle details.
2. Under each manager is a group of drivers
3. I have a form for drivers to fill for vehicle inspections with drop down list populated by registration number from the add vehicle form
is there a way to limit vehicles visible in drop down on driver form to only those their manager put in? Or if I create groups with all drivers in that group with their manager is there a way to limit what is on the form that way?
I would have up to 20 groups so I'm trying to think of the most efficient way to do it.
Thanks in advance for anyone even taking the time to think about how this could be done!
Adam
| Type: | Discussion |
|---|---|
| Status: | New |
1. Create Department 1, Dept 2 ... Dept 20 as user groups
2. Assign manager and drivers in each department to user groups
3. On the page to be used by drivers:
3.1 Create Data Display block 1, DD block 2 ... DD block 20
3.2 Add a filter for each data block to display records for corresponding department, e.g. on DD block 1 add filter by field "Department" where value is "Department 1"
3.3 Using advanced permissions, make each block visible to relevant department, e.g. DD block 1 visible to Dept 1
Alternatively, you could use advanced permissions at page level with each page containing a filtered block.