Arcade exp in Editing Form: Add 1 to last added value

Question

Hello!

Pretty basic question but I am still learning and it looks huge to me:

In an ArcGIS online editing forms I created an expression that concatenate 2 fields.

One is the result of a radio button choice, the other is a field that is supposed to calculate this value:

last imputed integer of the same field +1.
It is a incremental.

I do not manage to do so.

Any tip is appreciated, thanks!

PanGIS · Answer

Thank you @EDUARDOARDILARINCON and @jcarlson  for you reply

my "code" is a very modest count($layer)+1 that works until a feature is deleted so it cannot be a solution.

I need to pick the last value added in a field in the table and add 1 for the feature that I am adding.

If the last  bench has "500" code, the next is going to be 501.
I am not too familiar with the calculations and variables, and the result is that I am more confused than ever.

I tried to use the solution you suggested and it looks acceptable,

if I run the expression, the result is correct (see highlighted=501) as the last inputted no. id 500 in that field, but when I add a new feature in the editor I get 1.

I suppose it is somewhere needed that I ask to order by let's say object ID like:

orderBy($feature.newID_web, OBJECTID DESC) and my attempt is a disaster as I don't know how to integrate the orderBy (last screenshot)

jcarlson · Answer

Do you mean the last calculated value on any other feature? You may need some kind of FeatureSet function and a Filter to grab the most recently edited feature, if that's the case.

EDUARDOARDILARINCON · Answer

Hi @PanGIS !

Here you have a link  with information and examples about how to use increment operators:
Increment Operators.

If that doesn't work for you it would be helpul to have your code in order to analize it and try to find the best way to achive your goal.

Best regards,

Eduardo 😊