Hi. I have the next expression:
SELECT(“Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]”, Traduction[Text] = “Confirm”)
The expression “Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]” return Traduction[CA] if the language of the user is Catalan, Traduction[ES] if the language of the user is Castilian or Traduction[EN] if the language of the user is English and I have this columns in my table.
The field Traduction[Text] is key and contain AppSheet’s expressions: Confirm, Yes, Delete… My objective is use this expression on Localize functions to have an easy traductor.
The interface returns “Cannot compare List with Text in (Traduccions[Literal] = “Confirm”)”.
What is the error? Can you help me?
THANKS!
You’re attempting to use SELECT() improperly.
Thank you Esteve. Yes. It’s true.
My question is misspelled. How can I reference a column dynamically instead of explicitly?
If I write
But I want to assign the value “CA” of a dynamic mode. I want to be able to express “CA” as a parameter, like now
Where can I find documentation to do this?
Thank you for your time.
You cannot.
Thanks.
It’s a pity. In this case, I can only work with the SWITCH() function, but it makes the code very long and difficult to maintain.
It’s been a pleasure.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |