Is it possible to separate the value from the label in the drop-down?
Like in HTML, these are two separate values.
E.g. when a user selects the “Canada” option, I want the parameter value to be
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
NewField = ifelse( value="AD",Andorra,value="CA",Canada,...)
@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
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
In the ifelse could you replace the CA with a parameter for a workaround?