Skip to main content
Question

URL formula to open record in edit mode

  • March 28, 2024
  • 0 replies
  • 614 views

Currently, the %recLink% in notifications allows the user to open the record in view mode.  What URL can be used in a notification to open the record in edit mode?

Bonus points if the user can be pointed to a particular form (in edit mode).

Thank you!



------------------------------
Colleen Burch
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+15
    • DonLarson
    • Registered
    • March 28, 2024

    Colleen,

    A generic formula for an APIEdit is:

      URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken="&
      $Token &
      "&rid=" &[Record ID#] &
      "&dfid=X"&;
    You will have to replace the Dbid() with the actual table
    Replace the X with the Form to land on
    Include the real Token if your realm requires it. 


    ------------------------------
    Don Larson
    ------------------------------
    Forum|alt.badge.img+20
    • MikeTamoush
    • Registered
    • March 29, 2024

    Mark/Don,

    I might be misunderstanding, but I don't think she is asking for the edit record API. The %reclink% simply views the record:

    ie: https://mydomain.quickbase.com/db/bpupp97bm?a=dr&rid=15

    To open in edit mode you would simply need: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]

    The important part being that the dr&rid= (Display Record) is simply changed to er&rid (edit record).



    ------------------------------
    Mike Tamoush
    ------------------------------

      Terms & ConditionsAccessibility statement