How to reference Select and Multi-Select in Automations?

[James]

I couldn’t figure this out, I ended up using another table with the values for the Select, which worked but I lost the colour configuration and display.

So then I added a Select to that table, with the value and colour I wanted, then add the table as a relation, plus a lookup to the select

My question is, how can I avoid all that? Reusing the above example, how do I create/get/find or reference the “Campaign” type in a formula?
Just the name as a string doesn’t work, the index as an int etc
it tells me “Result type should be Mission Type Display but Text received”

[Chr1sG]

Currently not possible without scripting I’m afraid, sorry.

Button formula: How to update a single-select field

Hi Fibery Team and Power Users, How can I update a single-select field from within a button formula? Example: App “User Research” (from the app templates) has a type “Insight” with a single-select field “Kind”. This field has four pick values: Observation, Opportunity, Pain, and Praise. I want to add a button that updates the single-select field with a value calculated by a formula. However, I cannot seem to find a valid formula that can pick one of the available values and update the field …

[antoniokov]

@James

My question is, how can I avoid all that? Reusing the above example, how do I create/get/find or reference the “Campaign” type in a formula?
Just the name as a string doesn’t work, the index as an int etc
it tells me “Result type should be Mission Type Display but Text received”

Could you please share the Formula you typed?

We are looking into extending our support of select options in [automation] Formulas and are exploring a couple of solutions. Wanna make sure we cover your specific case.