How to use an Excel table with data about coordinates and location in Kobotoolbox

[clemdegraaf]

Hi everyone,

First question, I hope I am not in the wrong category

Is it possible to create an Excel table with coodinates, countries, cities for already known location point, and to extract some information with some question

Like that, during the collect of arthropods in the field, just by indicating where the collect happened with a named point, every informations about the country, the city and the coordinates (Latitudes and Longitudes) appear automatically in choosen question.

Thanks you all,

[Kal_Lam]

Hi @clemdegraaf,

Welcome to the community! Are you looking for something that has already been discussed earlier:

Link answer to geopoint

Challenge accepted! Actually, yes you can… In XForms any instance element binding can contain a calculation, including geopoints, although in the Kobo KPI form builder this ability is not exposed. But you can certainly have a geopoint result with a calculated value in an XML XForm (!), and with a bit of a fudge you can mimic the same in an XLSForm; see selectgps.xls (19.5 KB) In this XLSForm the geopoint has a calculation that picks up the gps string from your selected…

Have a great day!

[clemdegraaf]

Thank You Kal_Lam,
I am going to work on that

[jlagod]

Hi, can you display the selected Country into the Searchbox of GeoPoint. Thanks

[Kal_Lam]

Welcome to the community, @jlagod! Could you describe your issue with a sketch, if possible? That should help the community understand your issue pictorially.