Forum Discussion

ChrisChappell's avatar
ChrisChappell
Qrew Member
6 years ago

Copy record and edit (URL)

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
------------------------------
APIs and custom code
Button
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    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
    ------------------------------