Country list

What is Cascading drop down? Cascading drop-downs are linked drop-down controls, where the content of the second drop-down depends on the selection of the first one. E.g., When you choose a Country in the first drop-down, the second drop-down State is automatically filtered to the list of states actually in that county. Cascading drop-downs are quite a common requirement, and unfortunately, SharePoint doesn’t support it out of the box.In this article, I’m documenting the implementation of cascading drop-down functionality in SharePoint list forms using InfoPath forms step by step (at least for my own reference! Even a simple mistake takes hours to resolve).In short: You create a new data source to retrieve “Region” and “Country” columns from the Countries list and then filter the countries drop down to show only items matching with the “Region” selected in “Regions” drop down.Here is my List setup:Regions – List of Regions – Parent List for Countries list’s Region column.Countries -List of Countries with Region as lookup column from “Regions” listProjects List – List to capture project data, Where Region and Country columns are from above lists as lookup columns.Step 1: Customize SharePoint List in InfoPath DesignerOpen the Project SharePoint list in the browser click on the “Customized Form” button under List Tab. This opens your SharePoint list form in InfoPath Designer. Alternatively, You can open InfoPath Designer and Customize SharePoint List form. This establishes the data connections between the SharePoint list and InfoPath. BTW, To utilize InfoPath browser farms, you need to have the SharePoint Server Enterprise edition and “SharePoint Server Enterprise Site Collection features” feature activated at the site collection level.Step 2: Create New Data Connection:Add new data connection in InfoPath to retrieve Country & its respective Region. Step 3: Change the Data Source of the “Country” Drop down and Apply Filter:Once we created the data source for the Country, Select the “Country” Drop Down in InfoPath form designer, Right Click and choose “Drop down List box Properties” to get the Control Properties window. In Data source dropdown, Select the new data source we created in Step 1 (In my case its: “Country”). Now, proceed to step.Apply Filter to Country Dropdown:The Next step is to filter country values in the Country drop-down based on the selected Region. In Entries section, click on the tree button. This brings Select Field or Group window. Select the d:SharePointListItem_RW node under “DataFields” and click on Filter

Country calling codes or country dial-in codes are telephone number prefixes for reaching telephone subscribers in the networks of the member countries or regions of the International Telecommunication Union (ITU). The codes are defined by the ITU-T in standards E. 123 and E. These are short alphabetic or numeric geographical codes which are developed to represent countries and dependent areas, for data processing and communications. Several different systems have been developed to do this. The term country code frequently refers to ISO 3166-1 alpha-2 or international dialing codes, the E.164 country calling codes.When we try to make international calls, it is important to work out which calling codes and numbers go where what to dial, and what not to dial. We have therefore created a useful list that will help you locate the right international calling codes for countries all around the world! Here is given the list of all the country codes. This list may help you out making international calls. Below is the comprehensive list of all the country codes.ContentsMost Popular Country CodesGet Detailed List of Country Codes HereCountry Codes ListYou may also likeMost Popular Country CodesCalling the USA: +1 Country CodeCalling the UK: +44 Country CodeCalling Mexico: +52 Country CodeCalling India: +91 Country CodeCalling China: +86 Country CodeCalling Pakistan: +92 Country CodeGet Detailed List of Country Codes HereNote: You can Download FREE PDF File at the Bottom of PageNote: You can Download FREE PDF File at the Bottom of PageCountryCodeTime ZoneAfghanistan+93UTC+04:30Albania+355UTC+01:00Algeria+213UTC+01:00American Samoa+1 684UTC-11:00Andorra+376UTC+01:00Angola+244UTC+01:00Anguilla+1 264UTC-04:00Antigua and Barbuda+1 268UTC-04:00Argentina+54UTC-03:00Armenia+374UTC+04:00Aruba+297UTC-04:00Ascension+247UTC+00:00Australia+61UTC+08:00

