AnsweredAssumed Answered

Ability to determine when field validation is triggered when a script is running whether the user...

Question asked by xercisepro on Jul 6, 2012
Latest reply on Jul 14, 2012 by xercisepro

Summary

Ability to determine when field validation is triggered when a script is running whether the user chose "Revert Field" or "Yes"

Product

FileMaker Pro

Version

ALL

Operating system version

All

Description of the issue

see: https://fmdev.filemaker.com/message/87366#87366

If you have validation for a field with that user given the ability to override there is no way to determine the difference between the user selecting "Revert Field" or "Yes" (Override) while a scrip is running. Get( RecordModificationCount) doesn't increment on a new record when the user choses "Yes" which is by rights then modifying the record. If it incremented by one then we could determine if the user chose "Revert Field" (no increment) or "Yes" (Incremented by one).

Steps to reproduce the problem

See file attached to: https://fmdev.filemaker.com/message/87366#87366

1. Create new record Get(RecordModificationCount) = 0
2. Add data to field that violates validation
3. Commit record
4. Select "Yes" to override field validation
5. Get(RecordModificationCount) =1

Repeat
Step 1-3 (Make sure you start with a new record)
4. Select "Revert Field"
5. Get( RecordModifcationCount)=0

Expected result

Get(RecordModificationCount) =1

Actual result

Get(RecordModificationCount) =0

Exact text of any error message(s) that appear

NA

Configuration information

NA

Workaround

See first post of discussion: https://fmdev.filemaker.com/message/87366#87366

Outcomes