Skip to main content
Question

Dynamic Form Rules - when record is saved - requires field exit

  • June 30, 2017
  • 0 replies
  • 155 views
I am trying to check a field upon saving the form: if Field X <> 100% then show a message and abort the save.  The dynamic form rule "when the record is saved (after checking)" does not recognize the changes made in Field X if the user clicks Save before exiting the field.  The form rule recognizes the previous value, even though the record saves with the new value.  Is there any way to safeguard against this?  I want to prevent my users from saving inaccurate data, but I can only abort the save based on the field value if they exit the field first so the form rule can recognize it.  Anybody have any ideas?  Thanks.
    This topic has been closed for replies.

    • JohnThomas
    • Registered
    • July 4, 2017
    When the record is saved
    and all of the following conditions are true
    Percentage is not equal to  100

    Action
    abort the save "Not 100 Change to 100"
    change percentage to empty // Records which having already values.

    i hope this will solve your issue !!
    Thanks for the reply John!  This triggered perfectly...once.  If I click Save a second time without changing anything it goes right ahead and saves it.  Upon closer examination, the "change percentage to empty" is not happening on the form.  I tested it with "Fire change options only when something changes" both checked and unchecked.  I tested it with changing the percentage to empty and to "0".  It always triggers the first time (without exiting the cell), which it didn't before, but it isn't doing it a subsequent time and I have to believe I'm doing something wrong with the change action because I don't see it changing.  Any thoughts?

    Here's my rule:
    When the record is saved after checking
    and percentage is not equal to 100
    abort the Save "Not 100 Change to 100"
    change percentage to 0
    • MCFNeil
    • Registered
    • July 6, 2017
    percent fields are not 100, but rather 1 displayed as 100%.  Try adjusting the rule to be <> 1
    Thanks for the suggestion Matthew.  I tried it but no change.  I'm testing with a value of 90, which is neither 1 nor 100, so it should trigger no matter what, and it still does initially, but not subsequently.
    I have seen bugginess with another forum poster trying to trigger on percentage field sand suggested that the go to QuickBase support.

    On idea to try is to make a formula field of the percentage field times 100 and set it to be a plain numeric formula field (not a percentage) and see if that works.
    The answer turned out to be that I needed "when the record is saved"...without the "(after checking)".  I'm not sure that I understand why this change fixed it but it works perfectly now.
    Terms & ConditionsAccessibility statement