It would be useful to have more features related to the use of sets in arrays.
Airtable has the ability to create an array and create rollups from those arrays, but doesn’t have any formula functions to manipulate 1 or more arrays. Being able to use set theory type functions would allow better application building than group and sort.
Set Theory Functions:
For two sets (arrays) A and B,
- Values present in either of the arrays A or B.
- Values present in both the arrays A and B.
- Values present in A, but not B, or in B, but not A.
