Hi,
so I have a very simple JSON structure I want to populate
name,
value,
timestamp,
unit (only if name is a specific value)
in name, I have used custom list set with all the values I expect (and set this sequential) and checked the output looks right.
I have set a formula in the value field to be
if name === ‘time’ then epoch(now) else random(100, 200) end
and this does set a timestamp in the value for time, all others get a random number.
Couple questions on this. Can I more fine tune the random numbers to be floats or is it only whole numbers? Second, the value will be different for each type I store in name, so can I use a switch statement in formula, or would I need to use a lot of nested ifs?