I think the June 2023 release solved the original request.
I’m looking into this today since I’m working on an automation that copies data from on database to another. The source data does not have a select field but the receiving database does.
This feature release allows us to copy the value from an existing field to another select field. June 1, 2023 / Selects in automation Formulas, custom Button messages But I want to use an if() formula to return a select field given some logic about the source entity.
I am getting the same error because select fields cannot be accessed as a database in formulas.
I think the solution is a feature update to allow select fields to be referenced in formulas just like databases can be referenced in automation formulas and filtered to return a result.
If there is a way to do this already, I’d appreciate the help!