topic Re: Arcade Wizards: Extract value from field. Possible with Slice or Split? in ArcGIS Online Questions

Arcade Wizards: Extract values from one field, where all the data is located.

ArmstKP — Tue, 25 Jul 2023 20:38:51 GMT

I have a field named ("last_values") that updates every five minutes, where a whole bunch of data comes in this one field. See the example data from this field, below. I want to extract into another field, the value (21.4191) that comes after "field1". Anybody have any ideas

{"field4":{"value":5,"created_at":"2023-07-24T19:45:15Z"},"log":{"value":507,"created_at":"2023-07-24T17:03:02Z"},"field3":{"value":181.44,"created_at":"2023-07-24T19:49:59Z"},"field1":{"value":21.4191,"created_at":"2023-07-24T19:55:02Z"},"field2":{"value":55.996,"created_at":"2023-07-24T19:55:02Z"},"field5":{"value":-45,"created_at":"2023-07-24T19:50:06Z"},"wifi":{"value":"ee:55:a8:0a:40:ef,-38;fe:55:a8:0a:40:ef,-38;ee:55:a8:0a:40:bf,-57;fe:55:a8:0a:40:bf,-58;02:18:4a:8c:49:62,-61","created_at":"2023-07-24T17:07:49Z"}}

Re: Arcade Wizards: Extract value from field. Possible with Slice or Split?

RhettZufelt — Tue, 25 Jul 2023 18:02:38 GMT

Not sure what you mean by values from field1 and field2. they are numeric, so you want to add them together or return both values as a text string?

Code below returns as a string on two lines:

Should give you an idea of how to get the values from the dictionary string.

Re: Arcade Wizards: Extract value from field. Possible with Slice or Split?

ArmstKP — Tue, 25 Jul 2023 20:25:11 GMT

@RhettZufelt Thank you for the example. I have clarified my original post, to better describe what I am trying to do.

I am working on understanding your example - I have tried the below and got the following error:

Re: Arcade Wizards: Extract values from one field, where all the data is located.

RhettZufelt — Tue, 25 Jul 2023 22:27:50 GMT

This works for me in form calculation and popup.

var dic = $feature.last_values var dicvar = Dictionary(dic) return dicvar.field1.value

as per your modified question, this returns the field1.value and returns as a number (21.4191)

Field Maps calculated value:

Popup: