Asana custom fields not showing in "Insert Data" section when trying to map in Google Sheet columns

Hi @camcooper 

Good question.

I believe the Asana Custom Fields get treated as an array of objects.

e.g. “Data Custom Fields Display Value” would contain all the Display Values for the Custom Fields.

Usually that means Formatter or Code steps have to be used to isolate the desired custom field value.

Hi @Troy Tessalone thank you for the info! Let’s say a field name was something like Item_ID if i used Formatter to parse that field name an inputed to a particular column, would Zapier know to pull anything under that field name since the Formatter really only parsed out the text?

@camcooper 

You have to essentially combine 2 arrays Item ID and Item Value to create a new variable for Item ID which has a value to then map into the following Zap steps.

e.g. Custom Field arrays as pre-parsed by Zapier.

Label: A,B,C

Value: 1,2,3

If you wanted Label A that has a value of 1.

Then logic needs to be applied to create a new variable called A that has a value of 1.

@Troy Tessalone sorry for the delay on this! Is there any example Zaps you may be able to share that could help get me started with the configurations?

@camcooper 

This can be done with a Code step which is an advanced approach.

Hi @camcooper Did you figure out a workaround for this?