topic Re: Arcade exp in Editing Form: Add 1 to last added value in Attribute Rules Questions

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

PanGIS — Tue, 28 Nov 2023 14:36:01 GMT

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!

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

EDUARDOARDILARINCON — Tue, 28 Nov 2023 14:45:35 GMT

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 😊

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

jcarlson — Tue, 28 Nov 2023 15:22:07 GMT

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.

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

PanGIS — Wed, 29 Nov 2023 16:16:04 GMT

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)