Implementing Translation Framework for Record Values

Question

Hello Appian community,
I have a question regarding the implementation of a translation framework on record values in Appian. Currently, we are using database-backed records to store and display various referential data (such as status or list of values). I would like to apply a translation framework to dynamically translate these values into different languages when displaying a grid of record values.
I am concerned about having to create a complex a!match statement to connect these values with Translation Set entries.
Has anyone had experience with this or can provide guidance on the best practices for implementing such a solution using Translation Sets? Any advice or resources would be greatly appreciated.
Thank you in advance!

mathieud0001 · Accepted Answer

Hello - I decided to publish a blog post on this subject: https://blog.appiandevs.io/001-how-to-manage-translations-for-reference-data/

stefanhelzle0001 · Answer

I try to not store reference values in the DB. Mostly because I need them in the application logic anyways, for assignment and comparison reasons. This means that I now have two places where I need to manage these values. So I stopped using the DB, and just work with constants.

But that does not solve the translation issue and I think that Mat's approach is a great option. And you can still use that reference record together with constants.

Sign up

Login with SSO

Login to the community

Login with SSO