How to exclude a choice in reference variable drop down

aryanjain27
Tera Contributor

Hii,

 

I have a variable referencing a table (Table_t) with the lookup field Column_c. I do not want a particular option to show up on the form select option (AA BB CC). I tried using the reference qual but the option AA BB CC still shows up on the form. The logic I use in the reference qual field is this. Is this implemented correctly?

 

javascript: {

"Column_c!=AA BB CC"

}

 

Any help will be appreciated

Thank you

 

aryanjain27_0-1719490135691.png

 

1 REPLY 1

Slava Savitsky
Giga Sage

First of all, remove the curly braces. They are not needed. Without the curly braces, your code should work if your Column_c is a string field. If it is a reference, you either need to use the sys_id of choice you want to remove (Column_c!=the_appropriate_sys_id) or dot-walk to the field that actually has "AA BB CC" as value (Column_c.name!=AA BB CC).