URL button code
I used something I found in magic buttons to create a button that allows an EOTI user to submit a form and then direct to a 'Request Received" html page. This button automatically saves and redirects ...
Forum Discussion
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
------------------------------
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
------------------------------
- I didn't refresh my screen and see this other response before I replied! I'll read through it and see if I can adapt.
------------------------------
Mike Tamoush
------------------------------- Good news is that I got this to work, bad news is that it only works for one record ID since the HTML will only interpret static references and does not compile URLRoot(), Dbid(), and [Record ID#] functions and attributes....
Date field is empty:
And here is the code that performs this:
<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; onclick='$("#saveAndKeepWorkingMenuOption").click();' href=https://YOUR_REALM.quickbase.com/db/YOUR_DBID?a=API_EditRecord&apptoken=YOUR_APP_TOKEN&_fid_20=Approved&_fid_19=Today&rid=3&rdr=https%3A%2F%2FYOUR_REALM.quickbase.com%2Fdb%2FYOUR_DBID%3Fa%3Der%26rid%3D3">Approve</a>
------------------------------
Adam Keever
------------------------------
