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.

[nidhi_batavia]

Hello,

Can you please share the script for this. I have same requirement

[renaud3]

Hello, it's an old post but I had the same requirement and did something like:

In the script include as ref qualifier:

if (current.category != '') {

        //create your code to return the desire filter

        return filter;

}

else {

      return "sys_idIN"; //it will return nothing.

}

Regards

Renaud

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