Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Nov 11, 2021 12:32 PM
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
Nov 11, 2021 02:12 PM
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.