August 26, 200223 yr 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!
August 26, 200223 yr 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.
July 25, 200421 yr 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