Data cleanup from App source

Question

This may be a pretty basic question, but I am running into an issue with the way information is formatted from an app source. I need to use the “value” of the “name” for a specific custom field. My issue is when I attempt to find the specific value of “Invoice Date for Billing / Billing Info...etc, it only allows me to select the “values” of all of the customer fields, with them separated by columns. Is there any way in zapier to pull the specific value for one of the custome fields? There are around 15 custom fields.

jesse · Accepted Answer

Hey @jpowers! I want to second Troy’s suggestion that Looping is going to be key in getting you to your desired outcome:

You can use the Looping app to handle an array of line items: https://zapier.com/apps/looping/help

I also wanted to share this Community article, which breaks down the concept even further (there is even a section specifically focused on line items):

Troy Tessalone · Answer

Hi @jpowersGood question.You can use the Looping app to handle an array of line items: https://zapier.com/apps/looping/help

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded