Print Multiple Exact Forms
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 pos...
Forum Discussion
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
------------------------------
------------------------------
Jordan McAlister
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendSo 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
------------------------------
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
------------------------------
- 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
------------------------------- MarkShnier__Youcan 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
------------------------------- 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:
---------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------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
------------------------------