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...
Question
print multiple records' exact forms
This topic has been closed for replies.
+7Hi 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
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
Great, kind of works. Can you tell me how I identify the ID of the report? I dont see that anywhere. Thanks!!
+7view the report, look in the address line of your browser....qid=X .....X is the report query id
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
https://recyclingusa.quickbase.com/db/bix4vkfdn?a=dbpage&sfid=3&pagename=Internal%20Number%20Tracker%20Version.html&clist=a&qid=81&nv=1&v0=00041
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
https://recyclingusa.quickbase.com/db/bix4vkfdn?a=dbpage&pagename=Internal%20Number%20Tracker%20Version.html&clist=a&qid=81&nv=1&v0=00041
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.
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.
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.
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.
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.
Just print the report as usual and pause where it asks you if you want a report or one record per page.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.