Skip to main content
Best answer

Extracting custom Asana fields from "Data Custom Fields Dislpay" with "text to line item" using Zapier

  • January 29, 2024
  • 5 replies
  • 315 views

I am trying to extract the custom fields of my asana task by using zapier transform to separate the “data custom fields dislpay” by comma. 

From my understanding, zapier batches all of the custom fields values from an asana task in to one “data custom fields dislpay”. I am trying to separate them in to discrete fields I can use to generate a custom text.

 

Pre Transform:

 Transform: 

Post Transform:

The separating seems to be working, however, when I look at the output it has once again batched everything together. I was hoping to be able to pull specific items. Output 1: 555-555-5555, Output 2: RNA etc…

Thank you for your help!

Best answer by ken.a

Hi there @Sugi1999,

Welcome to the Community! 🎉

Have you tried using the Utilities in Formatter - Line-item to Text action and use the comma as your separator? Based on your screenshot it looks like you’re using the Text to Line-item action.

Please let me know if that works.

Thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • Answer
  • January 30, 2024

Hi there @Sugi1999,

Welcome to the Community! 🎉

Have you tried using the Utilities in Formatter - Line-item to Text action and use the comma as your separator? Based on your screenshot it looks like you’re using the Text to Line-item action.

Please let me know if that works.

Thanks!


  • Author
  • New
  • 1 reply
  • January 30, 2024

that was it!! Thank you so much! I am now able to get my items as individual outputs

 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • January 31, 2024

You are most welcome @Sugi1999! I’m glad I was able to help!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Happy Zapping! ⚡️


  • New
  • 1 reply
  • March 13, 2025

Hello, thank your for this information ! 

I also try to use the custom fields to generate a codification number. To do this I have to select some of the fields first separated. My problem is that empty fields ca exist and could be detected by double coma in the input string (as coma is the separator) Unfortunately, it seems that zapier ignore double coma and i can not map as order in seqsuence can change depending on clear values present. Can you help me ? Thanks

 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • March 14, 2025

Hi ​@Salva_CWT,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the issue that you’re encountering. This will help me take a closer look.

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!