
dk82734

7 - App Architect
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โApr 13, 2023
11:40 AM
Status:
New Ideas
I have spent too many hours working around problems like:
- Converting comma-separated strings to unique elements in an array/set
- SORTING elements in arrays/sets properly
- Comparing to different arrays/sets in order to determine intersection/difference
NONE of the built-in Airtable formulas support these use-cases right now. Could we PLEASE get new Formula functions like:
- ARRAYINTERSECT(arr1, arr2, ...) - outputs the subset of values in each array that are uniquely present across all input arrays
- ARRAYDIFF(arr1, arr2) - outputs the subset of unique values that are in arr1 but NOT in arr2
- ARRAYSORT(arr1, sort_type) - sorts the values in the array by specific sort type (e.g., alphanumeric ascending/descending, chronological ascending/descending, integer ascending/descending)
- ARRAYINSET(arr1, value) - returns TRUE() if value is present in arr1, FALSE() otherwise
See more ideas labeled with:
1 Comment