The column Title
has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal.
I've tried with =ISNUMBER(PurchaseQty+0)
but I still can key in negative value and decimal.
From
https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List
so that makes:
=IF( SIGN( [PurchaseQty] ) >-1 , TRUE , FALSE )
or the same:
= SIGN( [PurchaseQty] ) >-1
Note: SharePoint does type conversions for you,
so [PurchaseQty]
can be a Text Column,
but if it does not contain a number representation you get a #Value
error
entered value===integer value?
.. Yes.. you would have to scan that whole list of functions and read what they do. If I present you the solution, you learn nothing today.
Dec 18, 2015 at 9:16
INT(PurchaseQty)=PurchaseQty
Dec 21, 2015 at 9:30
=IF(SIGN(TRUNC(PurchaseQty))>-1,TRUE,FALSE)
@DannyEngelman
You have to apply jslink on List "Title" Field and using JQUERY You can check the number is integer or not.
$(document).ready(function () {
//called when key is pressed in textbox
$("#quantity").keypress(function (e) {
//if the letter is not digit then display error and don't type anything
if (e.which != 8 && e.which != 0 && (e.which < 48 || e.which > 57)) {
//display error message
$("#errmsg").html("Digits Only").show().fadeOut("slow");
return false;
}
});
});