Hello,
i have 2D array in google sheet, like this:
Name English German
CheckIn. text1 text2
CheckOut. Text3 Text4
And 2 enum list one with language other with name, how can i dinamiclly reference 2D table depending on this 2 enum
H
LOOKUP() is not working for me, as return column has to be fixed.
I need to reference by row and b column
What are you trying to accomplish? Localization?
Im trying to accomplish localization on message im sending to WhatsApp depending on language selection and message type selection.
You'll need to do something like this:
SWITCH(
USERSETTINGS("Language"),
"English", [English],
"German", [German],
""
)
I need "localization" not for app user but for customer receiving message/email
How is the app involved in the email? If the app generates the email, my suggestion applies. If the app doesn't generate the email then how does your question relate to AppSheet?
All has a Action button that when clicked send text message to whatsapp api to and open whatsapp client and there i just click to send.
I want to be able depending on dropdown language selection for specific guest be able to send message
Here is dropdown option for messenger
โaction button for sending message
โ
My suggestion applies, then.
I will check.
Question still remains how to make it work with 2 dropdowns. One for language and second CheckIn/CheckOut
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |