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

Question

I am trying to check a field upon saving the form: if Field X &lt;&gt; 100% then show a message and abort the save. &nbsp;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. &nbsp;The form rule recognizes the previous value, even though the record saves with the new value. &nbsp;Is there any way to safeguard against this? &nbsp;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. &nbsp;Anybody have any ideas? &nbsp;Thanks.

johnthomas · Answer

When the record is savedand all of the following conditions are truePercentage is not equal to &nbsp;100Actionabort the save "Not 100 Change to 100"change percentage to empty // Records which having already values.i hope this will solve your issue !!

richardpfister · Answer

Thanks for the reply John! &nbsp;This triggered perfectly...once. &nbsp;If I click Save a second time without changing anything it goes right ahead and saves it. &nbsp;Upon closer examination, the "change percentage to empty" is not happening on the form. &nbsp;I tested it with "Fire change options only when something changes" both checked and unchecked. &nbsp;I tested it with changing the percentage to empty and to "0". &nbsp;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. &nbsp;Any thoughts?Here's my rule:When the record is saved after checkingand percentage is not equal to 100abort the Save "Not 100 Change to 100"change percentage to 0

mcfneil · Answer

percent fields are not 100, but rather 1 displayed as 100%. &nbsp;Try adjusting the rule to be &lt;&gt; 1

richardpfister · Answer

Thanks for the suggestion Matthew. &nbsp;I tried it but no change. &nbsp;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.

quickbasecoachd · Answer

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.

Forum Discussion

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

Related Content

Dynamic Rule - Or statement?

Master’s Thesis: Request for Quick Feedback on Low-Code Platform Requirements

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Record Details