Expand all | Collapse all

Copy record and edit (URL)

  • 1.  Copy record and edit (URL)

    Posted 28 days ago
    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])


    Chris Chappell

  • 2.  RE: Copy record and edit (URL)

    Posted 27 days ago
    Edited by Adam Keever 27 days 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