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,
A generic formula for an APIEdit is:
... 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
------------------------------
yes, Mike you are 100% correct
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
