Help

Re: Is there a way to clear/empty a field with a Zap update?

271 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Anneka_K
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to use a find/update zap to automate a record update in Airtable, Some empty fields need to get new data, some get updates and others need to be cleared. The Zap correctly adds the new and updated data, but I can’t figure out how to DELETE data from the fields that I want emptied (which are date fields). With other numeric fields, it’s easy to just set the update value to “0”, but this doesn’t seem to work for date formatted fields.

I’ve tried
0
=0
-1
0/0/0000
0000-00-00
=BLANK()
Null
Creating an empty dummy field and setting the value equal to that

No luck.

I asked Zapier first, thinking they might have some special formula or syntax to use for this kind of thing, but they told me it’s restricted on the Airtable side and overwriting with blanks isn’t permitted.

I thought I’d ask here in case anyone else has come up with a solution/hack to clear/empty/erase a cell or make it “null”. Thanks.

14 Replies 14
Tim_Daff
4 - Data Explorer
4 - Data Explorer

The solution for Integromat is to use the built-in integromat erase variable:

image

HI, what’s the name of the module that you allow to create the automation?Tools?and the trigger’s name?
Thanks

This works ! 
I couldn't find how to clear a date field and this one works. Thank you 🙂

This works perfectly. Thanks.

alex12714
4 - Data Explorer
4 - Data Explorer

Within Integromat-Make.com to clear out AirTable field value - use the Emptystring function within the string functions instead of value - that helps to clear out the value.