Add a custom resetting Minute (Counter) Field in Table

joshuahirsch — Sat, 16 Nov 2024 06:37:05 GMT

Hello everybody,

So I want to have the minute to every Field in the Array (see below) like there would be the index of the field.

So its a resetting counter, which resets everytime, a new KEY_marker is different.

Desired Output

Load Script with some testing:

Data comes from REST as JSON, its an Array like that:

"MASTER_DATA_DEVICE_ID": "",
"cpr_sum": [null,null,null, 88, 99, 87],
..."

From JSON REST

Feels like im close, but don't know further

Re: Add a custom resetting Minute (Counter) Field in Table

joshuahirsch — Tue, 12 Feb 2019 13:31:00 GMT

Ah nevermind, I knew i was close.

autoNumber(RowNo(),[__FK_cpr_sum]) as autoMinute

did the trick 🙂