Get size of array/object in a formula?

Is it possible to get the size of an array/object in a formula, such that you could use an IF() function on it?

Like, the [5] in this image:


Can I use that in a formula?

1 Like

Hey @ashuttl :wave:t4: thanks for reaching out and sorry about the delay in writing back :sweat_smile:

Yes, you can get the size by using the length() option in our PARSE function like so β€”

A list of all the supported functions can be found here β€” GitHub - json-path/JsonPath: Java JsonPath implementation

In case you need help with setting any of this up, please don’t hesitate to reach out again :innocent:

1 Like