How to add field of type list with reference to sys_choice having correct language labels?

[Vespertinus]

Hello SNow community,

we added a new field u_languages to sys_user table of type list. We simply want to have a choice list with support of multiple selections (instead of only one as in normal fields with references)

Actually this works fine for this setup:

This also gives us the multiple value selector and slushbucket in the form.

Only drawback is that we figured out that handling correct language lable is not working. All users get full list of choices...

Any suggestions how to get this also running with correct language lables?

Thx and br

Vesp

[Vespertinus]

We managed to get filtered choices with correct langauge displayed (by refrence qualifier language=javascript:gs.getUser().getLanguage()).

But now facing issue: if user selects value in lang=en and then switches to lang=xy it still shows initial language entry (lang=en). This is of course reproducible since the "List"-Type uses sysid for reference that point to the unique entry in sys_choices list. But how to show the correct value?

I thought about of having multiple relations with "value" as key reference field instad of storing multiple "sysid" (comma separated) into target field. Only option we currenlty have is using related lists (as by default), but this is not very comfortable for user selections. For single selection fields it works fine (and it stores the "value" to record!), but not for multiple selections 😕

Any suggestions?

Thx and br

Vesp

[parvinder2]

Hi Vesp,

You can check with the Label of language like (English, German... ) and through client script can manage the visibility of choices.

hope this will help you.

Regards,

Parvinder

[Vespertinus]

Thanks for fast reply, do you have a sample client script to do this for multiple choice list entries? So there is no way to use value as reference for multiple choice lists? The stored reference "sys_id" will then be diffrent depending on language user had set when he selected the data entry, if possible i want to avoid this for future reports and usage...

Thx and br

Vesp

[parvinder2]

Hi Vesp,

You can check

if(language=='english'){

g_form.removeOption('label_name', choice_value);

}

OR

you can create the data lookup If you have multiple entries and in future also you can update the data.

Regards,

Parvinder