Forum Discussion

FrancescoSpiga1's avatar
FrancescoSpiga1
Qrew Cadet
7 years ago

URL formula - open report in full screen - ifv=1 or windowed=1

Here's my URL formula:

"https://XXXX.quickbase.com/db/XXXX"; & 
"?a=q&qt=tab&dvqid=15&query={'58'.TV.'" & [Record ID#] & "'}AND({'57'.EX.'1'})&clist=-1.56.55.53.61.31.12.13.33.59.60.69.70.71&slist=-1.61.56.55.12.-1&opts=so-AAAAAA.gb-VV.nos.ned.nvw.qws.&formula=%5BOER+-+Vessel+Name%5D+%26+%22-%22+%26+%5BOER+-+Voy%5D&cclabel=Vsl-Voy&cctype=TX&rcform=Case(%5BCrane+Bill+Status%5D%2C%22Pending%22%2C%22%23f9c301%22%2C+%22Approved%22%2C%22%233cc151%22%2C+%22Rejected%22%2C%22%23f54400%22)"

where should I place the "ifv=1"
Any suggestions?

Francesco
App builders
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Typically it�s at the end but probably does not have to be there


    ........23f54400%22)"

    &

    "&ifv=1
  • FrancescoSpiga1's avatar
    FrancescoSpiga1
    Qrew Cadet
    7 years ago
    thank for your reply. 
    I have already tried at the end, I have also tried after the "tab&dvqid=15".... with no luck... 
    If I do it manually to the URL it works though :( 

  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    7 years ago

    Can you copy and paste the formula URL, not the actual URL


    Example: "URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=&rid=" & [Record ID#] & "&_fid_101=1"
    • FrancescoSpiga1's avatar
      FrancescoSpiga1
      Qrew Cadet
      7 years ago
      Hello Everett, that is actually the URL formula (check out the attachments).
      I am using the URL from a Report Link to create a customized report via URL formula button. The only thing that I am changing is the [RECORD ID#]. 
      Thanks in advance for your help.