Ok, this is a stupid question. I know what a ...

(Joseph Pentheroudakis) #1

Ok, this is a stupid question. I know what a key is in a table, and the documentation confirms what I know, but for the life of me I can’t figure out what I need to get an actual key assigned. I created a column that I flagged as Key under Data > Columns > Show Properties for my table, picked Number as the data type, but what do I need to do to have the system assign a value to that column for each row?

(Bellave Jayaram) #2

Easiest is to make the column data type Text and put UNIQUEID() in the Initial Value. You can also use DateTime data type and put NOW() in Initial Value.

(Joseph Pentheroudakis) #3

@Bellave_Jayaram thank you! Worked like a charm.