Are cascading value lists possible?
A cascading Value List (or what I once knew as a Combo Box), is a hierarchical linkage of selection options. Sure, a Multi Ref field is possible but that isn't quite what I am looking for.
The scenario may be this: Within an app, having an Inherited Record Permission Field that has 3 names as a result. Then in the same application being able to have a a Value List Dynamically allow for selection of only those three names.
Yes, there are caveats to this (like disappearing selections in the end VL), but that is actually to be expected.
What my specific scenario is:
Within an Audit Engagement, I assign a Manager, Lead, and Staff through RP fields. Cross referenced to an Engagement is the Work Paper application. I would like to assign a work paper to only someone who has been assigned on the audit (not iterate through the entire List of users defined in the user selection field or RP field in the Work paper application). I'd like to be able to reference the inherited RP from Engagements for the options to choose from on Work Papers.
See here on the engagement the RP Fields where Manager, Lead, and Staff are assigned:
Then within these WPs (which are a CR to the Work Papers Application I have IRP fields:
Now if I wanted to make a drop down selection (a VL) to select who is assigned to this specific section, I'd want the only options to be those listed in the IRP fields staff or lead.
Any creative solutions?
- Community Thread
- Forum Thread
- inherited record permissions
- record permisssions
- RSA Archer
- RSA Archer Suite
- user list
- Values List