I’m trying to make it in glide, but I can’t figure out how to make unique values from a list, any help?
As of now the only way is to do it right from the start of creating records, in my opinion.
Let’s say you have a custom “form” with an add row action, an “All Records” sheet and a “Unique” sheet. The column you want to write to the “Unique” sheet is called “Animals”, for example.
In the “Custom” form, you have a user-specific column to write the “Animal” you want to create.
Then have a relation from that user-specific column to the “Animals” column in the “All Records” sheet.
If relation is not empty => Only writes to the Animals sheet.
If relation is empty => Writes to both the “All Records” and “Unique” sheet.