URL Button to edit record and return to original launch screen

Question

Hello,I'm trying to get a url button from a report to edit a record and return to the original launch point. This is my code. The edit works, but I cant get the screen to refresh.&nbsp;var text ReturnToOriginalLaunchPoint = "https://xxx.quickbase.com/db/xxx?a=q&amp;qid=74";URLRoot() &amp; "db/"&amp; Dbid() &amp; "?act=API_EditRecord&amp;apptoken=xxxxx&amp;rid=" &amp; [Record ID#] &amp; "&amp;_fid_6=" &amp; URLEncode(1)&amp; "&amp;NextURL=" &amp; URLEncode($ReturnToOriginalLaunchPoint)I get an error message..
This XML file does not appear to have any style information associated with it. The document tree is shown below.

&lt;qdbapi&gt;

&lt;action&gt;API_EditRecord&lt;/action&gt;

&lt;errcode&gt;0&lt;/errcode&gt;

&lt;errtext&gt;No error&lt;/errtext&gt;

&lt;rid&gt;660&lt;/rid&gt;

&lt;num_fields_changed&gt;0&lt;/num_fields_changed&gt;

&lt;update_id&gt;1655872xxxx&lt;/update_id&gt;

&lt;/qdbapi&gt;

------------------------------Jamil Idun-Ogde------------------------------

petejames · Answer

I think what you need is detailed here:https://community.quickbase.com/blogs/evan-martinez1/2019/12/06/using-ampzamprurl-and-rdr-in-formula-url-fieldsSpecificallyURLRoot() &amp; "db/" &amp; [_DBID_TASKS] &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;_fid_7=Approved" &amp; "&amp;rdr="&amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl())Make sure you tick Open Target in Same Page------------------------------Pete James------------------------------

jamilidun-ogde · Answer

Thank you so much Pete.It worked!------------------------------Jamil Idun-Ogde------------------------------

Forum Discussion

URL Button to edit record and return to original launch screen