Form Rule Not Working
I have an app where we track audits. We first schedule the audit, then go back and edit the record to enter audit results. I have a form rule set up to automatically change the status field to "Not St...
Forum Discussion
Actually, I want the pop-up to show when a user opens the record to edit it, but not when they create a new record. Is that not possible? The rule conditions are "When the record is opened, and (all) Status is equal to Not Started, display a message." When a record is added, Status is equal to <<blank>> but I'm still getting the pop-up. If Status is equal to Completed, I don't get the pop-up. So I'm wondering if I cannot keep the pop-up message from showing when a record is added?
------------------------------
Jamie Owens-Knight
------------------------------
------------------------------
Jamie Owens-Knight
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIf you create a field called [Record ID# mirror] as a formula numeric field with a formula of
[Record ID#]
then unlike [Record ID#] it will be available to use in form rules.
The Record ID# will be blank when the record is in ADD mode. So you should be able to add to the rule that the [Record ID# mirror] is not blank, as that would mean the record does exists so the user must now be in EDIT mode, not ADD mode.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
[Record ID#]
then unlike [Record ID#] it will be available to use in form rules.
The Record ID# will be blank when the record is in ADD mode. So you should be able to add to the rule that the [Record ID# mirror] is not blank, as that would mean the record does exists so the user must now be in EDIT mode, not ADD mode.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------