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 am trying to pull in data through Zapier Formater “Text to Line” thus creating a column of data. The issue is that when a submission is made that contains “No Data” it creates empty cells instead of ignoring the entry. What I need is for Zapier to only create cells in the list if there is Data. Here is an example of what the Zap looks like and how it appears in the sheet. What I don't want are all the empty cells at the top. 

 

 

 

Hey @Tim Moxey,

Let me see if I can help here…

I’m not sure I’m fully understanding your desired workflow. Now, it looks like the first line item that came through had a quantity of 4 and no other values. So a row was entered with just that set. And then the next line item had a quantity of 270, and so on.

Finally, the sixth line item had a quantity, lot number, and batch number come through, but no other information. Are you saying that you want the lot number and batch number to be in the top row, even though that data isn’t associated with the “4” that’s already in the top row? Or are you saying you only want data entered when all the values are already there? Or are you saying something else?

Hi @Tim Moxey 

From my understanding of what you are looking to do. the most efficient solution would be a code block to ignore empty values. 


The code below would allow you to split up the input by comma and only return values that exist. This code step also returns a line item so you can map it directly to Google Sheets in the same manner

*TIP*: You can use keyboard shortcuts like cntrl+a (or command+a on a mac) on the input of your current set up to highlight everything you’ve already mapped. then use cntrl+x (or command+x) to cut the input and cntrl+v (or command+v) to paste it into the input of the code block.

let values = inputData.input.split(",");
let filtered = values.filter(value => value != "")

return {output: filtered}


 

 

Hi there @Tim Moxey 👋🏻

 

Wondering how you are getting along with your Google Sheets code block? It’s all a bit out of my league, but luckily it looks like you have two thorough responses to help you along the way. Let us know if you ran into any other snags or if you’re all set!

 

Best,

Rachael

Terms & Conditions