idea Auto Increment ID Field for ArcGIS Collector with customized behavior in ArcGIS Collector Ideas

Auto Increment ID Field for ArcGIS Collector with customized behavior

AntonSizo_ — Fri, 24 Mar 2017 22:31:12 GMT

It would be nice to have auto Increment ID fields for ArcGIS Collector with customized behavior. For example, I need a filed which will automatically generate a unique ID for a new sample taken based on some rules, e.g. <Year><Surveyor Initials><Code Word><Int number>.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

SonyaRifkin — Thu, 01 Jun 2017 20:26:04 GMT

mant‌ Have you made any progress on this? We're trying to do something similar. Thanks for posting.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

AntonSizo_ — Mon, 05 Jun 2017 17:27:20 GMT

Not in Collector. At the DB level via triggers.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

MikeDawson — Fri, 30 Jun 2017 19:20:18 GMT

I need to auto generate unique site IDs from the project area polygon that I am currently in, along with the next available integer, e.g. "Discovery Bay 001". Sequential numbers help organize the workflow in time and space as field staff move along the shoreline. New sites are frequently collected, but old sites are also revisited. It is tedious to keep track of the next available sequential number.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

ScottPrindle — Wed, 07 Feb 2018 01:09:50 GMT

Thanks for submitting and voting on this idea! When you upvote this idea, please consider leaving a comment to describe how this functionality would fit into or improve your current workflows.

Thanks,

Scott

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

RobertBlash_HMM — Thu, 03 May 2018 19:34:23 GMT

We use collector as part of a hydrant inspection workflow, storing inspections in a related table. If a new hydrant is found the field user can collect it, but we need a unique (and friendly) AssetID for the hydrant-to-inspection relationship

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

AyeletGreenberg — Fri, 07 Dec 2018 22:34:54 GMT

Same for us.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

NicoleCeranek_MCTX — Tue, 11 Dec 2018 16:49:38 GMT

We would like an auto incremented number for our use in Workforce, Collector, and Survey 123 records. Field workers will work with numbered tickets and those numbers should be generated automatically. If possible, adding the ability to have the auto number prefaced with values from a polygons field, that would be icing on the cake. Refer to Mike Dawson's comment as example.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

Anonymous User — Wed, 23 Jan 2019 02:01:23 GMT

This would be useful for so many applications...the only available unique auto ID is GlobalID which is too long to be useful, or ObjectID which is not suitable as it does not conform to a customised pattern such as 0001, 0002, etc.

I want it to be able to add a spatial feature, automatically assigned a short unique sequential ID, which is then the key for a related table which then inherits that same ID. This is for observations of fauna or flora at a mapped sampling site.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

Z__NahideAydin1 — Thu, 31 Jan 2019 16:38:09 GMT

I am also looking into something like that. It has been a great problem to have a retained ID field that is not a GlobalID

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

ChadFoley — Mon, 18 Mar 2019 18:03:06 GMT

We would also like this option.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

Anonymous User — Thu, 04 Apr 2019 18:59:18 GMT

This would be a great option to have.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

TimLowrimore — Thu, 04 Apr 2019 21:27:40 GMT

We desperately need this too for a web editing field inspection scenario.

HEY ESRI! - Anyone listening???

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

DanielWebb — Mon, 22 Apr 2019 18:07:49 GMT

Like most others here, being able to auto-generate unique ids in Workforce, Collector, Survey 123, etc would be very helpful. It will keep things organized without relying on the user to come up with a unique id or "fat finger" a specific pattern that must be manually typed in.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

AmberWittner — Thu, 01 Aug 2019 22:32:17 GMT

USGS here...I think it's fair to say that the geologic mapping community at large, beyond federal government is in need of this capability. Geologists collect points and lines in the field, with domains. They also collect physical samples to take back to the lab for testing. Having the ability to generate a sampleID based on a station(observation point) would help immensely. Even more, if they could collect and log multiple physical samples and associate each with the station.

Ability to auto-generate IDs (stations) and also subIDs(samples) from IDs. And increment subIDs(samples).

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

KoryKramer — Tue, 03 Sep 2019 16:14:21 GMT

Has anybody on this thread tried using NextSequenceValue in Arcade to make this work on the feature service in Collector? Data Functions | ArcGIS for Developers

Because that function relies on already having a sequence configured in the database, I think you'd have to be working with an enterprise geodatabase, with the service referencing the data (i.e. not a hosted feature service).

Create Database Sequence—Data Management toolbox | ArcGIS Desktop

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

AmberWittner — Thu, 05 Sep 2019 19:10:15 GMT

If this is the case, it will not work for our workflow. All mobile collection is occurring via our orgs AGOL subscription. Working on a cloud based deployment of Enterprise, could possibly make our versioned managed services that reference an egdb work using this option, but what a pain. We also do not know the long term viability in funding for our cloud implementation. Likely a TON of folks that need this utility via AGOL.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

KoryKramer — Tue, 22 Jun 2021 09:01:42 GMT

https://community.esri.com/ideas/16977 would be a good up vote for you.

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

AmberWittner — Thu, 10 Oct 2019 17:03:55 GMT

Done. Thanks for the link!

Re: Auto Increment ID Field for ArcGIS Collector with customized behavior

JoannaEllis — Mon, 28 Oct 2019 15:43:50 GMT

Same for us also.