Unique Column Value

User Talk Columns
1

Is it possible to define a column to be unique?
As one could do within SQLs DDL unique constraint.

2

Have a look at this. It works with boolen values but you could extend it to work with text values as well.
Unique default value in boolean (check box) column

3

Hey robkuz,
another possibility is to use an autonumber column and then lock the edition of this column (available only with plus or enterprise plan).

Step 1: create an auto number column
image

Step 2: edit column permissions (this requires SeaTable Plus)
image

Now you have a column with unique numbers.

4

hi,

in our case the ID is an external ID as it interfaces an external system.
So your solution wont work.

I must admit I am a bit stumped that one can neither use a unique constraint nor a required constraint on a column definition. For me this is a very important feature.

Thanks for your answer nonetheless

best regards
Robert

1 Like
5

You can add your requirement as a feature request at https://ideas.seatable.io.

6

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