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
Jun 26, 2019 11:12 AM
Hey AirTable community!
I want to to autopopulate a field (specifically a single select field, but this query could apply more broadly to other field types as well) with “No” if “Yes” is not selected.
I have a massive data set with “Yes” sprinkled throughout that field type. I know I could filter to show blanks and manually select “No” and click+drag, but I will be continually adding new records and I want the preset for this field to be “No.”
Any solutions??
Jun 26, 2019 02:04 PM
Hi @Jesse_Gibson - the single select field type doesn’t have a default so you can’t solve it in this way. You need a formula, but a field can’t be a formula and something else at the same time. The workaround is to create a new field (a formula) that can show “yes” or “no” based on your single select field:
The formula is:
IF({Yes/No} = 'Yes', 'Yes', 'No')
Does this work for your scenario?
JB