Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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.
- LauraElder6 years agoQrew MemberHi There ~ I've been unsuccessful in using the option above when trying to use Exact Print on "filtered" records. I've been able to use the "all" or "one" options provided by Keith above - but am unable to nail down the "some" option.
Thanks!
------------------------------
Laura Elder
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Laura, can you post the code (copy and paste) you are using for your button?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- LauraElder6 years agoQrew MemberThanks Mark! I've not gotten as far as the button piece yet. May I ask for some clarification on creating the single record table and the reference field with the formula please?
------------------------------
Laura Elder
------------------------------