API Link Redirect Not Working
Hello: I'm working on an approval management app that will send a link out via email, that a non-QuickBase user can click on to change the status of a status field, then redirect to a thank you page....
Forum Discussion
Hi Mark,
I thought I messaged you, but must've not hit send. I think the above works, however, when it redirects, I get a prompt to login. How do you set the redirecting page to be public? I also tried linking externally, but that didn't work.
------------------------------
Quincy Adam
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHi Quincy,
I just did a test and it works perfectly for me. In my test I had a table set to be open to everyone on the Internet and I was able to sign out and hit a button that would edit that record and redirect to her thank you page. All while logged out with no prompt to login. Can you post your code? Maybe there's something I can see there.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi Mark,
I got it working. Thank you for your help. One last question: how do I get the email link to display as a button? I used a URL formula and checked button and also tried a regular formula and inserted into an HTML button. Neither worked. Thoughts?
------------------------------
Quincy Adam
------------------------------- MarkShnier__You
OK great. Yes, as you have discovered a regular URL field looks ugly as heck in an email and not very inviting to click.
this button information comes out of examples from Kirk Trachy and his magic buttons app. I will paste in my cheat notes directly, and you can figure it out from there. Note that the field must be formula Rich Text, and not formula URL.
var text DisplayRecordWithObsureRID = URLRoot() & "db/" & Dbid()
& "?a=dr&r=" & QB32Encode([Record ID#]);
var text URL = $DisplayRecordWithObsureRID;
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>"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
button with a larger font and floating width to accommodate the words
var text URL = [Log In URL];
var text ButtonWords = "Log In";
// Begin button style
var text bgcolor = "#34A853"; // green
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 10px; color: " & $txtcolor & "; display: inline-block; font-size: 150%; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
// End button style
"<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Hi Mark,
The buttons work in QuickBases table, but when I pull them into email, the button renders like this:
<a style="text-decoration:" none;="none;" 250px;="250px;" center;="center;" #34a853;="#34A853;" 5px;="5px;" 8px="8px" 10px;="10px;" white;="white;" inline-block;="inline-block;" normal="normal" 700="700" 24px="24px" 1="1" calibri="Calibri" ,="," sans-serif;="sans-serif;" href="https://company.quickbase.com/db/btj2wrtev?a=API_EditRecord&rid=5&_fid_8=Approved&usertoken=xxxxx&rdr=https%3A%2F%2Fcompany.quickbase.com%2Fdb%2Fbtj2wq5eb%3Fa%3DShowpage%26pageID%3D5">Approve
It's missing the closing </a> tag so it outputs as text. I'll follow-up privately with the actual button code.
------------------------------
Quincy Adam
------------------------------