Forum Discussion
MarkShnier__You
Qrew Legend
@Christopher Greene
The SaveBeforeNavigating syntax is known to fail i.e. (causing that pop up) if the only change to the record was In Grid Edit. I have found that it works reliably if the Parent record is changed. What I finally settled on which works perfectly is to make to helper fields on the form. One is called [Dirty the record] and the other one is called [Dirty the record plus 1]. The latter is a formula field obviously equal to
[Dirty the record] +1`
I then have a form rule set to fire all the time where if those two fields are not equal I change [Dirty the record] to be equal to the value in the field [dirty the record plus 1].
In your post above you are claiming that save before navigating fails even if both the parent and the child have been modified. In my experience that is not how it behaves. Try putting in that form rule and see if it solves the problem.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
The SaveBeforeNavigating syntax is known to fail i.e. (causing that pop up) if the only change to the record was In Grid Edit. I have found that it works reliably if the Parent record is changed. What I finally settled on which works perfectly is to make to helper fields on the form. One is called [Dirty the record] and the other one is called [Dirty the record plus 1]. The latter is a formula field obviously equal to
[Dirty the record] +1`
I then have a form rule set to fire all the time where if those two fields are not equal I change [Dirty the record] to be equal to the value in the field [dirty the record plus 1].
In your post above you are claiming that save before navigating fails even if both the parent and the child have been modified. In my experience that is not how it behaves. Try putting in that form rule and see if it solves the problem.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
ChristopherGre3
3 years agoQrew Trainee
Mark,
Your provided solution works great when only the embedded child records themselves are edited when the main parent record is not necessarily changed.
Thank you for the helpful tip. Much appreciated.
CGreene
------------------------------
Christopher Greene
------------------------------
Your provided solution works great when only the embedded child records themselves are edited when the main parent record is not necessarily changed.
Thank you for the helpful tip. Much appreciated.
CGreene
------------------------------
Christopher Greene
------------------------------