A variable.Reading Data from the Current RecordSpecific field (or column) values in a SQL::ResultSet are accessed using the data() method. The data() method returns the value for a column in the current row. The column is specified either as the column name or the column's number. For example, in the script below, the data() method is used to get the value of the "country" field:DIM countries AS CDIM country AS CWHILE conn.resultSet.nextRow() 'Get the country from the current record country = conn.resultSet.data("country") 'Test to see if the country is in the list IF (country !$ countries) THEN 'country was not found in the list 'Add the country to the countries list countries = countries + country + crlf() END IFEND WHILEIf you know the order of the columns in the query, you can use the column's number instead of the column name. For example:DIM sqlSelect AS C = .F.) THEN IF (conn.resultSet.nextRow() .F.) THEN country = conn.resultSet.data(2) END IFEND IF? country= "Spain"The SQL SELECT statement specifies 2 columns in the query: city and country. city is the first column, and country is the second column. conn.resultSet.data(2) returns the value of the country column for the current row of data in the result set.Specifying the column number can be faster in some situations. Using the column number also allows for dynamically retrieving data from a result set row using a loop. Use the conn.resultSet.ColumnCount property to determine the total number of columns in the result set.Closing ConnectionsWhen you are done querying the database, you should close the connection. Connections are closed using the SQL::Connection close() method.conn.close() 'Close the connectionCreating Queries with ArgumentsMost SQL queries include WHERE clauses to filter the results. For example, you may only want to fetch a list of customers from Spain. The SQL query to do this

Into regions. The list of regions is by no means exhaustive, pull requests very welcome for additions.countries An array of alpha2 codes for the countries in this region.CurrenciesIt is not that useful to just have the currency code(s) for a country, so included is currency data too:name The english name for the currencycode The ISO 4217 codenumber The ISO 4217 numberdecimals The number of decimal digits conventionally shownsymbol The currency symbol for the currency (e.g. ¥, $ etc.). Some symbols are not available, in which casesymbol contains the ISO 4217 code. Credit to bengourley/currency-symbol-mapfor the symbol database.LanguagesA list of languages provided by ISO 639-2;name The english name for the languagealpha2 The two letter ISO 639-1 code for the language (may be blank).alpha3 The three letter terminological ISO 639-2 code for the language (may be blank).bibliograpic The three letter bibliographic ISO 639-2 code for the language (may be blank).LookupTo make finding easier there are utility methods that can search the countries and currencies. See examples below.In the browserInclude the dist via the script tagscript src='dist/country-data-list.min.js' />script> window.CountryDataList.getSymbolFromCurrency('USD') //=> '$'script>Installingnpm install country-data-listExample usagees5var countries = require('country-data-list').countries, currencies = require('country-data-list').currencies, regions = require('country-data-list').regions, languages = require('country-data-list').languages, callingCountries = require('country-data-list').callingCountries;// .all gives you an array of all entriesconsole.log( countries.all );console.log( currencies.all );// countries are found using alpha2 or alpha3 (both uppercase)console.log( countries.BE.name ); // 'Belgium'console.log( countries.FRA.currencies ); // ['EUR']// callingCountries is like countries but only has entries with dialing codes.// currencies are accessed by their code (uppercase)console.log( currencies.USD.name ); // 'United States dollar'// regions

Are accessed using a camel case nameconsole.log( regions.europe.countries )var lookup = require('country-data-list').lookup;// Match a value (grab first from array) case insensitivevar france = lookup.countries({name: 'France'})[0]; // Or match one of several possible values.var eurozone_countries = lookup.countries({currencies: 'EUR'});es6import {countries} from 'country-data-list';console.log(countries.all);// You can also useimport {lookup} from 'country-data-list';// Match a value (grab first from array) case insensitiveconst france = lookup.countries({name: 'France'})[0];It is very simple for now - feel free to contribute more helpful accessors.Possible future additionsMore data for each country is most welcome. Obvious things that it might be niceto add are:CountriesWikipedia linksCoordinates (centroid, bounding box, etc)CurrenciesAdded Currency Symbol Mapsremoved External Dependency for currency-symbol-map. Now we have 4 methodscurrencySymbolMap => returns list of currency with name, number, symbolgetSymbolFromCurrency,getNameFromCurrency,getSafeSymbolFromCurrency,getSafeNameFromCurrencyOther similar bits of codelibphonenumber "Google's common Java, C++ and Javascript library for parsing, formatting, storing and validating international phone numbers."How to contributeYou can change on JSON.These are the steps required:# Clone the repo (or better your fork of it)git clone country-list# install the dependenciesnpm install .# Edit the countries.jsopen data/countries.js# Run the testsmocha# If all is ok commit and pushgit add .git commitgit push# Then send a pull request with your changes. Ideally use several small commits,# and reference a source that backs up the change.SourcesThe currency data was copied from the Wikipedia ISO 4217 page.The country calling codes came from the Wikipedia country calling codes page.Added typescript definations