# Put a marker on map from Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, map, airtable\ **Created:** [September 22, 2020, 2:26pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960 "2020-09-22T14:26:57Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 2:26pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/1 "2020-09-22T14:26:57Z")
I have been trying for days to get this to work with no joy so I was hoping someone could come to my rescue. I have an airtable sheet that has some columms including Latitude and Longitude. I would like to plot those as markers on a map once the app starts. I have gone over all of the tutorials, videos and all the different code blocks I could find and have not had success. Trying to iterate over the sheet does not put the markers on the map. Sometimes it crashes and sometimes not but still not location markers. I am really at my wits end trying to get this to work. Any help would be greatly appreciated. I know Jane (a thunkable employee) had this as a tutorial but it crashes the app when launching. I have tried many variations of that but they do not work. This is the link to her tutorial ([Airtable Map (show image when Marker pressed)](http://community.thunkable.com/t/airtable-map-show-image-when-marker-pressed/251154)) ![Screenshot from 2020-09-22 10-25-57](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6abfbfb763a1114dc538110675507ac892badb0.png) ---
**Author:** ![DuMonster](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dumonster/32/81287_2.png) [@DuMonster](https://community.thunkable.com/u/DuMonster)\ **Post date:** [September 22, 2020, 3:34pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/2 "2020-09-22T15:34:19Z")
Hello @dpalusak, **At a glance** Try removing the Airtable “GetRow” block from the “for each” block and use only the “addMarker” block. You will also need to swap the “value” block for the variable “j” block. As is, you are telling it get a row _for every row_ and trying to pull the row number from the latitude property found inside the longitude property (which doesn’t exist). Remember to always comb over your own project carefully when following a tutorial to ensure you haven’t missed the little things - > [@Airtable Map (show image when Marker pressed)](https://community.thunkable.com/t/airtable-map-show-image-when-marker-pressed/251154/1): > > **1. Display Markers from Spreadsheet** > > These blocks demonstrate how to add markers to your map based on the data in your Airtable spreadsheet. > > You get all of the rows from your spreadsheet, then get the properties of each of these rows (latitude, longitude, title, description) to add markers to your app. If your Airtable spreadsheet doesn’t include Title and Description data, you can leave those fields blank in the ‘Add Marker’ block. > > ![airtablemapready](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/8/c88f20fbb2c3e26fbadfbb63d8159d2cb5d2ca71.png) > > The block ‘for each item j in list’ can be found in the [control](https://docs.thunkable.com/control) blocks. > > You can learn more about working with Objects in your Thunkable X project in the [Objects docs](https://docs.thunkable.com/objects). Let me know if this doesn’t fix it and I will dig deeper for you! ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 4:16pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/3 "2020-09-22T16:16:13Z")
@DuMonster, Thanks for your reply, I really appreciate it. I tested what you suggested and the app crashes at launch both from the live test and installing the app to my phone. Here is the screenshot of my blocks after changing it. ![Screenshot from 2020-09-22 12-14-51](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/f/8fda30212dcfeb22faeaa68bff0fe53f3d2fee4f.png) ---
**Author:** ![DuMonster](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dumonster/32/81287_2.png) [@DuMonster](https://community.thunkable.com/u/DuMonster)\ **Post date:** [September 22, 2020, 4:24pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/4 "2020-09-22T16:24:18Z")
@dpalusak In your Airtable DB do you have you Latitude and Longitude fields set to # numbers or Text? ![de8719f8ae72cb0773e3a36ec34e2fb59e29c789_2_690x168](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/8/1835f6ef1f7ee0b7f12833d350dc5f74bdc9dae4.png) ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 4:26pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/5 "2020-09-22T16:26:05Z")
The are both set to # numbers. ---
**Author:** ![DuMonster](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dumonster/32/81287_2.png) [@DuMonster](https://community.thunkable.com/u/DuMonster)\ **Post date:** [September 22, 2020, 4:27pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/6 "2020-09-22T16:27:10Z")
And your column names match your get Property blocks? ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 4:43pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/7 "2020-09-22T16:43:20Z")
Yes they match. ![Screenshot from 2020-09-22 12-42-52](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/6/36c39fec67c62be0f070f62a90e597672d76d414.png) ---
**Author:** ![shane.holohan1864qsw](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/shane.holohan1864qsw/32/79553_2.png) [@shane.holohan1864qsw](https://community.thunkable.com/u/shane.holohan1864qsw)\ **Post date:** [September 22, 2020, 5:19pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/8 "2020-09-22T17:19:39Z")
I’d suggest you do a bit of error hunting. Add a label to your design and before the j-loop add an if error display error block. Then you’ll know if the problem is with getting the rows or adding the data to the map. Then I’d use a very basic version of the Airtable (two or three rows) and test that. Note that if any of your rows have empty latitude or longitude cells attempting to get that property will fail and the app will crash (because the property doesn’t exist). Empty rows will cause the same problem. If having empty cells is unavoidable, you’ll need an error protection routine that gets the properties of j, checks if the required property exists and only gets it if it exists. Hope that helps. ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 5:46pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/9 "2020-09-22T17:46:32Z")
@shane.holohan1864qsw, I added a display error block and label and they were coming up null when testing. Then I re-read what you said about empty rows crashing the app. After checking my airtable, I noticed that there was an empty blank row at the bottom of my sheet. Once I deleted that row and tested it worked!!! I can’t thank you all enough for helping me troubleshoot and fix this! Many thanks! Dan ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 5:47pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/10 "2020-09-22T17:47:06Z")
@DuMonster, Thanks for you help working with me to get this resolved! ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 22, 2020, 7:56pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/11 "2020-09-22T19:56:40Z")
Now I just need to implement the blocks so it doesn’t crash if there is an extra empty row. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 22, 2020, 8:45pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/12 "2020-09-22T20:45:02Z")
Check 1 cell from each row You could check for a value being present or length of characters in a cell needs to be over 1 or some other method to ensure there is data in the cell ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 28, 2020, 9:10pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/13 "2020-09-28T21:10:34Z")
@jared, Do you have any blocks examples of this? I am thinking through it but can not seem to come up with the logic. I am not sure of which blocks will get me this check. It would actually have to check all rows for data, correct? Thanks ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 29, 2020, 2:22am UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/14 "2020-09-29T02:22:40Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/7/3701a0df139c480f1dcfc2ed4f177e45103edd78.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/d/2deecf4a8c8f8f8b0d2e24bee5d7216746fcb3e0.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/2/d2dcbb0fe28209464e18085ecf291f11bdbd8702.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/8/980dcb22693e74a9dabfad67eddf60dc3156bbab.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e639bdbd0ec71d800b7f3afa74bb610219155b9.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/f/4f202630096984c0592a54ebd9e514c70895ab24.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/5/b589e25802e192f6382c9964debcba43e8fc0708.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/4/a43993be0c63d0bc4278825cae6dcfe14d52cfe7.png) Here I call an api. Split the response into lists. Then run a loop over the lists and add a marker each time. On my iPhone 100 markers every 5-7 Took approximately .5-.75 sec ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 30, 2020, 4:04pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/15 "2020-09-30T16:04:39Z")
@jared, Here is what I have so far. The app doesn’t crash but I don’t get any markers either. There really only individual cells that will be blank at this point and not necessarily an entire row although I guess that could be the case at some point. ![Screenshot from 2020-09-30 12-04-18](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a06ee898c43e3dba3f8ac7424cd3be1871dd6b8d.png) ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 30, 2020, 5:20pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/16 "2020-09-30T17:20:50Z")
Here is another one I tried based on one of your examples for " [How to query data from airtable](http://community.thunkable.com/t/how-to-query-data-from-airtable/379437)". The app is not crashing which I guess is good:) but still no markers. ![Screenshot from 2020-09-30 13-25-13](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/65c0020cceea2003e062893f37a5557e42f45a9e.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 30, 2020, 5:39pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/17 "2020-09-30T17:39:42Z")
do you have an airtable with coordinates in it already? can you share one with me? that would make this easier on my end. I can put together an example and have it for you probably tomorrow! ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 30, 2020, 6:32pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/18 "2020-09-30T18:32:57Z")
I would greatly appreciate that! I do have a test sheet that I can share with you. How should I do that? By inviting you by email? If so, what address should I use? ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 30, 2020, 6:44pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/19 "2020-09-30T18:44:43Z")
[jared.gibb@gmail.com](mailto:jared.gibb@gmail.com) ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 30, 2020, 7:01pm UTC](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960/20 "2020-09-30T19:01:08Z")
I just sent the email invite for the table. Thanks again Jared!! [Next page](https://community.thunkable.com/t/put-a-marker-on-map-from-airtable/839960.md?page=2)