Discussions

Expand all | Collapse all

Print Multiple Exact Forms

  • 1.  Print Multiple Exact Forms

    Posted 12-09-2019 14:09
    I know this has already been covered in a previous post quite a while back and just wanted to re open it in a separate post to see if I can get some help with my specific use case. Here is the old post:
    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30308&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer


    For my situation, here is my setup at the moment:
    Work Requests>Poles>Field Work

    Work Requests have many poles and each pole has 1 field work record. I would've liked to put all field work info in the poles table but the field work table has over 500 fields in it and was a big endeavor at the time of creation so it was separated at the beginning and has a 1 to 1 relationship with poles. My exact form prints locate sheets in a particular format and is within the field work table and each pole will have 1 locate sheet. I want to be able to print all the field work locate sheets for the poles of a work request straight from the grandparent work request table via URL button.

    Some things I've tried->
    I noticed on an ask the user report that "&nv=1&v0=75138760" was at the end of the URL after the qid and I tried combining the print URL with this to make:
    https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760

    ..to see if it would print multiple exact forms this way but it shows the exact form for a split second then just turns into a blank white screen, so I'm not sure what else I could do. I can't figure out a good way to make the report necessary to make the normal qid print method mentioned by Keith Jusas to work.

    Any suggestions?

    Thanks in advance,

    #Forms
    #Button
    #APIsandcustomcode
    #Formulaandfunctions​​​​​​

    ------------------------------
    Jordan McAlister
    ------------------------------


  • 2.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 14:24
    Have you tried this Syntax but with your own Realm name and your own page name for the exact form - I also assume that you are using the native Quick Base Exact Forms and not the Juiced Exact Forms Plus.  for the qid for testing purposes you should just make a report to do one particular group of records to get the multiple record print working, and then a separate step will be to make this more generic.  For that sfid parameter, I assume that will be visible when you print 1 exact form.

    https://juicedtech.quickbase.com/db/bdht34muk?a=dbpage&sfid=109&pagename=PurchaseOrder.html&clist=a&qid=1


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 14:38
    yes, I have tried this syntax and I am using the native exact forms and everything works as it should if the filter is specific for the report, so for instance, i set the filter to equal a certain work request number for testing and it printed all the locate sheets for that specific work request number, but instead of a single defined work request number, I need that filter the change based on what work request I am viewing.

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 4.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 14:50
    So what you would do is to make an <ask the user. report which needs an answer, and then make the URL to run that report and answer its own question.

    The URL would look like  I'm not sure which fields is answering the question but it would look something like this.


    https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=" & [Related XYZ]   

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 15:03
    yes, I have this created already and I tried to combine it with the multiple print url (https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&pagename=Locate%20Sheet.html&clist=a&qid=WR#)and couldn't get it to work.

    The following is a combined URL that doesn't work:
    https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 6.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 15:34
    can you post your formula for the URL?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 15:43
    I haven't made a URL formula field yet, I am still trying to figure out a way to let the field work table know what work request I'm viewing. I trying to set this up currently through a single record table and just transferring the WR# I need through that, but I am having trouble. 

    https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23  
    works well by itself

    and

    https://pike.quickbase.com/db/bpfpdy3bx?a=q&qid=23&nv=1&v0=75138760
    works well by itself

    now I just need them to work together or find out another way to do this.

    I am currently trying to replicate the following post:
    ---------------------------------------------------------------------------------------------------------------------------------------------
    Posted 07-16-2018 23:19
    Interesting.  I did not know about Keith's tip here until your post (great tip, Keith).  And I just happened to have a client who needed a mass print exact forms solution.  Got it working and tied up with a pretty bow in an hour.  So thx for the question.

    Just create a single record table with a single record in it to set the filters for the <ask the user> report.  The Record will be [Record ID#] = 1.

    Make a relationship back to the details table using a reference field with a formula of

    1

     and lookup the filter field(s) to the details table.

    Make a versions of the Report which will not be an <ask the user> but rather will use the lookup values for the filer field(s).

    Use the qid of that report and Keith's post to make a button to run the print set  for the qualifying records.
    ----------------------------------------------------------------------------------------------------------------------------------

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 8.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 15:50
    Have you made the <ask the user> report?  if so, what is the qid and what field represents the answer to the question.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 15:54
    Edited by Jordan McAlister 12-09-2019 15:57
    my <ask the user> report qid is "23" 
    The answer to the question is "WR #"​ which is a lookup field from the Poles table.

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 10.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 16:02
    try this

    URLRoot() & "db/" & dbid() & "?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=" & [WR#]

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 11.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 16:16
    i've tried that, it just gives me a blank white screen

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 12.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 16:21
    Is the answer to the question the [WR#} or is is the Record ID# of the WR? 

    ie maybe the syntax needs to be  .... & v0=" & [Related WR]

    It depends on your report

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 13.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 17:29
    It's the [WR #] because its works as a normal URL without the pagename= print stuff in the middle, for instance, ​
    https://pike.quickbase.com/db/bpfpdy3bx?a=q&qid=23&nv=1&v0=75138760    works, but,

    https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760       doesn't work.

    ------------------------------
    Jordan McAlister
    ------------------------------



  • 14.  RE: Print Multiple Exact Forms

    Posted 12-09-2019 17:35
    I might need to work with you one on one for 30 minutes to get this working.  Contact me directly by email and we can discuss.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------