Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Check if field value is in value list via script?

Featured Replies

Hello,

I have a few popup lists. I would like to check if the data the user entered is in a value-list.

I'm using something like this to do this in script and it works almost perfect.

if [ PatternCount ( ValueListItems ( Get (Filename) ; "StatusTypeValueList" ; Tasks::Status ) = 0 ]

set field [ Tasks::gMatched ; 0 ]

else

set field [ Tasks::gMatched ; 1 ]

end if

Code elsewhere does something with the gMatched to display a message and/or so on.

So, suppose I have in my StatusTypeValueList the following values : Open, Closed, Pending

If I click in the drop down list of the status field in a task layout, I can pick any of these - but if I am crafty, I can also type in something different. If I type in "Op" (no quotes) or "Close" , then my test above will still pass. I want it to only match the exact item in the list - so it must be "Open" and "Closed" which are typed.

What do I have to change to get it to only match items in the list?

thanks for your help in advance,

Sincerely,

J__

Add a pilcrow to the search term:

if [ PatternCount ( ValueListItems ( Get (Filename) ; "StatusTypeValueList" ) ; Tasks::Status & par.gif ) = 0 ]

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.