Document Builder with multiple rows of data

Options
RDRGSJ00
RDRGSJ00 ✭✭✭
edited 02/19/24 in Add Ons and Integrations

Is generating a document with data from multiple rows possible?

For example, I have a sheet that has:

Columns: Team Name / Team Lead / Phone Number

Row 1: Alpha Team / John Doe / 555-555-5555

Row 2: Bravo Team / Jane Doe / 666-666-6666

Row 3: Charlie Team / Joe Doe / 777-777-7777

I would need to generate a document with all the info for Team 1, Team 2, and Team 3. As far as I know, documents are generated for one row only. I need one single document, not three individual documents. Any information will be greatly appreciated.

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @RDRGSJ00,

    a workaround idea, try to make 9 columns for Team Name / Team Lead / Phone Number and change the names of those columns to Team Name1 / Team Lead1 / Phone Number1, Team Name2 / Team Lead2 / Phone Number2, Team Name3 / Team Lead3 / Phone Number3 then generate your document.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • RDRGSJ00
    RDRGSJ00 ✭✭✭
    Options

    Thank you @Bassam Khalil , that would work except the real data I'm working with has 10 teams, each with 10 columns of information. That's going to be a lot of columns. I'm wondering if there is another workaround that won't require 100 columns.