UNIQUE function in Glide

Ask for Help
1

Hi

Any know ways to achive a table with UNIQUE from an array?

Im guessing API could solve it, but would be quite troublesome.
DATA TABLE
UNIQUE TABLE
Create “unique array” from DATA TABLE. Delete all rows in UNIQUE TABLE Create new rows in UNIQUE TABLE via API with values from “unique array”.
But this would delete all manually added in UNIQUE TABLE.

What im looking for
x

//Danny

2

Creating a unique array is quite simple, and requires two columns:

  • Create a Lookup column that targets your Data column
  • Use a Unique Elements column that targets the Lookup column

If you then need to expand the array into a list that spans multiple rows, you will need some extra columns:

  • Add a RowIndex column to number your rows from 0-N. You can either do that manually, or use the second method described here.
  • Add a Single Value column. It should target your Unique Elements column, taking N from start, where N is your RowIndex column.
2 Likes