Jan-WillemSpeck
6 years agoQrew Assistant Captain
Additional info connected to ADDRESS FIELD
Hi there,
I'm building an app in which i will create a table for all global locations (about 5000)
I like to use the address field for this purpose.
We cannot add fields inside the ADDRESS field itself
However I would like to add automatically more country (and perhaps even city) specific information into my tables using the location's address field details.
For example I was thinking to create a table COUNTRYDETAILS that contains info like the TLD codes, The international telephone access code, The currency, A contact person, A selected provider, electrical power socket model, emergency telephone numbers etc etc..
So when I'm looking at a form with details for a site in Germany I can also see that that the TLD-code is DE, i need to dial +43, their currency is EURO, that Germany has 230V and power socket model 'SHUKO', etc etc.
Eventually I also like to pass and use this info further into the app in a purchase process where it will help to auto pre-select the correct currency and the correct country provider and present the applicable purchase items for a location center in that country (or city).
Thanks for your suggestions,
Jan-Willem
------------------------------
Jan-Willem Jan-Willem
------------------------------
I'm building an app in which i will create a table for all global locations (about 5000)
I like to use the address field for this purpose.
We cannot add fields inside the ADDRESS field itself
However I would like to add automatically more country (and perhaps even city) specific information into my tables using the location's address field details.
For example I was thinking to create a table COUNTRYDETAILS that contains info like the TLD codes, The international telephone access code, The currency, A contact person, A selected provider, electrical power socket model, emergency telephone numbers etc etc..
So when I'm looking at a form with details for a site in Germany I can also see that that the TLD-code is DE, i need to dial +43, their currency is EURO, that Germany has 230V and power socket model 'SHUKO', etc etc.
Eventually I also like to pass and use this info further into the app in a purchase process where it will help to auto pre-select the correct currency and the correct country provider and present the applicable purchase items for a location center in that country (or city).
Thanks for your suggestions,
Jan-Willem
------------------------------
Jan-Willem Jan-Willem
------------------------------