Skip to main content

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?

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