Save & Redirect in a Formula URL Using API_GenAddRecordForm

Question

Hi.I have a need to "duplicate" the record and populate some fields on the new record (from the original record).It's not saving my current record before adding the new record, how do I get it to save first? I have the advanced setting turned on.This is my Formula URL Button:If(&nbsp; &nbsp; [Request] = "Include Existing Contractor + Add NEW FTE for Conversion",&nbsp; &nbsp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_GenAddRecordForm" &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_53=" &amp; URLEncode([Related Business case]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_129=60" &amp; // Softcode the Months Needed to 60 FTE&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_68=This Request is related to " &amp; URLEncode([Request]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_123=14" &amp; // Sets Request to "New FTE (Related Conversion)"&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_127=FTE" &amp; // New Employee Type&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_43=" &amp; URLEncode([Contractor PID - Dept]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_139=" &amp; URLEncode([Related Level]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_138=" &amp; URLEncode([Related Role]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_140=" &amp; URLEncode([Related Hiring Manager]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_171=1" &amp; // Start Date Override Checkbox to Yes&nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_259=" &amp; URLEncode([Record ID#]),&nbsp; &nbsp; If(&nbsp; &nbsp; &nbsp; &nbsp; [Request] = "Add New Contractor + Add New FTE for Conversion",&nbsp; &nbsp; &nbsp; &nbsp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_GenAddRecordForm" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_53=" &amp; URLEncode([Related Business case]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_129=60" &amp; // Softcode the Months Needed to 60 FTE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_68=This Request is related to " &amp; URLEncode([Request]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_123=14" &amp; // Sets Request to "New FTE (Related Conversion)"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_127=FTE" &amp; // New Employee Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_84=" &amp; URLEncode([Related Role]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_29=" &amp; URLEncode([Related Level]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_38=" &amp; URLEncode([Related Hiring Manager]) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_43=" &amp; URLEncode([New Dept1 #]) &amp; // Dept #: sets field 195 to field F&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_259=" &amp; URLEncode([Record ID#]),&nbsp; &nbsp; &nbsp; &nbsp; ""&nbsp; &nbsp; ))

markshnier__you · Answer

Are you saying you are in Add more and want to click to save the record and go back into Add mode?&nbsp;

reneehansen1 · Answer

Yes, I think so, so i'm adding a record back into the same table. So I want to save, then have the button perform genaddnewrecord (thinking this instead of just addrecord, because they *might* have something to&nbsp; edit).&nbsp;&nbsp;

miketamoush · Answer

Are you attempting this on Mobile or Desktop? If on mobile, the functionality to autosave broke a couple weeks ago and there are no updates from QB. The work around is to switch to a Formula Rich Text button with Class='SaveBeforeNavigating'. If the autosave is not working on desktop, that typically means nothing changed in the record, thus the autosave was not triggered.

reneehansen1 · Answer

On Desktop. I figured it out. :DFor anyone interested in the solution:After the form was saving, then opening the new record in edit form, I was the using the native save button from Quickbase EXPECTING it to just magically do what I needed it to do. LOL!&nbsp; I built a custom save button...and tada! magic.

Forum Discussion

Save & Redirect in a Formula URL Using API_GenAddRecordForm

4 Replies