Number field validation to use dot and not comma

Forums General discussion Number field validation to use dot and not comma

This topic contains 2 replies, has 2 voices, and was last updated by  Alexander Bautz 2 weeks ago.

  • Author
    Posts
  • #24048

    Maciek Grischke
    Participant

    Hi all,

    Is there a way to decline an entry in a number field with commas and to tell the user to use a full stop instead?

    SharePoint converts “14,5” to “145” and I need users to enter “14.5”.

    Many thanks.

  • #24050

    Maciek Grischke
    Participant

    I got it sorted via column validation using the following formula:

    =ISNUMBER(VALUE(TRIM(CLEAN([Column Name]))))

    but the column needs to be in a Text format, not a number format. I then use Flow to convert it back to a proper number.

    I wonder if there’s a way of using DFFS. No worries if not.

  • #24073

    Alexander Bautz
    Keymaster

    Hi,
    Add something like this to your Custom JS to replace “,” with “.”:

    jQuery("#dffs_YOUR_FIELDINTERNALNAME input").on("keyup",function(e){
        var str = jQuery(this).val();
        jQuery(this).val(str.replace(",","."));
    });

    Change “YOUR_FIELDINTERNALNAME” with your field internal name.

    Alexander

You must be logged in to reply to this topic.