Forum Discussion

codingpebble

Copper Contributor

Dec 22, 2023

Unique Integer Colum in Sharepoint List

Hello,

how can I get a column in a sharepoint List which is basically an editable ID.

I tried using the number type and set the decimal to 0 and made it unique.

That works if users only enter whole numbers.

However if someone decides to enter for instance 1.1 and another item with 1 already exists then it creates a new item showing 2 items with the value 1 in that field which should be unique.

Any ideas?

Best regards

Lists

SharePoint Online

codingpebble
Dec 22, 2023
I solved this using validation:
=IF([Number Column] = ROUND([Number Column], 0), true, false)

codingpebble
Copper Contributor
Dec 22, 2023
I solved this using validation:
=IF([Number Column] = ROUND([Number Column], 0), true, false)
DaveMehr365
MVP
Dec 22, 2023
Hello codingpebble

with this settings it's only possible to add whole numbers:

I have it not tested, but maybe it's also possible with column validation:

https://support.microsoft.com/en-au/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?WT.mc_id=DX-MVP-5004845

Best, Dave
- codingpebble
  Copper Contributor
  Dec 22, 2023
  DaveMehr365
  
  I think Im using the exact same settings.
  However Im still able to add the same number in the column Fahrzeug.
  You can add 1 then add 1.1 which is also displayed as 1
  and 1.11 and so on