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?
Charlie_Wells (Joseph Pentheroudakis) #1
Bellave_Jayaram (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.