How to add default filter in Reference Field

[Steveanner]

Hello Community,

We have a primary goal field in the program form, and when we click the reference field, it should display the records with the default active is true record. Could anyone know if there is any possibility to setup default filter in the reference field.

Thanks,

Steve An

[Community Alums]

Hi @Steveanner ,

If you are doing this on a field on a form, you use a feature known as a reference qualifier.

In your case, please use this in the reference qualifier of Primary Goal field

this table has active field; you can try using that

javascript: 'active=true';

[ralvarez]

Yes, it’s possible to apply a default filter to a reference field, without using the reference qualifier, and therefore allowing the user to modify the default condition.

I’ve explained the working solution here.

Hope it helps!