Simple Script: update field using another field.

[Anneka_K]

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.

[Tim_Daff]

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

[Info_Betoncablo]

Tim_Daff:

integromat erase variable:

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

[Charlesb]

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

[Shashank1]

This works perfectly. Thanks.

[alex12714]

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.