URL button code

Check this video from Kirk Trachy out:

Pop up messages

------------------------------
Adam Keever
------------------------------

I'm glad you asked this question. After having seen Kirk's video and pondered your use case, I found that you can add an HTML button with an href to the URL of an HTML button to edit fields in a form and redirect back to the same form in edit mode.

First I made a formula rich text button to fill in the status as "Approved" and log the approval date:
"<a style=\" text-decoration: none; background: #00ff00; border: 10px solid #00ff00; border-radius: 3px; color: #000000; display: inline-block; font: normal 700 20px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none; href='"&
URLRoot() & "db/" & Dbid() & "?\n\na=API_EditRecord&apptoken=YOUR_TOKEN_HERE &rid=" & URLEncode ([Record ID#])

& "&_fid_20=Approved"
& "&_fid_19="& "Today"

&"&rdr=" & URLEncode(

URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) & "''>Approve</a>"

Next I added a dynamic form rule to display a message when the date field is not equal to blank and used this in the message body:
<a style= "text-decoration: none; background: #00ff00; border: 10px solid #00ff00; border-radius: 3px; color: #000000; display: inline-block; font: normal 700 20px/1 "Calibri", sans-serif; text-align: center; text-shadow: none; href="https://YOUR_REALM.quickbase.com/db/YOUR_DBID?a=API_EditRecord&apptoken=YOUR_APP_TOKEN%20&rid=3&_fid_20=Approved&_fid_19=Today&rdr=https%3A%2F%2FYOUR_REALM.quickbase.com%2Fdb%2FYOUR_DBID%3Fa%3Der%26rid%3D3">Approve</a>

When date is blank:

When date is not blank:


------------------------------
Adam Keever
------------------------------