Skip 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.

Value List Verification

Featured Replies

Is there a way to verify that a person chose a value from a value list via script? For reasons too long to explain here, I cannot use field validation on this project so all validations are done by scripting. Thanks!

Yes, you will need to include an "If [ ]" script step with a validation test, using a formula along the lines of:

+ If [PatternCount(ValueListItems("YourDatabaseName.fp5", "YourValueListName"), YourTargetField)]

Followed by a "Show Message" step (with appropriate admonishment for the user smile.gif ) and a "Go to Field" directed at the 'YourTargetField' field.

  • Author

That works wonderfully!!! Thanks!!!

  • 1 year later...
  • Newbies

Actually, this verification fails if the user i entering an shortened version of the Value List Item as long as it is still matching the pattern count; e.g. if the ValueList item says "Green Potatoes" but the user deletes the word "Potatoes" from the entry, the above solution would still approve the entry.

The only way i found until now to 100% ensure the entry conforms with the Value List is a related file where the ValueList takes its values from, and the Verification Script counts the matched records and OK's it only if there IS a matching entry n the related file (it also works ith not isvalid).

Does anybody has an easier solution for this?

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.