AnsweredAssumed Answered

How find records with fields whose values are no longer in a changed value list.

Question asked by eliotros on Nov 11, 2015
Latest reply on Nov 11, 2015 by user19752

Here's what I tried.  I set the fields to Always Validate using the new Value Lists.   I created a script with one step: Commit Record.  And I trigger that script with OnRecordLoad.  I expected that as I stepped thru the records (using Ctrl-downArrow), I'd get an error message when a record had invalid data (so I could revise it).  I get no messages.

 

What am I missing?  I thought I read somewhere that Committing a record triggered data validation.  Are fields only validated if they were changed?  If so, can I set each field equal to itself using SetField?  Or pre-pend an "x" and then delete it?  This doesn't seem very elegant.  Is there a better way?  Thanks!    (FMP Pro Adv 13.0v5)

Outcomes