Value List Verification

[tmanning]

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!

[CobaltSky]

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 ) and a "Go to Field" directed at the 'YourTargetField' field.

[tmanning]

That works wonderfully!!! Thanks!!!

[mikehkg]

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?

[-Queue-]

Use PatternCount("