JSON in dynamic fields

Sotirios Zormpas One way, if I needed a choice field of all years in a table (i.e. my invoice tables). You could create a static list, but then you have to update it every year.

Sotirios Zormpas Another case would be to make a choice list that is modifiable by end users through a script without having to create a new table.

Sotirios Zormpas Ninox initial response to my question was that they don't support JSON. When I wrote back they got back to me a couple of days ago, which I missed and they said the same thing.

Anyways, thanks for posting in the German forum. It must be nice for them to have Frank respond.

RoSoft_Steven I don't see any changes. when I do text(dMC) I get a blank formula field. If I do just dMC then it shows the selections. If I do debugValueInfo(text(dMC)) it shows string("").

RoSoft_Steven I'm in public cloud, so yes.

Here is what it looks like:

RoSoft_Steven Here is my json code:

let originalFruit := split(originalChoices, ", ");
for i in range(1, count(originalFruit) + 1) do
    {
        id: i,
        caption: item(originalFruit, i - 1)
    }
end

which gives me:

and it is this field that I put in my dynamic choice fields.

and

Sotirios ZormpasPlaying around I figure out this long way.

I start with five items.

1. formula field that builds my JSON
2. a text field called originalChoices
3. a text field called newChoice
4. a button
5. a dynamic choice field that uses the formula field from 1

Here is formula in the formula field:

let originalFruit := split(originalChoices, ", ");
for i in range(1, count(originalFruit) + 1) do
    {
        id: i,
        caption: item(originalFruit, i - 1)
    }
end

here is what it looks like at the start:

Here I am adding a new choice:

And here it is after adding:

Here is the code for the Add Choice button:

let x := originalChoices;
let y := if not contains(originalChoices, newChoice) then
        originalChoices + ", " + newChoice
    end;
if y != null then originalChoices := y end;
newChoice := null

There is a bit of error checking but not very robust.

I'm sure someone smarter will come up with a quicker way, so I look forward to it.