AnsweredAssumed Answered

Dynamic validation for data entry

Question asked by kellygoldsworthy on Feb 4, 2019
Latest reply on Feb 6, 2019 by kellygoldsworthy

I am trying to figure out how I can create a dynamic drop list for data entry on a data view.

 

For example:

An Entity gets flagged for the creation of an incident.

Once flagged, various input information is required - namely: Incident Type, Incident Category and Incident Sub Category.

 

A user is required to capture this information, but ideally I do not want them to have to scroll through the full list of options. 

so.... if there is the following relationship:

 

Incident sub-category - Incident category - Incident type

 

Then it should be honored when completing the data entry.

 

The scenario should be as follows:

then:

where the "Greater than 5000" and "Less than 5000" is a child of "Shortage"

and then:

where "Lost", "Stolen" and "Correction" are children of Incident category.

 

Is this doable?

 

Thanks in advance.

Outcomes