Translating Custom Table Data

[robertsduca]

i have a number of custom tables there were created to show application / system security data do drive data in a number of catalog item access request forms.

What would be the best practice / preferred method to translate the actual record level values for a number of the columns...

for example:

I want to translate the "More Information" column values from English to French as they are pulled for display on a number of catalog items via Glide Ajax calls.

[Chuck Tomasi]

I would take the same approach as the sys_choice table. Create a language field that contains the language "en", "fr", etc. and then duplicate the records with the correct translations. Now when your script is looking for records, you add one more query parameter. For example:

gr.addQuery('u_language', languageVariable);

[Suhail]

Thanks Chuck, this solution worked form my custom table data.

[antony4007]

Hi Chuck,

I am also into same requirement, i need to translate custom from data. So can we accommodate by importing records into sys_translated_text table? or this is the only option?

Thanks,

Antony