Display as a marker my location (latitude, longitude) from Airtable on a map

[nurshazlinnatasha]

hi, i am new to kodular. hope i can receive some helps from the expect.

i have my location data (longitude and latitude) store in mysql database. i want to display them as a marker on top of a map in my device built using kodular. do you have any idea how can i do so?

thank you so much. your help means the world to me <3

[Rogerio_Rios (Professional Support)]

Welcome.

Try :
From Mysql.

GPS with customized routes

Your pairs should be like this : [ { lat: 37.772, lng: -122.214 }, { lat: 21.291, lng: -157.821 }, { lat: -18.142, lng: 178.431 }, { lat: -27.467, lng: 153.027 }, ] In my case I returned a Json where the lat and long pairs existed and I assembled a string as shown above. Because the longitudes and latitudes are in a table in my database. In this table I have this latitude and longitude information for each person registered. So on the return Json, I took these pairs and assembled the pa…

[nurshazlinnatasha]

can you show me the blocks and the php? it might help me to understand the process.

[Rogerio_Rios (Professional Support)]

1-Access to php is with the web component.
2-I return to the Got Text event.
3-I use the join block and lookup pairs Key to assemble the Json string and create the markers.
4-PHP …
I query the database and return Json

Geolocation with radius of coverage

[Localizar locais comKodular +Extensão + Mysql] Next update: show the closest path.

[nurshazlinnatasha]

thats really help. but i was clueless how the php and the blocks will be to assemble the json string and return json

[Rogerio_Rios (Professional Support)]

Web Component

https://community.kodular.io/search?context=topic&context_id=113616&q=Web%20Component&skip_context=true

https://community.kodular.io/search?context=topic&context_id=113616&q=Web%20post%20&skip_context=true

Parse arrays of json data

Hello everyone, I am trying to figure how to parse a json response that contains 2 arrays of data. It contains the data as follow: { “tasks” : “task1, task2, task3”, “taskdetails” : “details1, details2, details3” } I need to put these into two separate lists to use to build a list item. [image] Any help would be greatly appreciated. Thanks

Json location geocoding

Hi, i’m trying to geocoding with locationiq these are my blocks [blocks] i have to extract from this string of json `[{"place_id":"330420772163","licence":"https:\/\/locationiq.com\/attribution","lat":"40.827675","lon":"14.203342","display_name":"25, Via Giacomo Leopardi, Rione Lauro, Naples, Napoli, Italy, 80125","boundingbox":["40.827675","40.877063","14.203342","14.308822"],"importance":0.25},{"place_id":"331827903224","licence":"https:\/\/locationiq.com\/attribution","lat":"40.877063",…

Continuing the search ,( in this community there are almost all responses posted )

Google Maps Marker

Show us your blocks cause you most probably you are doing something wrong. I use join text to create marker json with no problem [image]

[nurshazlinnatasha]

i cant found json component. why is it?

[Rogerio_Rios (Professional Support)]

Web Json Decode text Block

[Rogerio_Rios (Professional Support)]

This page was made for reading and learning.

https://docs.kodular.io/

[sugarlesscreator]

Hi @nurshazlinnatasha welcome to our community

is this what you expect? it uses google spreadaheet. you can customize it with mysql.

[Rogerio_Rios (Professional Support)]

Friend, if you want to make a system, you usually have(must) to know:
1-what you want to do
2-what you need to do
to achieve your goal
3-what you need to use to do
4-know how to use item 3 to do what you want
5- try to do