# Rollup unique linked fields?
**URL:** https://community.baserow.io/t/rollup-unique-linked-fields/3806
**Category:** Feature Ideas
**Created:** [November 21, 2023, 4:53pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806 "2023-11-21T16:53:04Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@gabrielle](https://community.baserow.io/u/gabrielle)
#### Post date: [November 21, 2023, 4:53pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/1 "2023-11-21T16:53:04Z")
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 🙂
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [November 27, 2023, 7:09pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/2 "2023-11-27T19:09:52Z")
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](https://community.baserow.io/c/feature-ideas/9)’ and will discuss this request with the team. 👌
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [January 10, 2024, 11:07am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/3 "2024-01-10T11:07:12Z")
Hello @gabrielle, we are going to add this function: [ARRAYUNIQUE(values) function as formula function (#2232) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/2232). Thank you for bringing it to our attention. 🙏
---
### Author:  [@gabrielle](https://community.baserow.io/u/gabrielle)
#### Post date: [January 10, 2024, 11:33am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/4 "2024-01-10T11:33:17Z")
Awesome & looking forward! Will you add the other functions available in Airtable but not in Baserow for the Rollup field?
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [January 10, 2024, 11:39am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/5 "2024-01-10T11:39:47Z")
We have plans to add more functions to Baserow. Which ones do you find particularly useful?
---
### Author:  [@gabrielle](https://community.baserow.io/u/gabrielle)
#### Post date: [March 14, 2024, 10:02am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/6 "2024-03-14T10:02:21Z")
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.
---
### Author:  [@gabrielle](https://community.baserow.io/u/gabrielle)
#### Post date: [April 2, 2024, 2:02pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/7 "2024-04-02T14:02:14Z")
Hi @olgatrykush,
Do you have an estimated ETA for these roll up functions?
Thank you 🙂
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [April 2, 2024, 3:04pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/8 "2024-04-02T15:04:37Z")
Hey @gabrielle, apologies for missing your previous message. I’ll discuss the list you shared with the team. 👌
---
### Author:  [@clintribble](https://community.baserow.io/u/clintribble)
#### Post date: [April 15, 2024, 12:58pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/9 "2024-04-15T12:58:05Z")
Ditto the above - this is the last missing feature within a database table that I need to transition completely from Airtable.
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [May 2, 2024, 12:02pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/10 "2024-05-02T12:02:54Z")
Hey @gabrielle, we’ve checked the request, and here’s an update.
These three functions are already available in the roll-up field:
- max
- min
- average
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:
- count
- concat
- and
- or
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. 🙂
---
### Author:  [@gabrielle](https://community.baserow.io/u/gabrielle)
#### Post date: [September 9, 2024, 10:17am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/11 "2024-09-09T10:17:07Z")
Hi @olgatrykush, do you have an ETA on the roll-up functions we discussed?
Many thanks 🙂
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [September 9, 2024, 11:41am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/12 "2024-09-09T11:41:55Z")
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](https://gitlab.com/baserow/baserow/-/issues/2669)
---
### Author:  [@Dae](https://community.baserow.io/u/Dae)
#### Post date: [September 17, 2024, 1:18pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/13 "2024-09-17T13:18:49Z")
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](https://community.baserow.io/t/get-the-first-or-the-last-element-from-lookup/6106)).
---
### Author:  [@christos](https://community.baserow.io/u/christos)
#### Post date: [February 8, 2025, 7:33am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/14 "2025-02-08T07:33:49Z")
Also voting for this. I believe **ARRAYUNIQUE** is quite popular formula that unfortunately limits Baserow at the moment. I noticed there is no traction in this topic. Has it lost priority or still working on it?
---
### Author:  [@Yam](https://community.baserow.io/u/Yam)
#### Post date: [February 10, 2025, 10:15am UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/15 "2025-02-10T10:15:08Z")
Also adding my vote especially for **ARRAYUNIQUE**.
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [February 10, 2025, 4:11pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/16 "2025-02-10T16:11:27Z")
Thank you for your input @Yam, @christos, and @Dae. The `ARRAYUNIQUE` function is on our list. 🙂
---
### Author:  [@Yam](https://community.baserow.io/u/Yam)
#### Post date: [February 16, 2025, 3:48pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/17 "2025-02-16T15:48:58Z")
I would also love a `SORT` function for arrays. For example, I have a lookup function that can return multiple values which are prefixed by date e.g. `2024-01-03 : Event A`, `2025-02-12 : Event B`, etc, but the returned array will always be sorted by linked table record id - which is not necessarily the same as chronological order. I’d like to be able to apply lexicographic order here, so that they appear by increasing/decreasing dates.
So for example: `sort(lookup('Event', 'Instances'), 'A-Z')` or likewise.
(it would also be great to have the ability to similarly be able to sort links to table as well, again to override the default sorting order by record ID)
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [February 17, 2025, 2:31pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/18 "2025-02-17T14:31:54Z")
Got you @Yam. I’ll discuss this request with the team. 🙌
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [February 19, 2025, 3:27pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/19 "2025-02-19T15:27:08Z")
Hey @Yam, this request is accepted too. We’ll start with adding the SORT function to the formulas, and we’re also considering adding sorting for Lookup/Rollup fields themselves, similar to Airtable. What do you think?
---
### Author:  [@Yam](https://community.baserow.io/u/Yam)
#### Post date: [February 20, 2025, 2:27pm UTC](https://community.baserow.io/t/rollup-unique-linked-fields/3806/20 "2025-02-20T14:27:04Z")
Thanks for your reply. I’ve mostly switched to using the `lookup` or rollup functions directly rather than the native lookup/rollup fields themselves, as they provide the same functionality with extra flexibility. So I’d be happy with having `sort` as a function for formulae. At least for my personal use cases, it’s unlikely I’d need it for the native fields.
[Next page](https://community.baserow.io/t/rollup-unique-linked-fields/3806.md?page=2)