Enforce the Submission Form to accept a decimal number with x.xxx format.

[Azriel]

Hello,

Please help me, I have a submission form with a field that accepts value from 0.000 to 9.999.

I want to implement a validation that will prompt an error message, and will prevent the submission if the from x.xxx (ex:1.000, 3.321, etc..) is not followed.

Please help me, I have no Idea how to implement such validation.

Thank you in advance.

[TsiBiRu]

Hi  @Azriel,

I have a similar validation with my app, I've just edited it a bit so that it will meet your requirements. You can just add a header and footer in your submission form, then paste the code below in the footer section.  

<script type="text/javascript">
document.addEventListener('BeforeFormSubmit', function (event) {
event.preventDefault();

//Just change the 'InsertRecordNumber_' in the code below

var x = document.forms["caspioform"]["InsertRecordNumber_"].value;
  var regexp = /^\d+\.\d{3}$/;
  if (!regexp.test(x)) {
    alert("The correct GPA format should be x.xxx");
    return false;
  }

else
 {
document.getElementById("caspioform").submit();
 }


});
</script>

The only thing that you need to update in the code above is the actual ID of your field where you want to enforce this validation (Just replace the 'InsertRecordNumber_' in the code above)

To get the ID of the field that you want to apply this validation, you can simply preview your DataPage or access the web page it is deployed and follow the instruction on this Link  to get the ID of your field.

I hope this helps.

Regards,

TsiBiRu

[futurist]

Just to add, if you also wish to validate value entered in an input field to make sure that it follows this format: www.websitename.com

Then you can use this code:

 

<script type="text/javascript">

document.addEventListener('BeforeFormSubmit', function(event) {

var inputField = document.querySelector('#InsertRecordNameofField');

  const value = inputField.value;
  const regex = /^www\.[a-zA-Z0-9-]+\.[a-zA-Z]{2,}$/;

if (!regex.test(value)) {
event.preventDefault();
alert('Invalid Submission!');

} else {

document.form["caspioform"].submit();

}

});
</script>

Make sure to replace "NameofField" with the actual name of the field that you want to validate before submitting.