Regex Data Validation Needed

Hi @Mark,

It seems as though every app I’m creating nowadays is in dire need of data validation for forms. Is there ANY way we can have such a feature? Whether it’s regex or a set of common data validation checks (eg. is a 10-digit phone number, has 5 characters, is a number greater than 10).

Thanks for the consideration.

5 Likes

Could you give a bunch more concrete examples, please?

Sure!

  • Text; “State” column has two characters.
  • Number; Zip code is a 5 digit number only
  • Text: Email address is formatted like x@y.z
  • Text; URL contains https://a.b
  • Text: Full Name contains 2 words
  • Number: Price cannot be negative
  • Date: End Date >= Start Date or Today

Need more?

5 Likes

+1 . Some of these are US standards. Please @Mark do it global or customizable in case it is done. Thanks

Right. They are…so RegEx would allow us to define the data validation parameters.

4 Likes

A few issues/questions:

  • Why don’t you use an Email Entry for the email?
  • You couldn’t express “End Date >= Start Date” in a regex.
  • As a start, what if you could attach necessary conditions to add/edit/form screens, such as “Price > 0” and “End Date is later than Start Date”?
1 Like

Yes! The third bullet point is clutch. And for text/number fields: number of characters/digits?

Makes sense. “Number of digits” is a bit weird. For numbers you usually want a high and a low limit, whereas for codes, like ZIP codes or state codes, you want an exact number of letters/digits/whatever, or maybe also a min/max number of symbols.

3 Likes

That works for me!

It would be best if we can have the similar feature which Google Form has e.g. some inbuilt data validation plus also custom field to enter custom regex.

1 Like

Just picking up on this thread and some of @Mark comments. I have a great potential customer who I can move from an old .NET solution to Glide very easily, except for one thing. The current solution captures data from users but requires field validation. It kills me that I can’t help them without some fairly basic validation, so just wondering if there were any plans in the pipeline?

@V88_Google What specific validations do you need?

I would like the following:

  • ability to restrict a negative number
  • ability to set maximum or minimum number counts
  • ability when selecting date to be today or future dates (not previous dates that have passed)
  • zip codes
  • phone numbers
  • time masking inputs (not date just time)
  • ability to prevent “letters” from being entered into “number” fields

HI @Mark thanks for the reply, for this specific customer we would need:

At a minimum:

  • Range for integer number (min - max)
  • Range for decimal number (min - max)
  • Date (future only)

Would be nice:

  • Postal code
  • Phone number
  • Specific format fior a registration number e.g. AAAA33333

It strikes me that the ability to assign a RegExe to a text entry field would probably cover all bases, although I appreciate not very user friendly if you’re not a RegEx person.

Thanks