About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Formatting multiple blank fields

  • 19 July 2021
  • 3 replies
  • 143 views
K

I have a zap which takes a new row of data from Google Sheets and populates into a new Google Slides deck. Half of the data may potentially be blank and currently these remain as {{FieldName}} in the newly created Slides deck, but I’m hoping to change it so it feeds through as “N/A”.

I know I can achieve this through a Formatter>Text>Default Value action:

  1. Do I need to add a Format step for each field? eg, if I have 14 fields which may potentially be blank, I add 14 Format steps?
  2. Is there an alternative method which can streamline/simplify the above?

Thanks!

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

3 replies

Wemakefuture
Userlevel 6
Badge +7

I assume doing this with python is a 15-30 minute's thing. If you want to request a short call here: https://zapier.com/experts

 

 

 

 

https://www.wemakefuture.com/
K

Thanks @robschmidt , unfortunately coding with Javascript or Python is beyond me.

Another approach I was thinking was a Find {{Fieldname}} and Replace with “N/A” action after the new Google Slide deck has been created but this also doesn’t seem to be possible.

I’ll fallback on using multiple formatters instead until another viable option emerges. :)

robschmidt
Userlevel 7
Badge +9

Hi @KTO 

The best solution for this to use a code step, so that you don’t have to use the same number for formatters as the fields. You can just write a Javascript or Python code and return N\A if the value doesn’t exist, otherwise the value itself. It shouldn’t be that hard to write.

Outliant.com | Zapier Expert
Terms & Conditions