Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a specific requirement
I want to give the user the option to select language from available options that are applicable for a country.
The user should be able to select any available language and also be able to change the language if wanted.
E.g. Lang_Table:
Country Language
Russia English
Russia Russian
China Mandarin
China Wu
China Jin
India English
India Hindi
India Tamil
I don't want the user to even see the language of other country in the drop down.
Any ideas???
see attachment for my idea
It uses OSUser and a trigger on the sheet.
Another option could be to use section access.
Yes this is right but not what I was looking for.
The users may have access to more than one country but when a country is selected only languages from that country should be visible.
Also 'hide excluded' does not serve the purpose as it hides the other languages for that country once a language is selected.
Any other solution!!!
You need to create a table, which has the language and the corresponding name for each item, which you would like to translate, like
Language, Title_Form1, Title_Form2, Name_Expression1, .....
Then also each object's descriptive elements need to refer to these Fields.
Selection of the language as proposed above (via Access), else it might be made by buttons within the application.
HTH Peter