Hi All,
Thank you for any help you can provide. Here is my scenario:
- I want users to be able to define their organizational hierarchy without defining the structure for them as every company does it differently (e.g., Organization, Division, Dept, etc.). I have 6 tables called Level 1, Level 2, etc. Therefore one company may use Level 1 as their Organization while another may use it for Division. This works fine.
- Next, I have a DEFAULT table that stores values that will be used throughout the application, and I have included 6 fields called Level 1 Label Name, Level 2 Label Name… where the user can define up to 6 level names that fit their structure. It works fine - I can pull the DEFAULTS into any table.
- Finally, I would like to use the Display Rules Feature on the page to ReName the labels using the values in the default so that when the user enters the info, it says, for example: ORGANIZATION instead of Level 1 Name, but when you try to relabel, you can only put in a custom value and cannot insert a field (text formula).
- Any recommendations on how this can be accomplished? Maybe I’m making this harder than it needs to be. I am open to suggestions and can provide screenshots if that would help.
- Thank you.