Unique number check in a column possible?

Ask for Help from Community
1

Hi and greetings from the Netherlands.

In my Glide table i have a column witch hold an sku number. That sku number has to be unique and in a fixed format of 7 digits. This 7-digit code is not sequential or otherwise arranged and is manually implemented. For example: 2308001 and then it’s not necessarily or likely that the next code will be 2308002. It’s random made up by the user and it should stay that way.

Now when entering a new sku code (a new row in that glide table) I want to check whether it already exists. Anyone have suggestions or ideas?

Thank you for your suggestions in advance!
Ronald Klop

2

Create a relation column from the code column back to itself. If it found a match, then the cell won’t be empty and you can use that for filtering or visibility conditions

1 Like
3

Thank you Robert,

That was the solution!
Great!

Regards, Ronald

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.