Print report per record per form.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

There may not be a way to do this natively but I doubt it. And I'm fine if it can be done in API just trying to find if its possible. I have a report and multiple forms. I want to do the print page per record feature but need the formID to be dynamic. Looking at the DoPrint() function it looks like they're just making a URL to do this so I guess in my case I would have to create all the URLs for the different forms which wouldn't be tough but how to render them together so they can all be printed as one print task? 

One thing I thought about was creating a mega form with every form in it but doesn't look like you can hide and collapse empty fields? when in view mode of a form can you?

Can it be done through GenResultsTable in some way? Any suggestions would be greatly appreciated thanks!

Photo of itsjustchuck

itsjustchuck, Champion

  • 80 Points 75 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Are you saying that you want to print say 10 records, but each the form for each record will vary within that print run?
Photo of itsjustchuck

itsjustchuck, Champion

  • 80 Points 75 badge 2x thumb
yeah exactly. for each record there is a separate form to be used. I'm fine using API's if thats the route I need to take but just not sure where to start. Like if I can create a call that goes through each record and creates a print version, then append that to an HTML container, like mimic the print preview almost. Then they could use the system print dialogue to print the collection.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Interesting question, but one for which I have no solution.
Photo of itsjustchuck

itsjustchuck, Champion

  • 80 Points 75 badge 2x thumb
Thanks for replying anyway! If I figure out a way I'll post it here.
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
I would think the only way to do this would be to employ Exact Forms in some fashion.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
This can be done with script. It is a little tricky because I assume you want to rearrange all the different reports so that all the forms for a particular record are adjacent (and on their own page) before the next record is displayed. 
Photo of itsjustchuck

itsjustchuck, Champion

  • 80 Points 75 badge 2x thumb
Can you provide some pseudo example of how it could be done?
Photo of itsjustchuck

itsjustchuck, Champion

  • 80 Points 75 badge 2x thumb
Basically it would be one report, the only filter would be the related master record and the Task Name can be used to determine which form to use. This may be a good example to try out deferred objects. Guessing I would create URLs for each row on the report. Then return that URLs response and once all the rows are done then a print is fired. No clue where to start with something like that though