Apr 08, 2019 09:47 AM
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.
Jan 14, 2021 05:06 PM
The solution for Integromat is to use the built-in integromat erase
variable:
Jan 26, 2022 11:41 PM
HI, what’s the name of the module that you allow to create the automation?Tools?and the trigger’s name?
Thanks
Aug 09, 2023 07:19 AM
This works !
I couldn't find how to clear a date field and this one works. Thank you 🙂
May 24, 2024 06:12 AM
This works perfectly. Thanks.
Sep 09, 2024 04:43 AM
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.