Discussions

Expand all | Collapse all

print multiple records' exact forms

  • 1.  print multiple records' exact forms

    Posted 11-12-2013 03:22
    ok last question for the night. I have a report that pulls all of the upcoming reservations. each reservation has it's own exact form order sheet. I want to print all of the reservations with as little clicking as possible (without clicking each record's button that shows up on the report). Sounds impossible, but thought i'd check...




  • 2.  RE: print multiple records' exact forms

    Posted 11-12-2013 19:22
    Hi Brad,
    yes, this can be done...at the end of your url field for the exact form there should be something like "rid=999". Change this to be "qid=1" where 1 is the id of the report query that has your filtered reservation records.

    example...
    this will produce 1 exact form for record id# 3 in my Exact Forms Plus! Demo application
    https://juicedtech.quickbase.com/db/bdht34muk?a=dbpage&sfid=109&pagename=PurchaseOrder.html&clist=a&rid=3

    this will produce 5 exact forms, 1 per record in my Purchase Orders table. The List All report has a query id = 1 so that is what I used below.
    https://juicedtech.quickbase.com/db/bdht34muk?a=dbpage&sfid=109&pagename=PurchaseOrder.html&clist=a&qid=1

    Keith


  • 3.  RE: print multiple records' exact forms

    Posted 07-16-2018 05:57
    I tried and it will not work for me. This is mine now 
    URLRoot() & "db/" & Dbid() & "?a=printr&dfid=15&rid=" & [Record ID#]
    And this is what I tryed
    URLRoot() & "db/" & Dbid() & "?a=printr&dfid=15&qid=26" & [Record ID#]


  • 4.  RE: print multiple records' exact forms

    Posted 11-12-2013 20:21
    Great, kind of works.  Can you tell me how I identify the ID of the report?  I dont see that anywhere.  Thanks!!


  • 5.  RE: print multiple records' exact forms

    Posted 11-12-2013 20:26
    view the report, look in the address line of your browser....qid=X .....X is the report query id


  • 6.  RE: print multiple records' exact forms

    Top
    Contributor
    Posted 04-14-2016 19:25
    Hi, I've tried this and it worked. But it doesn't work for the report query that has variables. Do you have solution to this.

    https://recyclingusa.quickbase.com/db/bix4vkfdn?a=dbpage&sfid=3&pagename=Internal%20Number%20Tracker%20Version.html&clist=a&qid=81&nv=1&v0=00041


  • 7.  RE: print multiple records' exact forms

    Top
    Contributor
    Posted 04-14-2016 19:35
    Hi, I've tried this formula and it worked but it doesn't work for the qid that has variables. Do you have solution to this?

    https://recyclingusa.quickbase.com/db/bix4vkfdn?a=dbpage&pagename=Internal%20Number%20Tracker%20Version.html&clist=a&qid=81&nv=1&v0=00041


  • 8.  RE: print multiple records' exact forms

    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.


  • 9.  RE: print multiple records' exact forms

    Posted 08-30-2018 20:14
    I'm trying to follow what's going on here and see if I can utilize it for my particular use case.

    I'm trying to print one record per page, that record has an embedded report associated. The records are employees where the embedded report is their time sheet records. Each day is a time sheet record and the embedded report is a list of days within the current week.

    I can pull up each record one at a time and print, but like the original poster, would love to minimize clicks. I have no love of printing but our payroll needs a paper copy for a job site requirement. I'm a little lost on the explanations described above and not sure if my case fits the suggestions made here.


  • 10.  RE: print multiple records' exact forms

    Posted 08-30-2018 20:23
    If you are talking about printing on the native form, the option is right before your eyes, but you brain has filtered it out, due to familiarity.

    Just print the report as usual and pause where it asks you if you want a report or one record per page.


  • 11.  RE: print multiple records' exact forms

    Posted 08-30-2018 20:39
    I think I have a paradoxical relationship with Quick Base. The more I learn, the less I seem to know/remember.

    Thank you very much for pointing out the print one record per page. My specialized print form provided exactly what I needed.