Oftentimes, the options for automating attribute calculations in ArcGIS hosted feature services can seem limited. One of the most common approaches is leveraging external tools such as Python, FME, or Power Automate. While powerful, these solutions can be difficult to maintain for end users who have limited exposure to ArcGIS. This presentation will highlight a novel alternative solution for automation when working with hosted services. We will discuss how our team created an ArcGIS field map that enables complex, automated data calculations on hosted services to track stormwater asset inspection and maintenance statuses year-to-year and determine their optimal inspection schedules based on newly collected data. Our solution leverages a combination of Arcade-powered smart form calculations and map symbology in conjunction with a hosted join layer to achieve all automation on-the-fly within the web map, eliminating the need for external processes.
