Discussions

Expand all | Collapse all

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

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

    Posted 02-01-2019 06:47
    Here's my URL formula:

    "https://XXXX.quickbase.com/db/XXXX"">https://houstonterminalllc.quickbase.com/db/bn9gvy2mv"">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


  • 2.  RE: URL formula - open report in full screen - ifv=1 or windowed=1

    Posted 02-01-2019 09:38
    Typically it�s at the end but probably does not have to be there


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

    &

    "&ifv=1


  • 3.  RE: URL formula - open report in full screen - ifv=1 or windowed=1

    Posted 02-01-2019 14:28
    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 :( 



  • 4.  RE: URL formula - open report in full screen - ifv=1 or windowed=1

    Posted 02-01-2019 22:40

    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"


  • 5.  RE: URL formula - open report in full screen - ifv=1 or windowed=1

    Posted 02-02-2019 05:26
    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.