tag:blogger.com,1999:blog-28669706.post6937254963403230390..comments2024-03-25T08:33:57.056+01:00Comments on Gustaf's Microsoft Dynamics CRM Blog: Javascript event handling and dynamic lists in SharePointGustaf Westerlundhttp://www.blogger.com/profile/02522937600083440624noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-28669706.post-84489907152331077812010-08-13T09:47:35.146+02:002010-08-13T09:47:35.146+02:00Hi,
Well, your going out on a stretch to make this...Hi,<br />Well, your going out on a stretch to make this work if you want to make it supported.<br /><br />I think that the best way to do this supported is to create a very small (1 row) aspx-page with cross-frame scripting that communicates with the lookup field (that you should hide on a hidden tab) and sort of renders it as it should. That way, it could probably show the correct country name since you can pick up the users locale via javascript or via the IFrame object arguments.<br /><br />In general I think that picklists really are preferable when working with this kind of data in a multi-lingual setup since they fully support multi language out of the box. It is a bit problematic when you want to use the same picklist in several entities but I think that there is no simple way out with the current version of CRM. I don't know if MSFT have changed anything in this area for CRM 5 but I don't think so.Gustaf Westerlundhttps://www.blogger.com/profile/02522937600083440624noreply@blogger.comtag:blogger.com,1999:blog-28669706.post-38503194710945837962010-08-12T23:34:10.549+02:002010-08-12T23:34:10.549+02:00Gustaf,
Thanks for the feedback. Another idea tha...Gustaf,<br /><br />Thanks for the feedback. Another idea that is often discussed is the option to add Country as a new entity. Problem is that it makes it difficult to localise the country names. I made some tests and created a country entity as follows:<br /><br />* ISO 3116-1 Numeric Value: such as 4, 248, 8<br />* Name (English): such as Afghanistan, Åland Islands, Albania<br />* Name (Portuguese): such as Afeganistão, Ilhas Åland, Albania<br /><br />Then I make a relationship with the Account entity. Problem with this option is that I haven't managed to make the proper country name load as per the loaded user locale.<br /><br />At the moment, it only shows the ISO 3116-1 values. Say, if I select Afghanistan, it shows "4". The idea is to show "Afghanistan" if the locale is in English, or "Afeganistão" if the system is in Portuguese.<br /><br />If I managed to make this work, this entity could even hold mor information, such as the country's dialing code, which could then be used to forms jScripts to validate phone numbers.<br /><br />Thoughts?pmdcihttps://www.blogger.com/profile/09497554005567837862noreply@blogger.comtag:blogger.com,1999:blog-28669706.post-37623472135456233992010-08-12T16:36:01.334+02:002010-08-12T16:36:01.334+02:00I agree, a very good comment to avoid future probl...I agree, a very good comment to avoid future problems and it can probably be generalized to go for other types of attributes aswell where there is a standard enumeration that can be used.Gustaf Westerlundhttps://www.blogger.com/profile/02522937600083440624noreply@blogger.comtag:blogger.com,1999:blog-28669706.post-85288364967522134842010-08-12T16:31:07.827+02:002010-08-12T16:31:07.827+02:00Just one hint when adding Countries in a dropdown ...Just one hint when adding Countries in a dropdown list.<br /><br />Since dynamics CRM (at least v3 and v4) only allow numeric values in for dropdowns, the idea of adding countries in a sequential integer order, such as:<br /><br />Afghanistan = 1<br />Åland Islands = 2<br />Albania = 3<br />[...]<br /><br />...In my opinion, is a bad this is a bad idea, since if a country is added or removed from the list, it might be difficult to keep track, or even result in mismatches.<br /><br />I strongly recommend fellow CRM users to use the ISSO 3116-1 unique numeric value for each country instead (source: http://en.wikipedia.org/wiki/ISO_3166-1). So in case a new country is added or removed, you will never have mismatch issues in the future.<br /><br />following this idea, a country list would look something like this when following the ISO 3116-1 numerical values:<br /><br />Afghanistan = 4<br />Åland Islands = 248<br />Albania = 8<br />[...]<br /><br />Just my two cents :)pmdcihttps://www.blogger.com/profile/09497554005567837862noreply@blogger.com