
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 04, 2018 09:52 AM
I have 2 rollup fields in a table that are formatted to show ARRAYUNIQUE(values). I am trying to create a formula column that combines these values in an array, and only displays unique values. I was trying to use: ARRAYUNIQUE({Rollup1},{Rollup2}), but am only getting the values from Rollup1 to show up. Help?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 21, 2022 09:41 PM
Hi Colby, roger that. I've updated the base's automation and extension to handle the case where Array#1 or Array#2 is empty I believe. Lemme know if you hit any issues
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 24, 2022 07:51 AM
That worked, thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 04:07 AM - edited ‎Jan 30, 2025 04:07 AM
The script issue doesn't fix the problem unfortunately because when using Airtable via the Interface, I need the ARRAYUNIQUE value to appear automatically in a visible box in my interface. Also, taking up an automation count (which are already quite limited) is not a good workaround for something as simple as finding unique values via a formula field.
Did anyone else find a workaround using the formula field? crazy that after all this time this error is still persistent...
I have three Rollups that show the ARRAYUNIQUE(value) of a URL field in three different tables. Once these three Rollup fiels are visible in my Parent Table, I then want to only show the Unique URLs from those three rollups. To this day, I have unfortunately still not found a non 'automation script' solution.
Any help would be much appreciated.
Alex

- « Previous
- Next »