Question

Passing "Remove" or {{HookField}} intro Google Docs

  • 6 June 2020
  • 1 reply
  • 484 views

I am merging fileds from a Google Sheet into a Google Docs, document.

Some of my fields are not always populated.

Is there a way to ignore a field if the value is blank, or even populate a blank value with a space rather  that the leave the {} in the document or populate it with the word Remove ?

 

Thanks in anticipation


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

1 reply

Userlevel 7
Badge +12

Hi @Hothams, welcome to the Community!

 

There is a way to tell a Zap to use a space if a field is blank, but I think that you would need to add a step for each field that might be blank. You can use the Spreadsheet Style Formula  function in the Formatter by Zapier app. To do that add an action in the Zap and choose Formatter > Numbers > Spreadsheet style Formula. 

 

For the formula you, use: if(“insert_variable”=””, “ “,”insert_variable”) This is basically saying, if the field is blank, then add a space, if it has something in it, then use the information in the field.

 

I can’t think of way to do this for more than one field at a time, which is why I think you’d need a Formatter step for each field that might be empty.