2 Replies Latest reply on Jul 14, 2012 6:26 PM by xercisepro

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

    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