Deduplicating names in a text array

I don't think you can do this with formulas alone I'm afraid.  As a workaround, you could try:
1. Create a new table and link it to your table
2. Select the "Intervenants" cell and copy the text
3. Paste the copied text into the linked field to the new table

This will give you the unique list of names, and you could create an automation to help you handle this too

@nicolasguerin 

Did you check out this thread on solving this issue? The trick is that your rollup field should point to a lookup field, not any other type of field.

Otherwise, if that doesn’t work, you can always write a custom JavaScript or use Make’s automations for Airtable to solve this.

I don’t know JavaScript, so I always use Make for things like this.

Make offers dozens of string & array functions, including “split” and “deduplicate”, so you can easily take any string of comma-separated text and quickly remove all the duplicates.

You can also generate your documents & certificates using Make as well.

p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

Hello @ScottWorld  and thanks for your reply. I looked at the thread and couldn't find a useful answer. I could indeed use Make to get the names and use it to generate my certificates (or use a formula to split the "name array" before calling it into my students table). But i can't figure why isn't there a more intuitive solution within Airtable.

Yeah, Airtable has a limited set of tools for working with arrays. Did you make sure that your rollup field was pointing to a lookup field? That's the only solution that has worked for others in the past. Otherwise, I would recommend turning to either scripting or Make.

It's frustrating to handle Array.

Airtable needs to support this with ARRAYUNIQUE(ARRAYFLATTEN(values)).
ARRAYFLATTEN function is not working.