I would like to create a custom map link on the fly that plots a bunch of stops (1 client per stop) on a route. The data is organized as one table for routes and one table for clients. Each route record has 20 Client ref columns to indicate the stops on that route (Stop 1, Stop 2, etc.). I’d love the Route record to have a button that takes you to the map of the stops. Can anyone advise on an efficient way to make this?
Maps in AppSheet show points but do not show routes. Can you look into whether you can do this via Google Maps? If there is a Google Maps URL that can display the information you want, then you can construct it with a virtual column formula in AppSheet