Document Builder with multiple rows of data

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.

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.