Expand my Community achievements bar.

Mandated alignment between category and sub-category fields

Avatar

Level 1

8/12/22

DESCRIPTION OF NEED:

---------------------------------------------------------------------------------------------

For fields where there is a Category and a Sub-Category (example using cars: Toyota (category) Corolla (sub-category), it would be helpful if there was a custom field type that would allow for the category and sub-category to always remain in sync.


CURRENT LIMITATIONS:

  • Currently on a custom form, I can use display logic to show my sub-category only when the proper category is selected. HOWEVER this can not be accomplished on a report.
  • Currently, if I select a category and sub-category, then CHANGE the category, the data remains in the sub-category field creating invalid data.
  • Currently, there is no out of the box way to select the sub-category and have it imply the Categories above (example…. Selecting Corolla under Sub-Category would automatically infer Toyota as the Category and make the change). This is the case for either custom form or report.

Why is this feature important to you - Automated and mandated Metadata / Taxonomy conformance vs. one-off resources and time to measure and manually address

 

3 Comments

Avatar

Level 4

8/12/22

Would love taxonomy functionality in custom fields. We currently leverage company, portfolio, and program as a client taxonomy (client, brand, campaign) which still has issues of its own as a faux taxonomy, plus it limits our ability to use these as true project management functions. So many possible use cases for this!

Avatar

Community Advisor

8/15/22

This behavior can be described as "enhanced data validation" and is a long time customer request. I suggest searching the forum for prior submissions relating to data validation rules and promoting those posts so that demand for the request is not diluted across multiple posts.

Avatar

Level 10

8/16/22

Also known as "cascading fields" or "hierarchical fields." I already have an Idea submitted for this, as have others. Been a couple of years just for mine, probably longer than that overall.