Skip to main content
Question

Copy record and edit (URL)

  • March 12, 2020
  • 0 replies
  • 36 views
Forum|alt.badge.img
I have created a URL to copy the record the user is in, however, it stays on the original record.  Is there any way to change the formula to go to the new record once it's created?  The formula is:

URLRoot() & "db/" & Dbid() & "?act=API_AddRecord"
& "&apptoken=psudc7dxr3x76cra11pz11raxm6a"
& "&_fid_11=" & ToText([Related Record])
& "&_fid_10=" & "20"
& "&_fid_6=" & ToFormattedText([Issue Date], "DDMMYYYY")
& "&_fid_7=" & ToText([Reason])
& "&_fid_14=" & ToText([Survey Status])
&"disprec=1";

Thanks,
Chris

------------------------------
Chris Chappell
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • March 13, 2020
Try removing the semicolon and adding this to the end Chris

& "&rdr="
& URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))

If you haven't seen it yet, you should check out the ABC Magic Buttons app by @Kirk Trachy​ in the app exchange. It has many examples of URL buttons and that is where I got the above code from. If you want to land on the record form in edit rather than display, change the "a=dr" to "a=er".

------------------------------
Adam Keever
------------------------------
Terms & ConditionsAccessibility statement