Re: Formula Button to Save a Record, Generate Record ID & redirect to a different page

I don't have an answer for your exact question, but I do have a suggestion to try.  You can create a new field called [Duplicate Work Order# - Please save again to get next WO#].

The formula will be the List("-", ToText([Related Contract],  [Work Order#]), and set the field to be Unique.​

The effect should be that the user will attempt to save and the save will fail (thus meeting your first goal of preventing duplicate Work Orders for the same contract.  Then due to the descriptive field name, the error message the user upon the failed save will get will be instructional - ie "just try saving again".

I have not fully tested this with creating child record, but I'm pretty sure that after you get the error message the form will refresh and display.  I believe that the refreshed display will be very fresh and hence will include a valid Next Work Order which is non duplicate.

Note that the user will just use the regular save button.

However, I do not know how to control the display to a different form.  I personally try to avoid duplicate forms like the plague,  (in favor of using Form Rules), unless perhaps a Role is always locked into a Form, because its hard to control which form gets used when.

Let me know if that works to prevent dup Work Order #'s ​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------