We are in the initiation phase of developing a range of multinational apps and it is crusial for us that we can easily extend with new Locales and Languages.
Current model with multiple switch statements and lookups is too cumbersome to be agile and too complex for a no-code platform.
To help us and all other companies supporting software globalisation I suggest the following:
Data sources that can be updated outside Appsheet e.g. through automated translation using Google Translate or other automated translation services. Simple sheets with one column and one column per
A more standardised way of reading texts by from the data source e.g. GetTranslation(, )
Display Name = GetTranslation (PHARM, EN) => Pharmacy
Display Name = GetTranslation (PHARM, DE) => Apotheke
Display Name = GetTranslation (SANTA, DA) => Julemand
Display Name = GetTranslation (SANTA, DE) => Weihnachtsmann