I have a heavily nested JSON structure and I'm trying to access the value of one nested field to use in a formula for another nested field at the same level.
The nesting can be seen in the expression below. participants and identities are both JSON arrays, identifier is an object and type is a field. I'm trying to access this from the formula sections for the field:
I'm trying to access this from the formula section for the field: event.participants.identities.identifier.value
What I get when I use this expression in the formula is:
"value": "error: Field 'event.participants.identities.identifier.type' not found"
Can you help me understand what I'm missing?
Sorry if it's obvious, and I'm been dumb, I have read other posts first