Adding Filter in catalog item

askari125
Tera Contributor

Hi Everyone,

 

I have requirement that when we select choice from lookup select box field so it should filter below field.

 

For example, I have 2 fields one for "Company" and one for "Cost Center". if we select "A" choice in "Company" field, then in the "Cost Center" field the choices should be filtered out and only display the "Cost Center" which belong to "A" Company.

 

I have added screenshot for your reference that you can easily understand my requirement.

 

If anyone have solution for this please share with me.

 

Thanks,

Kind Regards

WhatsApp Image 2023-02-21 at 12.48.18 PM.jpeg

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

Assuming Cost Center is also a Lookup Select Box variable type, you need to add a Reference qualifier and Variable attribute similar to this:

BradBowman_0-1676980708601.png

Where caller_id in this example would be the name of the company field on the Cost Center variable Lookup from table in your case, and inc_caller is the name of the Company variable.