Different drop down display label from the drop down value

Question & Answer
,
1

Is it possible to separate the value from the label in the drop-down?

Like in HTML, these are two separate values.

<option value="AD">Andorra</option>
<option value="CA">Canada</option>

E.g. when a user selects the “Canada” option, I want the parameter value to be CA.

Thanks.

1 Like
2

Hello @m0ltar ,
This is a good question and I will translate this to our product team.
Rigth now, the way to do so is using a calculated field and the function ifelse.
NewField = ifelse( value="AD",Andorra,value="CA",Canada,...)

3

@JoseB-aws Sorry, I am not sure how this would work?

I want the drop-down labels to say “Canada”, but the parameter value to be CA.

But mapping from Canada → CA isn’t reliable. In the simplest case with country names, then maybe it is. But there are other cases, e.g. think “Customer Name” → “Customer ID” mapping. There is no guarantee that the customer name is unique. There might be several “John Smith” names, each mapping to a different customer_id (PK).

4

In the ifelse could you replace the CA with a parameter for a workaround?