Help plotting on Map

Jon Barto

What is the best way to plot points and data on a map.

What I am looking for is a way to use a single map to show different jobs.

We create a job by copying a template of sheets. One of those sheets are the "data" sheet that holds the Job Name, Job Address, Project Manager, and Phase. All of these are in their own columns.

So when we create a new job we copy the template and rename it.

Say we have 10 jobs all with different "data" sheets with the above info. Any suggestions on how to show the jobs on a map according to phase and then by project manager?

I looked into mapsley and for that to work well you need all the data on one sheet.

Any suggestions on where to start?

Paul Newcome

You could try creating a row report and referencing each of the job sheets to pull it all together.

Jon Barto

@Paul Newcome

I did think of that. That would work perfectly, but I don't know of any map program that will import from a report. I know mapsly doesn't import from reports. It has to be from a sheet.

Andrée Starå

Hi @Jon Barto

I hope you're well and safe!

You could use a Report and then Data Shuttle to update a Sheet connected with Mapsly.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!