# Request to Change Table Data Language English to Chinese (zh)

**URL:** <https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 10, 2025, 5:47am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931 "2025-04-10T05:47:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![abhijit.jagtap](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@abhijit.jagtap](https://forum.inductiveautomation.com/u/abhijit.jagtap)\
**Post date:** [April 10, 2025, 5:47am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931/1 "2025-04-10T05:47:53Z")

</div>

I am writing to request a change in the table data language from English to Chinese (Simplified - zh)  
I have added all sentence in translation manager.

I have attached image for your reference

 ![1234](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/4/d4206fd4e384bb9d85733719c14b709df19b498b.png)  
.

my data received from below format. (using named quarry (json format))  
[  
{  
"id": 1887,  
"duration": "00:05:28",  
"dtreason": "Quality Issue",  
"comment": "Rejected Products due to quality",  
"ack\_status": "✅"  
},  
{  
"id": 1886,  
"duration": "00:00:22",  
"dtreason": "Power Failure",  
"comment": "Power Outage",  
"ack\_status": "✅"  
},  
{  
"id": 1885,  
"duration": "00:00:54",  
"dtreason": "Cleaning",  
"comment": "Cleaning machine",  
"ack\_status": "✅"  
},  
{  
"id": 1884,  
"duration": "00:00:24",  
"dtreason": "Scheduled break",  
"comment": "Operator at Scheduled break",  
"ack\_status": "✅"  
},  
{  
"id": 1883,  
"duration": "00:04:48",  
"dtreason": "Cleaning",  
"comment": "Cleaning machine",  
"ack\_status": "✅"  
},  
{  
"id": 1882,  
"duration": "00:00:06",  
"dtreason": "Quality Issue",  
"comment": "Rejected Products due to quality",  
"ack\_status": "✅"  
}  
]

I have added all text in translation manger please suggest me how to translate.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 10, 2025, 8:23am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931/2 "2025-04-10T08:23:57Z")

</div>

Welcome to the forum. Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

---

<div class="post-metadata">

**Author:** ![abhijit.jagtap](https://avatars.discourse-cdn.com/v4/letter/a/3bc359/32.png) [@abhijit.jagtap](https://forum.inductiveautomation.com/u/abhijit.jagtap)\
**Post date:** [April 10, 2025, 8:59am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931/3 "2025-04-10T08:59:55Z")

</div>

Hi. I want to translate when i selected language English (en) or chinses (zh) then all table data will translate in specific language.  
can you give me specific suggest me how can i do.  
in previous conversation i attached table image for your reference.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 10, 2025, 9:34am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931/4 "2025-04-10T09:34:15Z")

</div>

You said all that in post #1! Don't repeat.

The translate function will translate all the application text (buttons, headings, etc.) but not the table contents.

You will have to write a script transform on your table data binding to use

> **[system.util.translate | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-util/system-util-translate)**
>
> This function allows you to retrieve the global translation of a term from the translation database using the current locale.

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [April 10, 2025, 10:47am UTC](https://forum.inductiveautomation.com/t/request-to-change-table-data-language-english-to-chinese-zh/104931/5 "2025-04-10T10:47:50Z")

</div>

> [@Transistor](#):
>
> but not the table contents.

Really ? Huh...

Try this: Move your current binding to a custom property.  
Then put a structure binding on your table's `prop.data`. Bind it to the locale and to the custom property holding the data.  
Then add a transform that should look like this:

```python
return [
	dict(
		row,
		dtreason = system.util.translate(row['dtreason'], value.locale, [strict]),
		comment = system.util.translate(row['comment'], value.locale, [strict])
	) for row in value.data
]

```

note that `[strict]` should be a boolean. It determines the behavior when the value is not found in the translation dictionary:  
`False` (default) will make the function return the original term, `True` will make it return None. Take your pick.