Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Delete data in a field based on a selection in a different Multi-Select field

Topic Labels: Automations
229 3
Showing results for 
Search instead for 
Did you mean: 

I am sure this is simple but I can’t figure it out. I have a multi-select field. When I choose a particular selection in the Multi-Select field, I want any data in a different field in the same table to be deleted. I see how to do the trigger but not the Action.

Any help would be appreciated.

3 Replies 3

If you just set the field to empty (leave it blank) as your action, does that work?

If not, you can always create a formula field that equals nothing, and then set the field to that formula field as your action.

I’ve used that method many times. Set up the “Update record” action as normal, add all the fields that should be affected by the update, and leave any field empty that you want to be wiped clean.

Yes. That worked. Not sure why I didn’t see that. Thanks!

-Dean Moray