Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Unique array combining arrays from 2 rollup fields

100 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kat_Levine
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

22 Replies 22

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

That worked, thank you!

EaZyGreen
5 - Automation Enthusiast
5 - Automation Enthusiast

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