User Login via Email

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
HI There, has anyone created a URL button, which is sent via an email notification, and when the user (the user is not a quickbase user) click on this button , the button will automatically login to quickbase (Internet Role used for viewing photos) and show relevant record. It works fine when the user is logged in, but when the cache is cleared and the user clicks on the link it takes me to the login screen, and I need the button to automatically login?
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
  • Frustrated

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Are you willing to expose the userid and password in the URL?
(Edited)
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
Yes I can, as I build a separate App, only for internet users
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
I can help you slowly now (as I’m traveling on a cycling trip and it’s difficult to type and pedal 100 km at the same time ) to provide the syntax to authenticate and then re-direct to your record but why don’t you just make the whole app open to everyone on the Internet?

You can search for the special user called

Everyone on the internet

You may need to set your Realm Account Permissions to allow that.
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
Please don't fall off, I don't want to be responsible hahaha...I am happy with "opening up the app to the whole internet" as it will only be used to view a photo of a planner via an Outlook Calendar invite (we use this link for a Landlord to verify the correct person arrive on site to do a survey). I have already switched off the Account Permissions.

I get to this url button, but I am making a mistake somewhere? But maybe you have a shortcut to do this.

var text URLONE = "https://dfa.quickbase.com/db/main?a=API_Authenticate&username=dfamobile1@gmail.com&password=...;

var text URLTWO = "https://dfa.quickbase.com/up/bnyfcsqua/g/rb/eh/va/MaraisDeWet.jpeg";

$URLONE

& "&rdr=" & URLEncode($URLTWO)

If you only want to respond after the cycling trip, thats also fine. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
What is the symptom of the problem now. Is it the syntax error or what exactly is the button doing or not doing now.
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
No. That’s how I was going to suggest so I was confused why it was not working. Well done!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Just arrived at the Airbnb. 85 km day. Lots of uphill and a few screamin’ downhills.