Tables in Documents

Hi

I am trying to generate a report from Airtable through PlumSail, the report has a

Cover page,
Contents page
Covering report for a job, with table repeaters for sites, in the covering report we would have say 4 different tables.
Appendix with table repeaters, for assets which is a repeater on sites

I seem to be getting issues with the tables pulling data through correctly, for example in the covering report there is a sites table, and instead of adding each site into the table it repeats the whole covering report.

Is there logic or a template to follow for having Mutiple tables in one word document. The final output is a pdf.

We are just seeing if Plumsail can handle our requirements.

Hi @PeterE,

It's possible to add a new table for each array of data, but each set should have some new header.

For example, you have a template like this one, with the {{companies.name}} header. In the Json we have several arrays with several companies.name headers. Each of them create a new table.

image

JSON:

[
    {
        "name": "David Navarro",
        "companies": [
            {
                "name": "Plumsail",
                "projects": [
                    {
                        "name": "Plumsail Actions",
                        "achievement": [
                            {
                                "description": "Design the hardware"
                            },
                            {
                                "description": "Design the software"
                            },
                            {
                                "description": "Implement the software"
                            }
                        ]
                    },
                    {
                        "name": "Plumsail Forms",
                        "achievement": [
                            {
                                "description": "Design everything"
                            },
                            {
                                "description": "Implement everything"
                            }
                        ]
                    }
                ],
                "managers": [
                    {
                        "name": "Derek clark",
                        "title": "Head of Development",
                        "reference": "he likes programming \nand good coffee"
                    },
                    {
                        "name": "Jessica Adams",
                        "title": "CEO",
                        "reference": "I don't know this guy"
                    }
                ]
            },
            {
                "name": "Contoso",
                "projects": [
                    {
                        "name": "Who knows what it was",
                        "achievement": [
                            {
                                "description": "R&D"
                            },
                            {
                                "description": "Bureaucracy"
                            }
                        ]
                    }
                ],
                "managers": [
                    {
                        "name": "Lots of people",
                        "title": "Managers",
                        "reference": "I saw this guy once in the cafeteria"
                    }
                ]
            }
        ]
    },
    {
        "name": "Martin Harris",
        "companies": [
            {
                "name": "Plumsail",
                "projects": [
                    {
                        "name": "Plumsail Org Chart",
                        "achievement": [
                            {
                                "description": "Mentor"
                            },
                            {
                                "description": "Teach"
                            }
                        ]
                    }
                ],
                "managers": [
                    {
                        "name": "Anil Mittal",
                        "title": "Founder",
                        "reference": "I like the way he laughs"
                    }
                ]
            },
            {
                "name": "Contoso",
                "projects": [
                    {
                        "name": "Whatever it was",
                        "achievement": [
                            {
                                "description": "R&D"
                            },
                            {
                                "description": "Documentation"
                            }
                        ]
                    },
                    {
                        "name": "Another old project",
                        "achievement": [
                            {
                                "description": "Research"
                            },
                            {
                                "description": "Development"
                            }
                        ]
                    }
                ],
                "managers": [
                    {
                        "name": "Brenda Coel",
                        "title": "Head of Heads",
                        "reference": "he knows the stuff"
                    },
                    {
                        "name": "Xue Li",
                        "title": "CEO",
                        "reference": "Brenda said he knows the stuff"
                    }
                ]
            }
        ]
    }
]

There is this result:

Please also check the article Loops and nesting.

Give it a try and if the issue persists share with us your template, the result file, and an example of the data you send to the template file. We'll check how to fix the template.

If there are some sensitive data, send a message to support@plumsail.com цith the reuqested files to open a ticket and refer to the community thread.

Best regards,
Petr
Plumsail team

Thank you Petr. Im slowly learning the looping as the data has the below linked structure in one airtable table. Each level being linked from another table.

  • clients
    - jobs
    - sites
    - assets

It seemed i cause the report to loop. Ill break down the report into parts and get a hand, as i think its and easy solve with a bit more understanding.

1 Like

Also i think i can see the issue that i have nested tables within other tables, so i go from say companies.name to projects.name and back to companies.name

1 Like