How to display on a map 3 adress columns with 3 different colors for pins

[BertrandJ]

Hello,

I have a Google sheet with rows representing persons. For each row I have stored the name of that person, its birth location, its wedding location and its death location.

Now I would like to display a map with these 3 types of addresses for each person. A green pin for each birth location, a blue pin for a wedding location, and a red pin for death location. I could easily do it with slices if the 3 locations were in the same column, but it's simpler to store them in 3. The map view can only display one data column, and a secondary data column, and I can't even find a way to display the data column and the secondary with different pin colors.

How can I do?

Thanks for your help.

[Marc_Dillon]

Put all addresses in a single column. Add a [type] column to differentiate them and drive the color formatting. Add 3 rows per person.

[BertrandJ]

Hi Marc,

Thank you very much for your answer. For sure this would solve my issue with displaying the map. But then I would get another issue: I currently have a person form to onboard new persons. It is very straightforward, with the form filling in one row in a Google sheet tab. With what you propose, I would need to fill in the same row, plus 3 additional rows in a second tab. Is that possible with Appsheet?

[Marc_Dillon]

Sure, if you set it up to do so.

[BertrandJ]

Thanks.

Unfortunately I'm a newbie, and I'm not too sure about how to achieve that easily and efficiently.

Is a bot triggered by any update on the date columns of the person's row the way to go? This bot could then add several rows in the new "event date" table.