Looking for any ideas or assistance. I have been attempting for quite some time to figure out a way to automatically perform calculations to attributes as they are collected in the field. The main purpose was that I didn't want to have to manually run field calculations and joins to calculate these fields once data had been synced. The closest thing I've found to what I'm looking for is attribute rules. However, they are disabled for feature service layers.
Part of this process I imagined was that I also wanted to reference our corporate sync enabled layers and pull data from them to complete the calculations. However, the only way I was able to get this to work was by joining the tables and due several reasons it just wasn't efficient.
The best solution I finally found was using Survey123 and attaching csv's of the data tables I wanted to reference and then writing the calculations in Survey123, this gave me what I was looking for almost.... I had really hoped I had found a back door to attribute rules and it was pretty close...
I still have to regularly update the csv's which are very large datasets and are updated relatively frequently and the survey123 calculations do nothing for me when editing in Pro manually adding points or when appending old data to the new feature service layer.
Open to suggestions, not a pro GIS user but have had to learn a good bit of Arcade/SQL and Survey123 scripting to get where I'm at now so if python is the answer, then it is what it is....
Thanks,
-Alex
