Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’ve created a text formatter step to split into multiple fields so that I can populate a google sheet.  When I test it it looks fine, but when I try to select individual fields in the next step they are not there.  I only see 1 field again.  Why don’t I see the individual fields that I created in the prior step?  What am I doing wrong?

 

 

My last screenshot was cut off

 

Hi @Mary_S 

The output should look like this. (instead of returning an array with line items like shown in your screenshot)

Try testing the Formatter step again.

 

I’ve tried retesting at least 10 times and the output is not showing the separate fields in the next step.

 

 

@Mary_S 

Try using a different Formatter option: Formatter > Utilities > Text to Line Items

Text to line item, gets the same result (plus it only lets me split by comma and I have commas in my data.

 

@Mary_S 

Can you show an example of the original data you’re using?

When I test the original data I see this:

I want to capture what is in simpleValue (there are several of them in the data) and put each one in a cell in google sheets

 

However when I try to select it I only have this option.  I went through all of the available fields and this is the only one that contains any and all of the data I want. 

 

 

@Mary_S 

Try this…

Action: Formatter > Utilities > Line Items to Text

 

That will return something like this:

 

Then you can use a Formatter > Text > Split OR a Formatter > Utilities > Text to Line Items step.

 

OMG, that worked.

This has been driving me CRAZY

 

THANK YOU !!!!!

Terms & Conditions