Enabling Bilingual (English/Arabic) Search in Customer Field

Scenario

In our order form, we have a customer search field. Our customer records contain both English and Arabic name fields to accommodate our bilingual team (some employees only speak English, others only Arabic).

Current Behavior

Currently, the search function only works for one language at a time (either English OR Arabic, depending on which field is mapped as the “ID” in the relation field).

Desired Solution

We need the ability to:

  1. Search customer names in both English and Arabic simultaneously
  2. Display results in the user’s preferred language (or both)

Additional Context

  • Attached: Screen recording demonstrating the current single-language search limitation
  • Example: Searching “محمد” should return records where either the Arabic name field contains “محمد” OR the English name field contains “Muhammad”

Questions

  1. Is there a built-in way to configure bilingual search?
  2. If not, what would be the recommended customization approach?

2025-05-19_16-24-19.zip (1.9 MB)

Are the customer names in two languages two separate fields?
The simplest way is to display both fields in the filter form, and users can use the field for the language they want to search in.
Further, we can provide “the current user’s language” as a variable, so that linkage rules can be configured on this block to only display the field for the current user’s language.