I haven’t found a reliable way to generate an auto-incrementing counter within Survey123 that can reset annually without relying on external processes or manual intervention. Ideally, there would be a built-in way to create sequential IDs directly within Survey123 Connect, while also allowing dynamic elements like the current year and an automatic reset at the start of each new year. Using ObjectID isn’t ideal for reporting or user-facing workflows since it doesn’t reset and doesn’t provide meaningful context. A configurable ID system would make data much easier to manage, especially for tracking records over time. Right now, the available workarounds tend to involve things like pulldata, feature layer queries, or external scripts, which add complexity and can introduce points of failure.
It would be really helpful if Survey123 supported a native way to generate sequential IDs with optional reset conditions, such as by year or another field value.
Curious if others have found a clean workaround or would also benefit from this functionality.
