URL formula to open record in edit mode

Question

Currently, the %recLink% in notifications allows the user to open the record in view mode.&nbsp; 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------------------------------

donlarson · Answer

Colleen,

A generic formula for an APIEdit is:

&nbsp; URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;apptoken="&amp;
&nbsp; $Token &amp;
&nbsp; "&amp;rid=" &amp;[Record ID#] &amp;
&nbsp; "&amp;dfid=X"&amp;;

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.&nbsp;
------------------------------Don Larson------------------------------

markshnier__you · Answer

... to add to Don's post above.
&nbsp;If &nbsp;you care about the appearance of the link in the email then you can make a rich Text formula field with this formula. &nbsp;
you can use the URL that Don suggests but I wanted to mention that the &nbsp;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. &nbsp;

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

miketamoush · Answer

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&amp;rid=15
To open in edit mode you would simply need: URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=er&amp;rid=" &amp; [Record ID#]
The important part being that the dr&amp;rid= (Display Record) is simply changed to er&amp;rid (edit record).

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

markshnier__you · Answer

yes, Mike you are 100% correct------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

simonh · Answer

you can also add `&amp;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

Forum Discussion

URL formula to open record in edit mode