print multiple records' exact forms

  • 39
  • 3
  • Question
  • Updated 7 months ago
  • Answered
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...


Photo of Brad

Brad

  • 22 Points

Posted 5 years ago

  • 39
  • 3
Photo of Keith

Keith, Champion

  • 1,090 Points 1k badge 2x thumb
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
Photo of Nate McKinney

Nate McKinney

  • 324 Points 250 badge 2x thumb
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#]
Photo of Brad

Brad

  • 22 Points
Great, kind of works.  Can you tell me how I identify the ID of the report?  I dont see that anywhere.  Thanks!!
Photo of Keith

Keith, Champion

  • 1,090 Points 1k badge 2x thumb
view the report, look in the address line of your browser....qid=X .....X is the report query id
Photo of Roel

Roel

  • 10 Points
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
Photo of Roel

Roel

  • 10 Points
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,478 Points 50k badge 2x thumb
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.
Photo of Lee Gilmore

Lee Gilmore

  • 786 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,478 Points 50k badge 2x thumb
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.
Photo of Lee Gilmore

Lee Gilmore

  • 786 Points 500 badge 2x thumb
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.