Skip to main content

Airtable to Docupilot via Zapier, pulling info from linked field with multiple records

  • May 15, 2019
  • 4 replies
  • 40 views

Forum|alt.badge.img

Hi all

So I’m trying to use docupilot as an alternative to page designer, as it provides more flexibility

I have a table called BLA, which has a linked field to another table “Product Line Items”. That second table has 6 fields of information that I need.

I want to pull the information for each linked item via a zap to send to docupilot, along with all the records from the BLA table.

Any ideas on how I can achieve this?

4 replies

Forum|alt.badge.img
  • Author
  • Participating Frequently
  • 5 replies
  • May 15, 2019

Update! I’ve managed to get the find zap to work, but its not pulling up every line item, just one.


Forum|alt.badge.img+19
  • Inspiring
  • 351 replies
  • May 15, 2019

Hi Sarah, you could explore On2Air: Actions to handle working with multiple rows. We call it bulk mode, or line items in Zapier terms.


Forum|alt.badge.img
  • Author
  • Participating Frequently
  • 5 replies
  • May 15, 2019

Hi Sarah, you could explore On2Air: Actions to handle working with multiple rows. We call it bulk mode, or line items in Zapier terms.


Unfortunately $49 a month is way out of any budget I could get approved.


  • New Participant
  • 2 replies
  • May 16, 2019

Hi Sarah,

I’m from Docupilot team.

You can use Rollup fields in your BLA table to get the information from linked table.

You will need to create 6 Rollup fields in your BLA table that points to your Product Line items table fields. You will need to use ARRAYJOIN(values) as aggregation function.

In Zapier you will get all the Rollup fields data, you will need to map the 6 Rollup fields accordingly in Docupilot action.