Not sure which community to post in as I'm open to any solution!
I have a portfolio of streetlight poles which need to be assessed/inspected regularly. These inspections allocate the pole a condition rating (1-5). This has been completed previously via Survey123 and is also possible to do via Field Maps through the Streetlight Management Solution.
HOWEVER I want to be able to:
- View data from previous inspections (this again seems doable via related records)
- Colour code the feature layer in a map based on the latest condition rating
It doesn't seem possible to do both! I have tried some arcade expressions posted on forums to bring data from related records/repeats into the core feature layer data to no avail.
