Free Template w/ full details of every UN country

[Jaime]

Hey all,

I had to collect global country data for a project so thought I would share more widely so that people can use the data.

It’s a full list of 197 countries, their flags, country code & co-ordinates. That’s all 193 UN member states, plus Palestine, Taiwan, Kosovo and the Vatican. The data is from Google.

Pretty handy data in case you ever need to plot every country on a map or show every country in a choice component.

In the app, you can check off countries you’ve visited and view them on a map.

Copy away, have fun & post a link to anything cool you create in here.

Countries

[Wiz.Wazeer]

Thank you.

[ThinhDinh]

Thank you Jaime.

[gvalero]

Thanks… great tool!

[Ofer_Chama]

Thanks Jaime, that’s super helpful!

Too bad I compiled a list of my own just a week ago

Yours is more detailed though, so I’ll definitely use it in the future.

[Christophe_HK]

Nice app!

Now you know the 24 countries & continents where I’ve been!

[Jaime]

Nice, good list

[valerio]

Great !!

[Krivo]

@Christophe_HK and I know as well

Copy this app - GDPR databreach

My app’s URL: any copyable app - but example : https://197countries.glideapp.io/ When an app with sign-in “public with e-mail” is made copyable the Users sheet still contains the existing users e-mail adress when it is copied. That is a GDPR databreach. The rest of the user specific data seems to be removed but the actual user specific entries (which countries have you visited) are actually accessable in the builder if you use the “Preview as” Edit Favorites which is user-specific data are al…

[Christophe_HK]

I still wait your invitation to drink a beer @Krivo, I then will be able to add one more country in my shared list!

[Krivo]

@Christophe_HK Hereby given When will you be here? I have a large tent in the garden with draft beer - son finished high school yesterday.
You can just give a call when you are in the vicinity of Copenhagen

[Christophe_HK]

Challenge accepted! It would be nice to meet! If you come in Nice area, do not hesitate to let me know, we have also draft beer (local!) and our “limoncello” is tasty (with ice cubes, lot of ice cubes!) !

[Christophe_HK]

Yep, personal user specific data should be avoided, and all personal data should remain in a gsheet (in a pro Gsuite drive)…

Sad (but now HAPPY) story. Lost 8 projects over GDPR issues - new feature added

Hey @Rosewebstudio Problem is that to keep in sync with GDPR requirements, you have to proof the user has voluntarily and clearly given his consentement and that he’s been clearly informed about the why, the what and the how. So in your database, you have to store the date of his consentement, and even the name of the consentement form. That means you do need at least one checkbox to collect his email for sign-up and/or login, plus other checkboxes if you also need his consentement for other pu…

[Lucas_Pires]

Thanks @Jaime! I’ve visited only my own, unfortunately lol

[Jaybird_Farrow]

Thank you for this… i’m working on a project this will come in handy… much appreciated…

[Jaime]

Glad I could be of assistance

[spencersRus]

I am teaching a class on using glide to build a basic app. I shared this with some of my students. I had someone ask if anyone made a similar one for the 50 states of the USA.

Is there anyone out there who has made one for visiting states in the United States?

Thanks for this great resource!

[Jaime]

Nice. If you get hold of the state data send it through and I’ll add it to the app

[spencersRus]

Well, not as fancy as your masterpiece (I kept it public for my kids to use) - But I copied your app and changed the facts to the USA.

https://50nifty.glideapp.io/

[Jaime]

Nice, thanks @spencersRus. I’ve added the states to the USA.

And now you can set your location & see how far each country is away from you, using the location component.