Pass username and password in report url

  • 0
  • 1
  • Question
  • Updated 3 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

  • 844 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Is this just a URL formula? Can you post your formula?
Photo of rocketc

rocketc

  • 844 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...
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")
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")