This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- AppSheet
- Feature Ideas
- Refer to a column dynamically
Topic Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
LinkedIn
Twitter
Idea Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Refer to a column dynamically.
So far and as far as I know, you can only refer to one column explicitly:
- SELECT(Translations[CA], ([Literal] = “Confirm”))
or - LOOKUP(“Confirm”; “Translations”; “Literal”; “CA”)
In this case and to understand the needs, these expressions expressions serve me to obtain a certain literal in another language.
But if I have multiple languages among my users, I need to use SWITCH () type functions but this makes the code long and difficult to maintain.
It would be very useful to be able to express a column of a dynamic mode mode that AppSheet allows me to exchange the [CA] of SELECT () or the “CA” of LOOKUP () for expressions such as:
- USERSETTINGS(Language)
or - LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”)
This would make for a cleaner, clearer and easier to maintain code.
Or be able to have a variable in Expression Assistant and be able to write something like:
- Language = USERSETTINGS(Language)
LOOKUP(“Confirm”; “Translations”; “Literal”; [Language])
Thank you for your time and work!