How to exclude a choice in reference variable drop down
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2024 05:15 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2024 07:11 AM - edited 06-27-2024 07:12 AM
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).
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/