Dependent Dropdowns + Selective Access (hierarchy)
I am trying to create dependent drop-downs (picklists) for a Region/Sub-Region/Country hierarchy on an input dashboard, with selective access applied. Ideally, users should only be able to select Regions to which they have access, then Sub-Regions within the specified Region to which they have access, then Countries within the specified Sub-Region to which they have access.
The problem is that users have access to different levels of the hierarchy (e.g. one user may have access to an entire region, while someone else only has access to a single country.) Applying selective access + dependent dropdown gives an empty list to the low-level users, because they do not inherit access to the parents for the dropdown.
Furthermore, while Region and Sub-Region are required fields, Country is not required. This prevents us from simply requiring an entry of Country and using formulas to pull Region/Sub-Region.
Any ideas? I'm thinking I can do this by creating a second Country list (flat, with a Sub-Region property), however this would require maintaining user access to both lists and risking having them fall out of sync. I'm hoping there's a simpler solution out there that wouldn't be as annoying maintenance-wise. I really don't want to over-engineer a workaround for something that feels so simple.