Hi all! I'm hoping someone can help me understand how the set formula works.
Let's say I have the following array of objects and I want to update the value of Item 2 to 250.
[
{
"id": "123",
"name": "Item 1",
"value": 100
},
{
"id": "456",
"name": "Item 2",
"value": 200
},
{
"id": "789",
"name": "Item 3",
"value": 300
}
]
I would think that I could do something like the first image, but that returns null I think because it's expecting an object as the first argument. So then if I back up one level, it seems like it's working (second image). However, it's only returning that final object.
Can someone help me understand how I can get my full array back with just a value in it changed? I'm guessing this is super easy and there's just something I'm missing.