Hi there,
I’d like to do a rollup on a lookup from a linked field so it only displays records that appear once (not each instance. I’d like to find something like ARRAYUNIQUE(values) in Airtable.
Is there a way to achieve that to prevent ugly columns like these?
Thx for your help 
Hey @gabrielle, unfortunately, it’s not currently possible. However, your suggestion to add ARRAYUNIQUE(values) to Baserow is a great idea. I’ve changed the category of your post to ‘Feature Ideas’ and will discuss this request with the team. 
Hello @gabrielle, we are going to add this function: ARRAYUNIQUE(values) function as formula function (#2232) · Issues · Baserow / baserow · GitLab. Thank you for bringing it to our attention. 
Awesome & looking forward! Will you add the other functions available in Airtable but not in Baserow for the Rollup field?
We have plans to add more functions to Baserow. Which ones do you find particularly useful?
Sorry for the late reply! I’d say all these:
AND
AVERAGE
COUNT
COUNTA
COUNTALL
MAX
MIN
CONCATENATE
ARRAYJOIN
ARRAYUNIQUE
ARRAYCOMPACT
ARRAYSLICE
OR
XOR
But most importantly, they should work on linked fields and lookup fields to be truly useful. Right now, I am quite limited in my use of the roll up function because of that. There are a number of things I can do easily in Airtable that don’t seem to wok in Baserow unfortunately.
Hi @olgatrykush,
Do you have an estimated ETA for these roll up functions?
Thank you
Hey @gabrielle, apologies for missing your previous message. I’ll discuss the list you shared with the team.
Ditto the above - this is the last missing feature within a database table that I need to transition completely from Airtable.
Hey @gabrielle, we’ve checked the request, and here’s an update.
These three functions are already available in the roll-up field:
As for the rest, we’ve raised the priority of the arrayunique function, so it should be implemented pretty soon. As for the others, we already have formula functions:
This means you can use them to get the info you need via the formula field type as a workaround until we have these functions directly available with the roll up field.
To sum up, your feature request has been accepted. We will add all the missing functions, but they are a low priority, except for the arrayunique function. It will be added soon. 
Hi @olgatrykush, do you have an ETA on the roll-up functions we discussed?
Many thanks
Hey @gabrielle, we can’t provide any ETAs until the feature is started. You can track the progress here: More functions for the rollup field type (#2669) · Issues · Baserow / baserow · GitLab
I’d like to cast my vote for these functions, particularly, ARRAYUNIQUE. If there was a function to extract only the first or the last element of the array, I could use it too (see also my thread).
