Dear ufuk,

To me, it does not make sense to localize all data in the database, If you want it, I think Goolgle Translate may be 1 choice for you.

If you want to localize for certain specific fields, I think you just can leverage dropdown list as you need to control what the users entered will have the localized string configured.

Best Regards

Tony Chu

Hi! It doesn't have anything to do with Google Translate. Simply the question is: how do you change the language of options in a dropdown list when a user changes his locale?

Ok, In this case, What I can think you may need to have a jquery to rebuild the label for the "Selecbox" by custom a ajax function to query the table "app_message".

so you mean, don't use joget's own dropdown, construct it yourself using jquery based on current locale? assuming you can access current locale setting from jquery?

Dear ufuk,

I will still use Joget drop down List (city), as we need to leverage the Joget Form to save the data.

Here is some idea from me.

First setup the List of Message with Message ID like "city_<cityName>"

So your sample : will be city_tripoli

and your database should have a field to store the label as  city_tripoli also.

Then we may apply the following Code

$(document).ready(function(){
	// Code here to use AJAX to get the label from app_message (sync Mode)
    // parameters : the localeCode and the prefix of City 
    // Query: select messageKey, message from app_message where appId=? and appVersion = ? and locale = ? and messageKey like ("city_%");
    // return full city list as Json array
	
	//Then execute the code below after get the data return
	
	$(FormUtil.getField("city")).find("option").each(function(){
		var orgLabel = $(this).text();
		// code here to get the newLabel from the result List by matching orgLabel = messageKey
        $(this).text(newLabel);
	});
});

Hope this help! 

My2Cent

Tony

Dear ufuk,

The other easy way to solve your problem is

In your Database config 3 cols, city, enLabel, arLabel

and create 2 drop downList with same ID, 1 display city as enLabel and 1 display as arLabel in 2 different Section

and at the permission of Section Check Is that section for the Current Locale if not invisible it

Best Regards

Tony Chu