Pre-populating data from previous month's inspection

Question

Hi everyone,

I have about 100 pieces of equipment that I need to track the number of times each specific piece of equipment operates each month. Is there a way to automatically add the previous month’s operation count to the current month’s inspection, so I can then enter the current month’s operations, and then calculate the number of operations (to be clear, I don’t need help with the calculations part).  Basically, when I do the April Inspection, I will select the piece of equipment, and the March counts pre-populate. Any help or advice is appreciated.

Thanks

MarkDuvall_ccec · Answer

Thanks MobiusSnake,

It was presented to me as a field requirement, but I like both the dashboard and pulldata ideas.

Thanks!

MobiusSnake · Answer

Sounds like a job for pulldata():

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415

Is this something your person in the field needs, however?  pulldata() doesn't work when you're offline so that's a consideration.  If it's something that you only need back at the office, it might be easier to use something like a Dashboard to calculate sums of all operation counts for each piece of equipment.  This would also let you do things like month-by-month operation count charts.