Creating an incrementing assetID for use in offline Field Maps with multiple users

[JonHoch]

I am working on developing an invasive plant treatment project for use in offline Field Maps. Currently have related table of inspections related by an ident of incrementing number plus species code that is a holdover from managing the data manually in ArcMap.

Is it possible to have something like this work with multiple users working offline?

Could there be a script where new offline points have ident left null and when synced to AGOL all null idents are calculated to receive an incrementing ID to allow multiple users to submit?

I'm also wondering if the use of these idents is antiquated and no longer needed and tables should be related based off another attribute.

Thanks for any insight!

[MobiusSnake]

I've done similar things in the past using something like this:

• Add an integer field to your layer named "processed" or "id_calculated" something like that, with "No" = 0 and "Yes" = 1
• Write a scheduled notebook that queries "processed=0" records every few hours, applies the edits you need, then flips the "processed" value to 1
• For your webmaps/apps/dashboards/etc., set up a feature layer view that has a filter so only "processed=1" records are included

The main downside of this is there could be a delay of a few hours between a record being submitted and it being visible to most users, however once it is displayed you can be sure that it's IDs and such will have been calculated correctly.