Forum Discussion

ColleenBurch's avatar
ColleenBurch
Qrew Trainee
2 months ago

URL formula to open record in edit mode

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
------------------------------

5 Replies

  • DonLarson's avatar
    DonLarson
    Qrew Commander

    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      ... to add to Don's post above.

       If  you care about the appearance of the link in the email then you can make a rich Text formula field with this formula.  

      you can use the URL that Don suggests but I wanted to mention that the  dbid() will work fine for the link as long as the link is for the record that triggered the notification.

      Var text URL= "insert the code from Dan above";

      var text ButtonWords = "Click here to Update ETD and ETA dates";

      // Begin button style
      var text bgcolor = "#34A853";
      var text txtcolor = "white";
      var text style = "style=\"text-decoration: none; width: 250px; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 10px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
      // End button style

      "<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>"

      you can probably guess your way around the parameters in that button to change the background color or the font color.  



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------

  • 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
    ------------------------------

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend


      yes, Mike you are 100% correct



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
    • SimonH's avatar
      SimonH
      Qrew Cadet

      you can also add `&dfid=_X_` to direct to a specific form, but note that they wont stay in that form so after they click save the record will save and open in the users default form