Solved: How do I use ref-tables to display & store data - Page 2

Ye_Myat_Aung · 08-18-2020 01:39 AM

Hi,

Let’s say I want to build a survey app where I want to display a site name (with enum list) in Burmese for user to choose, but the data will be saved in English.

I’m thinking to create two tables, one for Burmese (to display) and it will be referenced to English table.

But I just can’t seem to figure out how to configure it in the form designer.

For now, what I have done is as below

Main table referenced to Burmese table which then referenced to English table.

But the data is stored as Burmese now.

Koichi_Tsuji

Not entirely sure what your data schema and what you want to achieve globally, but I would suggest you simply make a table with key (english terms) as well as other data fileds with your own language. Then set own language to “Label” for that table.
When you call this table in a place such as ref type column which would generate the dropdown, your user will see own language, ie. the data field you set to label, while the actual data saved to the source is key value, i.e. english in this case.

View solution in original post