Key column

[Denis_Dal_Soler]

Hi, someone can tell me please why the system doesn't allow me to set a specific column as key? When I save the system change automatically my select and fix "_RowNumber" as ref. Thanks.

[Koichi_Tsuji]

There are few possible reasons.

- You may have spreadsheet formula

- You may set the key column type to Longtext

and so on.

[Denis_Dal_Soler]

Dear @Koichi_Tsuji  thanks for your time. In the screenshot you can view the column key I want (in red circle) and vice versa  the key the system impose to me and the  warning  sentence it write after.  "Progressivo richiesta" is a number unambigous.

[1minManager]

you can only choose one key column and it has to be required with an initial value formula such as UniqueID()

Simon@1minManager.com

[Denis_Dal_Soler]

Sorry @1minManager  and @Koichi_Tsuji , effectively the column has a spreadsheet formula becuse it's an incremental value  and I think it's impossible to have an incremental field as key.

[1minManager]

You're probably correct.  Try using that spreadsheet formula as the inital value and remove it from the spreadsheet

[Koichi_Tsuji · Accepted solution]

When the column does have spreadsheet formula, then it is banned to be key column, that was the reason on your case.