Filter out duplicates in dropdown menu

[Jane]

Hello,

Is there any way to filter out duplicates in a dropdown menu?

The dropdown menu list:

The column of the table it is coming from:

Best,
Jane

[TomAprea]

The First question to ask is : why have you 2 inputs of “l’alimentation”?

Is it appropriate ? Maybe you should work with a NEW collection in which you can choose a list of these values Tcc, l’alimentation, … and create a link between this new collection and your current collection.

[FR] La première question est : pourquoi as-tu 2 fois le même enregistrement ? Est ce que c’est pertinent ? Peut-être que tu devrais créer une nouvelle collection avec les différents valeurs souhaitées (la tcc, l’alimentation et d’autres), que tu relis à ta 1ere collection.

[Jane]

Thanks for your answer @TomAprea ! That is what I did in the end → one collection with the list of “axis” (alimentation, TCC …) and another linked collection with the levels available for each axis (1, 2, 3…), instead of having just one collection with a column axis, and a column level