Excluding a choice from a reference field

[rfairley22]

Hello All,

I'm editing a record producer and need to hide one of the choices on the reference field. I.e. Reference to the sys_group table, and one of the entries on that table doesn't need to be able to be chosen when the front end user is completing the form. Please help.

[bammar · Accepted solution]

Reference qualifier! go and edit the variable and then you can add in the logic of what to show

For instance lets suppose I had a list of employees and i wanted to disaplay only those with last names starting with A.

I would go to the variable and one of the options I beleive its reference qualifier will allot you to specify that only last name starts with A. 

[rfairley22]

Thank you so much!