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 p...
Forum Discussion
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
Qrew 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
------------------------------
