This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Set Theory functions for Arrays

Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.