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.

[helloitse]

@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?

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!

[Chr1sG]

@helloitse

I think the June 2023 release solved the original request.

I think you’re right.

@helloitse

If there is a way to do this already, I’d appreciate the help!

Unfortunately, I think the only way to do this currently is with a script.

[helloitse]

My current work around is to make the select field one that the user completes when pressing the button.
I gotta say that nice “human in the loop” touch comes in handy!