Question

Lookup Filter against Custom Field on ContactUser

  • 14 December 2023
  • 1 reply
  • 73 views

Badge +1

We created a custom Single-Select field on our contact user forms.
We want to use the values in a Lookup Filter expression on our forms to restrict the results of our Single-Select Contact User field but cannot find the correct syntax to include:

We’ve tried multiple variations like below:
FROM usr as contactUser WHERE contactUser.$W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’

FROM usr as contactUser WHERE contactUser.$new.W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’

Currently on version 11.6.3 of assyst.

Any ideas?


1 reply

Badge

From my understanding you cannot base visibility expression on the system single select field. If you try using the custom version it should work.

https://wiki.axiossystems.com/assyst11-7Wiki/index.php/Expressions_and_Filters_in_assyst#The_Scope_of_Expressions

Reply