Form Field Validation?

lawndoctor92504

Hi,

I’m wondering if anyone has come across a similar problem and found a solution…

I’m looking for a way to validate form data so that only certain information can pass through. For example, in a text area field, I want to make sure that only numeric numbers (1,2,3,4, etc.) can pass through and text does not. In this scenario, a dropdown with only numeric options is not possible as the number range is very, very large.

To add some context, we have forms linked to Google Sheets as part of one of our tracking initiatives with our franchisees. When they don’t follow instructions and submit text instead of numbers it breaks the sync we have with our business intelligence platform.

Aside from creating default text within the field (which is ignored) and further instructions on the form itself (which is ignored) I’m not sure what other options are left.

Any and all help is appreciated.

Thanks