Discussions

 View Only
  • 1.  Copy record and edit (URL)

    Posted 03-12-2020 12:38
    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
    ------------------------------


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

    Posted 03-13-2020 10:08
    Edited by Adam Keever 03-13-2020 10:08
    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
    ------------------------------