JSON to Individual text fields possible?

JJ

Hi,

I am wondering if this is possible to achieve? From my head maybe with a function?

I have a JSON field that when I receive the data, I would like to separate into different text fields.

Example:

JSON input

[{open: {day: 0,time: 0700},close: {day: 0,time: 1500}},{open: {day: 1,time: 0600},close: {day: 1,time: 1500}},{open: {day: 2,time: 0600},close: {day: 2,time: 1500}},{open: {day: 3,time: 0600},close: {day: 3,time: 1500}},{open: {day: 4,time: 0600},close: {day: 4,time: 1500}},{open: {day: 5,time: 0600},close: {day: 5,time: 1500}},{open: {day: 6,time: 0630},close: {day: 6,time: 1500}}]

Then the individual texts fields in DB would be “day 0 Open” “day 0 Closed” and so on. Is this possible? Thank you very much.

Michael Udinski

Hey @JJ certainly possible to do something like this. Are you just trying to take the various values from the object and insert them into a text string? This can be done with dot notation and variable text substitution.

https://youtu.be/VHpTRqr-ceY