Arrays are great for puling values from all related items. However, you need a 1-to-1 correspondence between two arrays, or (ifyou'll get an offset between index numbers, thus values.
Of course, you can make a field required and enter a default value, but ti's potentially very tedious with text and number fields.
You can otherwise use calculation fields to come up with a dummy value if field value is missing, but it's cumbersome.
I was wondering how it would be possible to work around this at the final calculation field level. Meaning that:
- @All of arrays will be pulled
- These would be filtered to exclude items with missing values in all arrays
- ...which would be turned into new “clean” arrays
- which could then be used safely
This or being able to turn missing values into null or something, but at the final calculation level (not source apps).
Any workaround to this?
Please sign in to leave a comment.