Expand all | Collapse all

User Login via Email

  • 1.  User Login via Email

    Posted 09-03-2018 07:01
    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?

  • 2.  RE: User Login via Email

    Posted 09-03-2018 07:06
    Are you willing to expose the userid and password in the URL?

  • 3.  RE: User Login via Email

    Posted 09-03-2018 07:09
    Yes I can, as I build a separate App, only for internet users

  • 4.  RE: User Login via Email

    Posted 09-03-2018 07:14
    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.

  • 5.  RE: User Login via Email

    Posted 09-03-2018 07:34
    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 = "dfamobile1@gmail.com&password=dfamobile1%22" rel="nofollow" title="Link httpsdfaquickbasecomdbmainaAPI_Authenticateusernamedfamobile1gmailcompassworddfamobile1">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";


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

    If you only want to respond after the cycling trip, thats also fine. 

  • 6.  RE: User Login via Email

    Posted 09-03-2018 10:39
    What is the symptom of the problem now. Is it the syntax error or what exactly is the button doing or not doing now.

  • 7.  RE: User Login via Email

    Posted 09-03-2018 13:36
    Thank You so much for your assistance Mark, I actually got it right.

    xxx@gmail.com&password=xxxx&rdr=https%3A%2F%2Fxxxxxxx(application name)%2Fup%2Fxxxx(table id)%2Fg%2Frc%2Feh%2Fva%2Fphoto.jpeg" rel="nofollow">https://application name/db/main?a=API_Authenticate&username=xxx@gmail.com
    &password=xxxx&rdr=https%3A%2F%2Fxxxxxxx(application name)%2Fup%2Fxxxx(table id)%2Fg%2Frc%2Feh%2Fva%2Fphoto.jpeg

    Maybe their is a smarter way that you had in mind?

  • 8.  RE: User Login via Email

    Posted 09-03-2018 14:22
    No. That�s how I was going to suggest so I was confused why it was not working. Well done!

  • 9.  RE: User Login via Email

    Posted 09-03-2018 14:23
    Just arrived at the Airbnb. 85 km day. Lots of uphill and a few screamin� downhills.