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.
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.
Thanks, I’ll check it out.
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} = ""
@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.
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.
@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?
Sorry @Jon_Thomas1 I mistyped. It should be __EMPTY__
@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.
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.

I’m using integromat and none of these solutions work for me. Still searching.
The solution for Integromat is to use the built-in integromat erase
variable:

The solution for Integromat is to use the built-in 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
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.

This works !
I couldn't find how to clear a date field and this one works. Thank you 🙂
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.

This works perfectly. Thanks.
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.