Document Builder with multiple rows of data

RDRGSJ00

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.

Bassam Khalil

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.

RDRGSJ00

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.