URL Button to save and edit record

Question

I am currently trying to build a url button that saves and edits a record simultaneously. The issue I ran into at first was the record was not completely saved so QuickBase didn't recognize it as a result couldn't edit the record. Now I got the record to save however now its not editing. Providing my formula below - any help would be greatly appreciated. Thanks

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&apptoken=XX3&dfid=10&_fid_3=" & URLEncode ([Record ID#])& "&z=" &
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=XXX"
& "&_fid_134=1"&
"&rdr=" &
URLEncode (XXXXX a=showpage&pageid=12")

------------------------------
Wallace (DHS)
------------------------------

markshnier__you · Answer

Is there a good reason that you want to first add a record and then edit it?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

wallace__dhs_ye · Answer

Yup, so I have a default form that is set to be seen when users edit records and another form that users see when they add records. This form with this URL button is on the form used when users add record. So if the record is just saved it takes users to the wrong form - that's why I was looking to accomplish both actions with the URL button

------------------------------
Wallace (DHS)
------------------------------

markshnier__you · Answer

I still really don't understand.&nbsp; Do you want to use her to add a record and then are you saying you want to learn the user on that record and view mode on a certain form or land the user in edit mode on a certain platform. And then why are you redirecting to her page after that? I am still quite confused about the workflow you were trying to achieve.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

wallace__dhs_ye · Answer

So I have two forms in a table. One used to add new records and the other a default form that is used to edit records. The problem is I need QuickBase to change a checkbox to checked on the form that is used to add new records - but currently Quickbase is not letting me do both simultaneously with the button formula (add the record and edit to checked). Not sure if that clears things up a bit------------------------------Wallace (DHS)------------------------------

markshnier__you · Answer

Try putting that field on the form in a field hidden by a form rule and changing the URL to thisURLRoot() &amp; "db/" &amp; [_DBID_TABLE_1] &amp; "?a=API_GenAddRecordForm&amp;apptoken=XX3"&amp; "&amp;dfid=10"&amp; "&amp;_fid_3=" &amp; URLEncode ([Record ID#])&amp; "&amp;_fid_134=1"&amp; "&amp;NextURL=" &amp;&nbsp; URLEncode (XXXXX a=showpage&amp;pageid=12")------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

URL Button to save and edit record