Airtable and Google maps markers

Once again I need your help :slight_smile: I use airtable as a database to store car accidents. In the database I store date, address and json strings. When app opens json strings are received from airtable and markers are visible on Google map to show where an accident occured . When I have identical strings I find duplicates and count how many times appear in the database.

After that I want to change the color in the marker to represent that number for a example if a json string is present more than 5 times change color to orange and if it present more than 10 times to red.

My thought was to something like in the following picture for each item in list (json from airtable) to create two lists one with unique_json and one with unique_count but it doesn’t work . I get four unique json strings and each count is 2, 2, 2 ,1.

Then I try to compare the value from each count and replace the color in json string but it doesn’t work as intended . Any suggestions ? Where do I do wrong ?

Thank in advance and Happy New Year !

I kept trying to find my mistake and finally got it :slight_smile:


That’s a nice procedure. Can be very usefull for different things. :+1:

1 Like

Drop AIA of your project

Thank you @Peter and Happy New Year !

@shittuwale02 I’m still working the app as it is for a school project. Μe and my team will present the app in mid February but after that I will gladly share the aia

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.