"Hi everyone, I am a beginner in AppSheet and I’m working on a Sewerage Infrastructure Project. I am looking for a ready-made sample or a template that includes:
Map Overlay: Showing Pipe lines and Manholes directly on the layout.
Status Tracking with Colors: Different colors for Excavation, Laying, and Backfilling.
Quantity Reporting: A dashboard that shows total lengths and counts.
PDF Export: A ready-to-print daily progress report.
If anyone has a similar project or can guide me to a template, I would be very grateful! Thanks in advance
AppSheet is great at collecting data, especially with offline sync but it is not built for mapping. You can log the position of manholes on site easily enough and get them to show on a map - but it is not easy, and not automated to show the connections on a map.
You want to look into GIS software for doing this as it is built for mapping. QGIS is free and open source for desktop use. You will then have to pay, or be very technical to get a mobile app up and running. Unfortunately AppSheet does not have a webview built in, so you can’t display and edit all of this data within one app.
It is a steep learning curve, and I am at the early stages but with GIS software, you can setup your project so lines can be drawn between chambers, you can then select them and change their status, you can connect (and host) GIS data on a database, and if it is in a database then you can connect AppSheet to it to pull reports.
Let me know what you find as I am also exploring similar.