Forum Discussion

GrantK's avatar
GrantK
Qrew Cadet
23 days ago

How to Generate PDF with data from multiple children records

I am trying to see if there is a way to create a pdf that is able to loop a section depending on how many children records are linked to the parent.

 

Here is the situation. I have a site record (parent). Each site may have one or more visits (children).  I want the PDF to repeat a template section for each child record. It will have information such as Start Date/Time, and Job Description. e.g

 

 

I know Quickbase has an API to generate a PDF using a static template, but is there a way get it to loop a section in a template for each child record that exists? Having a different template for each child quantity possibility seems inefficient.

Thanks.

PDF

2 Replies

  • GrantK's avatar
    GrantK
    Qrew Cadet
    21 days ago

    Hi Mark,

    I did look at reports, but the issue is the formatting as a report only allows everything in horizontal columns. It also doesn't look good if i want to do other tasks like Quotes etc too. Looks like will have to stick to the custom coding for a while longer.

    Thanks.