---
title: "Translate Cell Value"
slug: "translate-cell-value"
updated: 2026-06-25T14:39:56Z
published: 2026-06-26T13:43:01Z
canonical: "skthelp.syniti.com/translate-cell-value"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Translate Cell Value

### Overview

In legacy Construct, cell values could display translated values to the Language ID associated with their user account using a Translate checkbox feature that looked up display values from catalog tables.

Cloud Construct does not have the Translate checkbox feature. Instead, it offers the following alternatives to display translated values:

### Updated Methodology

#### Approach A: Display Translated Values Directly

1. Create SQL view that JOINs the source table with lookup/catalog (translation) table. Include both code and translated display value in the same view. For example,

```plaintext
SELECT 
  o.OrderID, 
  o.OrderDate, 
  o.StatusCode,
  s.StatusDisplay as Status_Display
FROM Orders o
LEFT JOIN OrderStatus s ON o.StatusCode = s.StatusCode
```
2. Edit the required WebApp.
3. In the WebApp Builder, access the required page’s grid container and configure the dataset to point the view above.
  - Include both StatusCode and Status_Display fields
  - Hide StatusCode column if not needed
4. Save and Preview the WebApp.

Grid displays translated text instead of code.

#### Approach B: Dependent List Box Filters

1. Create a SQL view that contains both the code (from the source view) and the translated values, then register it as a list box dataset.
2. Edit the required WebApp.
3. In the WebApp Builder, access the required page’s grid container and configure a list box field using the list box dataset.
4. Apply list box filter to bind the code from the source grid, for example `ListBox.StatusCode = Grid.StatusCode`
5. Set the translated value as the list box **Display** value.
6. In the grid container, use the list box for the code column instead of the code column from the grid source dataset.

The column will display the translated value based on row's code. When the row data changes, the displayed value updates automatically.

**Example Translation Scenarios**

| Code Value | Lookup Table | Translated Display |
| --- | --- | --- |
| "A" | OrderStatus | "Active" |
| "P" | OrderStatus | "Pending" |
| "C" | OrderStatus | "Closed" |
| "US" | Countries | "United States" |
| "CA" | Countries | "Canada" |

### Related Articles

[Add a List Box](/v1/docs/add-a-list-box)