How to set field dependency in a record producer.

Samuel Rubens2 · ‎09-20-2019

what's up guys
How to set field dependency in a record producer.
I have two fields:
Business service
category
The category displayed depends on the business service selected.
This dependency is set in the incident form and works perfectly.
But I need that to work in the catalog too.

I found quite old articles and links in the community that don't seem to apply to current versions.

thanks for the help

Frank · ‎09-20-2019

Hi Samuel,

I just recent did something similar. In my case the secondary field is dependant upon which assignment group is selected in the primary field. 1st field is a reference and the 2nd is a lookup select box on the sys_choice table. In the type specification of the dependant field I specify sys_choice, the table name, lookup value field is value. In the reference qualifier I have:

javascript:'name=assignment_group^element=subcategory^language=en^inactive=false^dependent_value=' + current.variables.assignment_group

Attribute would be:

ref_qual_elements=assignment_group

Element will depend up what set of choices you'd want to display. Assignment_group is the primary field variable name.

Hope this helps,

Frank

View solution in original post

Masarrat Siddi1 · ‎09-24-2019

If the values are fixed and not coming from any table, you can go with client script. For values are coming from any table or in other words if you are using lookup select box, you can apply the reference qual.

Thanks!!