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?