0

I need sharepoint online column to accept only alphabets. It should not contain any numeric or special values.

2
  • Have you checked PreSaveAction? Can you add script editor webpart?
    – Salah
    May 10, 2019 at 14:34
  • Yes, but (a)could find the save button to apply that code on to my list so i clicked on web part properties and then applied it. (b) it does not work because when i open the list, the webpart appears on top of the list with code written in it. May 10, 2019 at 16:21

1 Answer 1

0

Use SharePoint Column Validation.

Edit the column and paste below formula in Column Validation Formula. You could even write the custom error message:

=AND(IF(ISERROR(FIND("0",Title)),TRUE),IF(ISERROR(FIND("1",Title)),TRUE),IF(ISERROR(FIND("2",Title)),TRUE),IF(ISERROR(FIND("3",Title)),TRUE),IF(ISERROR(FIND("4",Title)),TRUE),IF(ISERROR(FIND("5",Title)),TRUE),IF(ISERROR(FIND("6",Title)),TRUE),IF(ISERROR(FIND("7",Title)),TRUE),IF(ISERROR(FIND("8",Title)),TRUE),IF(ISERROR(FIND("9",Title)),TRUE)
1
  • Yes, this is the exact same formula I used to make it work. May 12, 2019 at 15:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.