SSL connection required when using buttons in email notification?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I have a table of of users, and I am sending each user an email notification that contains a related table of items associated with that user (user to items is a one to many relationship). Each item in the table has Formula - Rich Text buttons that contain an API_EditRecord that updates one field and then redirects to the edit form. 

All of the users have access to the app, and the app is also open to the internet. The buttons work when you are in the app (logged in or as the internet) but the buttons do not work when you click on them in the email. I get the "SSL connection required. Use HTTPS rather than HTTP" error. I think there was a checkbox in the security settings to allow non-SSL access, but I do not see that. If that is still an option, where can I find that checkbox? If not, what can I do to allow people to click buttons in the emails to edit the record? 




Here is an example item with the buttons:



Thanks for the help!
Photo of Andrew

Andrew

  • 46 Points

Posted 6 months ago

  • 0
  • 1
Photo of Harrison Hersch (QB)

Harrison Hersch (QB), Quick Base Sr. Product Manager (Platform)

  • 1,530 Points 1k badge 2x thumb
You will need to ensure all URLs are secure. We removed the checkbox you are referring to as all internet communication should be over TLS at this point. In your formula where the button exists, do you have it configured for http://?
Photo of Andrew

Andrew

  • 46 Points
Ok, thanks. I'm not sure what I would have to do for that. Here is an example of the formula:

"<a href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=XXX&_fid_24=XX&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) & "'><img src=\"XXX.png\"></a>"


Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Try this:
"<a href='https://subdomain.quickbase.com/db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=XXX&_fid_24=XX&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) & "'><img src=\"XXX.png\"></a>"

Photo of Andrew

Andrew

  • 46 Points
Great - that works! Thank you!