Help

Making a formula to clear data

Topic Labels: Formulas
824 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashley_Bunner
4 - Data Explorer
4 - Data Explorer

Hello,

I am still very new to Airtable so maybe this is easier than I think but would still like help.

In general, I am looking to write a formula so that when a field (that is a single select option) is selected to “deleted” it will then clear many fields (that are multiple select) of all of their data.

So in the picture included below, when the field Deleted is selected to “Deleted” I want all of the data in the other rows to be cleared and back to like nothing had been selected.

How would I go about this?

Thanks

Screen Shot 2021-11-11 at 12.30.43 PM

1 Reply 1

Formula fields cannot change the values in editable fields.

You could use an automation that would check for when field {Deleted} has the value “Deleted” and then clear the values of the editable fields.