Help

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

3329 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.

12 Replies 12
openside
10 - Mercury
10 - Mercury

Hi @Anneka_K - that is something our On2Air: Actions product solves. You can use __BLANK__ and it will clear out that field.

Otherwise I’m not aware of any other approach.

Anneka_K
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks, I’ll check it out.

@Anneka_K, I don’t know if this will actually work, but did you try empty quotation marks?

Try telling Zapier:

{Date Field} = ""

Thanks Jeremy, I tried but it doesn’t seem to work … I think it did at one point for Text fields, but even that isn’t working any more.

@openside I am a subscriber to On2Air, and while __BLANK__ works to clear out a number field, it is inserting that literal text string into a text field in Airtable on update.

How can I clear out a text field?

openside
10 - Mercury
10 - Mercury

Sorry @Jon_Thomas1 I mistyped. It should be __EMPTY__

Tom_R
6 - Interface Innovator
6 - Interface Innovator

@Anneka_K I stumbled across this thread in search of a similar process - using Zapier to delete data from fields.

In my case, I want to delete a linked record from an entire record. I simply hardcoded two quotation marks into the linked record field in Zapier’s update a record for Airtable. Literally,

“”

…into the field that I wanted to remove the record from. If I review the record’s history (expand it with the arrows), I see the Zapier API has removed it. I’ve used the double quotations in Airtable Formula fields before to leave fields blank if a condition isn’t met, but =BLANK() doesn’t work in this case.

Unfortunately - this doesn’t work for date fields, but as a workaround maybe see if you can covert your date fields as linked records?

If you want the date field still in the table, then you can use a formula field (format as a date) referencing the linked date field.

Hope it still helps your case as it did mine!

Tom.

Bob_Ziroll
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m not sure if you’ve already found this, but for anyone searching this in the future, Zapier allows you to simply enter three spaces into a field as an indicator to clear whatever value might be there.

Screen Shot 2020-12-17 at 3.27.23 PM

Tim_Daff
4 - Data Explorer
4 - Data Explorer

I’m using integromat and none of these solutions work for me. Still searching.

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 🙂