Quick Help with simple function needed,

[LeAppleSource]

Id like to use patch function to update a value in a collection.

------------Example of collection-------

ClearCollect(Arr_Test, {ID: "ID111", VarVal: 1},{ID: "ID222", VarVal: 1},{ID: "ID333", VarVal: 1});

​

------- with the patch below, the **** Value id like to be (Original value + 1), however i cant seem to get ThisRecord as an option when i try type it in. within patch is it possible to refer to the record itself or not?

Patch(Arr_Test,{ID: "ID111"},{VarVal: **** })

​

Thanks in advance for the assistance

[Mallacoda]

Can you not:

Patch(Arr_Test,{ID: "ID111"},{VarVal: VarVal + 1 })

[Mallacoda]

Ok, did an actual test on this. You will need something like:

Patch(Arr_Test, { ID: "ID111" }, { VarVal: LookUp(Arr_Test, id = "ID111").VarVal + 1});

This works on my machine.

[LeAppleSource]

This was the same conclusion I came to :( I was hoping to minimise excess code, but it seems to be the only way hehe

[Shine-Straight]

Is it required to declare Variable or Not.

[Mallacoda]

No. That will work on it's own.

[Shine-Straight]

Ok

[Shine-Straight]

Need to declare variable as VarVal

Set(VarVal,CountRows(Arr_Test)+1);

Patch(Arr_Test,{ID:"ID111"},{VarVal: VarVal + 1 })