Reference Qualifier - How to return no rows when dependent field is empty

[kani1]

Hi,

I have 3 fields on the form

1) Category

2) Tier 1

3) Tier 2

Tier 1 is dependent on Category and Tier 2 is dependent on Tier 1.

I implemented a simple reference qualifier which works fine. Only issue that if Category is null (On form load during insert), Tier 1 returns all the rows. Is there a way to restrict not to return any rows for Tier 1 when Category is empty. Please provide some insights on this.

[zica]

The type of the field tier 1 should be string. Same for tier 2

Then under dependend field, chose category for tier1 and tier1 for tier2

Kind regards,

ZA

Do not feel shy to mark correct or helpful answer if it helps or is correct

[zica]

or type = 'choice' if you want to have a dropdown list

[kani1]

Thank you for your help on this. Tier 1 and Tier 2 should be a reference field as I have to reference other table to get their values. It appears to me that Reference qualifier works in such a way that if dependent on field is empty, dependent field always returns all the rows. I am not finding a way to return empty in this case.

[zica]

HEllo,

Could you please send a screenshot of the form with these 3 fields ?

I have one idea...

Why don't you hide tier1 field until the category is empty and hide tier 2 until tier 1 is not filled out ?

That could be done from client script or just ui policy.

What do you think about it ?

Let me know if you need help for the script, I will be glad to provide it to you

Kind regards

ZA

Do not feel shy to mark correct or helpful answer if it helps or is correct

[kani1]

I implemented through onchange client script and script include. It works for me. Thank you for following up on this