Jump to content


Photo

Country Pull-down

Accounts Modules

  • Please log in to reply
4 replies to this topic

#1 bigbankclub

bigbankclub

    Member

  • Members
  • PipPip
  • 12 posts
  • LocationCanada

Posted 14 January 2020 - 10:23 AM

I see I can make custom pull downs. But is there a more efficient way of getting all 195 countries into a pull-down for the contacts, instead of a text field?



#2 X2Clifton

X2Clifton

    Advanced Member

  • Moderators
  • 49 posts

Posted 15 January 2020 - 10:10 AM

Hi bigbankclub,

 

Do you have access to your MySQL command line?



#3 bigbankclub

bigbankclub

    Member

  • Members
  • PipPip
  • 12 posts
  • LocationCanada

Posted 15 January 2020 - 02:06 PM

I sure do. 

 

If you can or someone can tell where and how - I can do this. 



#4 X2Clifton

X2Clifton

    Advanced Member

  • Moderators
  • 49 posts

Posted 16 January 2020 - 09:59 AM

Hi bigbankclub,

 

What does your data set look like? Do you already have a dropdown made for contacts and just want to insert the data into it?



#5 jack

jack

    Admin

  • Administrators
  • 31 posts

Posted 28 January 2020 - 09:18 AM

Bigbankclub, here is an example entry for making a drop down with all the countries. You need to insert it into the dropdown table in your database to use it. Hope it helps.

 

 

     name: Countries
  options: {"":"","Albania":"Albania","Algeria":"Algeria","Andorra":"Andorra","Angola":"Angola","Anguilla":"Anguilla","Antigua and Barbuda":"Antigua and Barbuda","Argentina":"Argentina","Armenia":"Armenia","Aruba":"Aruba","Australia":"Australia","Austria":"Austria","Azerbaijan":"Azerbaijan","Bahamas":"Bahamas","Bahrain":"Bahrain","Bangladesh":"Bangladesh","Barbados":"Barbados","Belarus":"Belarus","Belgium":"Belgium","Belize":"Belize","Benin":"Benin","Bermuda":"Bermuda","Bhutan":"Bhutan","Bolivia":"Bolivia","Bosnia and Herzegovina":"Bosnia and Herzegovina","Botswana":"Botswana","Brazil":"Brazil","British Virgin Islands":"British Virgin Islands","Brunei":"Brunei","Bulgaria":"Bulgaria","Burkina Faso":"Burkina Faso","Burundi":"Burundi","Cabo Verde":"Cabo Verde","Cambodia":"Cambodia","Cameroon":"Cameroon","Canada":"Canada","Cape Verde":"Cape Verde","Caribbean Netherlands":"Caribbean Netherlands","Cayman Islands":"Cayman Islands","Central African Republic":"Central African Republic","Chad":"Chad","Channel Islands":"Channel Islands","Chile":"Chile","China":"China","Colombia":"Colombia","Comoros":"Comoros","Costa Rica":"Costa Rica","Cote d Ivoire":"Cote d Ivoire","Croatia":"Croatia","Cuba":"Cuba","Curacao":"Curacao","Cyprus":"Cyprus","Czech Republic":"Czech Republic","Democratic Republic of the Congo":"Democratic Republic of the Congo","Denmark":"Denmark","Djibouti":"Djibouti","Dominica":"Dominica","Dominican Republic":"Dominican Republic","Ecuador":"Ecuador","Egypt":"Egypt","El Salvador":"El Salvador","England":"England","Equatorial Guinea":"Equatorial Guinea","Eritrea":"Eritrea","Estonia":"Estonia","Ethiopia":"Ethiopia","Europe":"Europe","Fiji":"Fiji","Finland":"Finland","France":"France","Gabon":"Gabon","Gambia":"Gambia","Georgia":"Georgia","Germany":"Germany","Ghana":"Ghana","Great Britain":"Great Britain","Greece":"Greece","Grenada":"Grenada","Guadeloupe":"Guadeloupe","Guatemala":"Guatemala","Guinea":"Guinea","Guinea Bissau":"Guinea Bissau","Guyana":"Guyana","Haiti":"Haiti","Honduras":"Honduras","Hong Kong":"Hong Kong","Hungary":"Hungary","Iceland":"Iceland","India":"India","Indonesia":"Indonesia","Iran":"Iran","Iraq":"Iraq","Ireland":"Ireland","Israel":"Israel","Italy":"Italy","Ivory Coast":"Ivory Coast","Jamaica":"Jamaica","Japan":"Japan","Jordan":"Jordan","Kazakhstan":"Kazakhstan","Kenya":"Kenya","Kiribati":"Kiribati","Kosovo":"Kosovo","Kuwait":"Kuwait","Kyrgyzstan":"Kyrgyzstan","Laos":"Laos","Latvia":"Latvia","Lebanon":"Lebanon","Lesotho":"Lesotho","Liberia":"Liberia","Libya":"Libya","Liechtenstein":"Liechtenstein","Lithuania":"Lithuania","Luxembourg":"Luxembourg","Macedonia":"Macedonia","Madagascar":"Madagascar","Malawi":"Malawi","Malaysia":"Malaysia","Maldives":"Maldives","Mali":"Mali","Malta":"Malta","Marshall Islands":"Marshall Islands","Martinique":"Martinique","Mauritania":"Mauritania","Mauritius":"Mauritius","Mayotte":"Mayotte","Mexico":"Mexico","Micronesia":"Micronesia","Moldova":"Moldova","Monaco":"Monaco","Mongolia":"Mongolia","Montenegro":"Montenegro","Montserrat":"Montserrat","Morocco":"Morocco","Mozambique":"Mozambique","Myanmar":"Myanmar","Namibia":"Namibia","Nauru":"Nauru","Nepal":"Nepal","Netherlands":"Netherlands","Netherlands Antilles":"Netherlands Antilles","New Caledonia":"New Caledonia","New Zealand":"New Zealand","Nicaragua":"Nicaragua","Niger":"Niger","Nigeria":"Nigeria","North Korea":"North Korea","Northern Ireland":"Northern Ireland","Norway":"Norway","Oman":"Oman","Pakistan":"Pakistan","Palau":"Palau","Palestine":"Palestine","Panama":"Panama","Papua New Guinea":"Papua New Guinea","Paraguay":"Paraguay","Peru":"Peru","Philippines":"Philippines","Poland":"Poland","Portugal":"Portugal","Puerto Rico":"Puerto Rico","Qatar":"Qatar","Republic of the Congo":"Republic of the Congo","Reunion":"Reunion","Romania":"Romania","Russia":"Russia","Rwanda":"Rwanda","Saint Barthelemy":"Saint Barthelemy","Saint Helena":"Saint Helena","Saint Kitts and Nevis":"Saint Kitts and Nevis","Saint Lucia":"Saint Lucia","Saint Martin":"Saint Martin","Saint Vincent and the Grenadines":"Saint Vincent and the Grenadines","Samoa":"Samoa","San Marino":"San Marino","Sao Tome and Principe":"Sao Tome and Principe","Saudi Arabia":"Saudi Arabia","Scotland":"Scotland","Senegal":"Senegal","Serbia":"Serbia","Serbia and Montenegro":"Serbia and Montenegro","Seychelles":"Seychelles","Sierra Leone":"Sierra Leone","Singapore":"Singapore","Sint Maarten":"Sint Maarten","Slovakia":"Slovakia","Slovenia":"Slovenia","Solomon Islands":"Solomon Islands","Somalia":"Somalia","South Africa":"South Africa","South America":"South America","South Korea":"South Korea","South Sudan":"South Sudan","Spain":"Spain","Sri Lanka":"Sri Lanka","Sudan":"Sudan","Suriname":"Suriname","Swaziland":"Swaziland","Sweden":"Sweden","Switzerland":"Switzerland","Syria":"Syria","Taiwan":"Taiwan","Tajikistan":"Tajikistan","Tanzania":"Tanzania","Thailand":"Thailand","Timor Leste":"Timor Leste","Togo":"Togo","Tonga":"Tonga","Trinidad and Tobago":"Trinidad and Tobago","Tunisia":"Tunisia","Turkey":"Turkey","Turkmenistan":"Turkmenistan","Turks and Caicos Islands":"Turks and Caicos Islands","Tuvalu":"Tuvalu","Uganda":"Uganda","Ukraine":"Ukraine","United Arab Emirates":"United Arab Emirates","United Kingdom":"United Kingdom","United States Virgin Islands":"United States Virgin Islands","Uruguay":"Uruguay","Uzbekistan":"Uzbekistan","Vanuatu":"Vanuatu","Vatican City":"Vatican City","Venezuela":"Venezuela","Vietnam":"Vietnam","Wales":"Wales","Western Sahara":"Western Sahara","Yemen":"Yemen","Yoguslavia":"Yoguslavia","Zambia":"Zambia","Zimbabwe":"Zimbabwe","United States":"United States"}
    multi: 0
   parent: NULL
parentVal: NULL






Also tagged with one or more of these keywords: Accounts, Modules

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users