2. PHPRunner General questions
  3. [SOLVED] Lookup Wizard - List of values - multilingual
This topic is locked
[SOLVED]

Lookup Wizard - List of values - multilingual

 		4/4/2025 16:55:18
PHPRunner General questions
Davor Geci authorDevClub member

Hello guys/girls,

does anyone knows how to make the Lookup Wizard - List of values - multilingual?

For example I have this table definition:

CREATE TABLE business_partners (
partner_id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
**partner_type ENUM('customer', 'supplier', 'both', 'other') NOT NULL)**

now if the english is the lang it is 'customer', 'supplier', 'both', 'other'

but if it is croatian it is 'kupac', 'dobavljač', 'oboje', 'ostalo'

Any ideas?

Thanks,
Davor

img alt

Sergey Kornilov admin 4/4/2025

You cannot achieve this with ENUMs and List of values. The proper approach is to use database-based lookup wizard.

More info:
https://xlinesoft.com/phprunner/docs/localizing_runner_applications.htm
Davor Geci authorDevClub member 4/5/2025

Thanks for the quick reply and for solving my problem.
Yes, the database-based lookup wizard with combining the Dynamic SQL will solve the multilingual challenge, and not only in lookup, but this principle can then be used throughout the entire application, where and for which fields we want to be dynamically translated into the selected language.
Problem solved.
Thanks