Pass username and password in report url

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a hyperlink that links to a Quickbase report. Is it possible to add user authentication into this link? My purpose....if I click on the link and I'm not already signed into quickbase....I want to go directly to the report....I do not want to have to click on the link then sign into qbase....

thanks for any advice
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Is this just a URL formula? Can you post your formula?
Photo of rocketc

rocketc

  • 774 Points 500 badge 2x thumb
Mark, no formula...just a URL (https://domain.quickbase.com/db/qbasetableid?a=q&qid=reportid) ...we like to add my authentication info....so I can go directly to report without signing into quickbase...
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
try this

vat text Authenticate = "h t t ps://mycompany.quickbase.com/db/main?act=API_Authenticate&username=myuseridgoeshere&password=mypassword goes here"

& "&rdr=" & URLEncode(urlroot() & "db/" & [_DBID_TABLE] & "?a=q&qid=xx")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Edited answer

"h t t ps://mycompany.quickbase.com/db/main?act=API_Authenticate&username=myuseridgoeshere&password=mypassword goes here"

& "&rdr=" & URLEncode(urlroot() & "db/" & [_DBID_TABLE] & "?a=q&qid=xx")