I am wondering how to define which single select item to choose and populate to the field when creating a new record with such a field?
Hey there! It’s Audrey from Airtable
I noticed that you haven’t had any responses on your post, but it looks like the community could benefit from a little more information.
Could you give us a little more context for what you’re describing here?
Thanks for being a part of our community
I don’t know what @E_K is referring to exactly, but I’m trying to determine if I can set up an automation where my Single Select Field will automatically change to another item in the field? For example, I want the Suite Condition Rank to go from Brand New (single select) to Good (the following year). If suite 1107 was Brand New in 2020, it goes to Good in 2021.