JordanMcAlister
6 years agoQrew Captain
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 post:
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30308&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
For my situation, here is my setup at the moment:
Work Requests>Poles>Field Work
Work Requests have many poles and each pole has 1 field work record. I would've liked to put all field work info in the poles table but the field work table has over 500 fields in it and was a big endeavor at the time of creation so it was separated at the beginning and has a 1 to 1 relationship with poles. My exact form prints locate sheets in a particular format and is within the field work table and each pole will have 1 locate sheet. I want to be able to print all the field work locate sheets for the poles of a work request straight from the grandparent work request table via URL button.
Some things I've tried->
I noticed on an ask the user report that "&nv=1&v0=75138760" was at the end of the URL after the qid and I tried combining the print URL with this to make:
https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760
..to see if it would print multiple exact forms this way but it shows the exact form for a split second then just turns into a blank white screen, so I'm not sure what else I could do. I can't figure out a good way to make the report necessary to make the normal qid print method mentioned by Keith Jusas to work.
Any suggestions?
Thanks in advance,
#Forms
#Button
#APIsandcustomcode
#Formulaandfunctions
------------------------------
Jordan McAlister
------------------------------
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30308&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
For my situation, here is my setup at the moment:
Work Requests>Poles>Field Work
Work Requests have many poles and each pole has 1 field work record. I would've liked to put all field work info in the poles table but the field work table has over 500 fields in it and was a big endeavor at the time of creation so it was separated at the beginning and has a 1 to 1 relationship with poles. My exact form prints locate sheets in a particular format and is within the field work table and each pole will have 1 locate sheet. I want to be able to print all the field work locate sheets for the poles of a work request straight from the grandparent work request table via URL button.
Some things I've tried->
I noticed on an ask the user report that "&nv=1&v0=75138760" was at the end of the URL after the qid and I tried combining the print URL with this to make:
https://pike.quickbase.com/db/bpfpdy3bx?a=dbpage&sfid=497&pagename=Locate%20Sheet.html&clist=a&qid=23&nv=1&v0=75138760
..to see if it would print multiple exact forms this way but it shows the exact form for a split second then just turns into a blank white screen, so I'm not sure what else I could do. I can't figure out a good way to make the report necessary to make the normal qid print method mentioned by Keith Jusas to work.
Any suggestions?
Thanks in advance,
#Forms
#Button
#APIsandcustomcode
#Formulaandfunctions
------------------------------
Jordan McAlister
------------------------------