# Data Entry format check? **URL:** \ **Category:** Ask for Help\ **Created:** [April 2, 2020, 10:42am UTC](https://community.glideapps.com/t/data-entry-format-check/6291 "2020-04-02T10:42:02Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jean-Philippe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jean-philippe/32/4757_2.png) [@Jean-Philippe](https://community.glideapps.com/u/Jean-Philippe)\ **Post date:** [April 2, 2020, 10:42am UTC](https://community.glideapps.com/t/data-entry-format-check/6291/1 "2020-04-02T10:42:02Z")
Is there any possibility to check data Entry format, such as Email (containing “@”, …) or Numbers\_123 (only positive numbers or numbers of digits for tel) ? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [April 2, 2020, 10:53am UTC](https://community.glideapps.com/t/data-entry-format-check/6291/2 "2020-04-02T10:53:38Z")
For email, use an Email entry field. For numbers, use number entry. Formatting can now be handled in the Glide editor I believe. ---
**Author:** ![Jean-Philippe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jean-philippe/32/4757_2.png) [@Jean-Philippe](https://community.glideapps.com/u/Jean-Philippe)\ **Post date:** [April 2, 2020, 8:18pm UTC](https://community.glideapps.com/t/data-entry-format-check/6291/3 "2020-04-02T20:18:03Z")
Humm, for email I can enter what I want, “blabla” for instance, without any format checking. Same for Numbers, “-1,4” for instance, without any range checking as postive numbers only. I didn’t find any flilters or formatting option that could answer my needs. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 5, 2020, 7:32pm UTC](https://community.glideapps.com/t/data-entry-format-check/6291/4 "2020-04-05T19:32:06Z")
There isn’t any good data validation other than the very limited version that @kyleheney indicated. The different entry fields mostly determine which keyboard to show to the users. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 5, 2020, 11:18pm UTC](https://community.glideapps.com/t/data-entry-format-check/6291/5 "2020-04-05T23:18:34Z")
Right. I can’t wait for some more sophisticated (regex?!) forms of data validation. Could lead to some nice quizzing/ digital breakout room type apps among other things. ---
**Author:** ![Jean-Philippe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jean-philippe/32/4757_2.png) [@Jean-Philippe](https://community.glideapps.com/u/Jean-Philippe)\ **Post date:** [April 8, 2020, 1:23pm UTC](https://community.glideapps.com/t/data-entry-format-check/6291/6 "2020-04-08T13:23:10Z")
Humm I 'm not sure to understand your answers, I need to adjust following data type formats: - Date & Time =\> ok it works with Gsheets format option - Email =\> I didn’t find such format option in Gsheets, as well as in Glide Data even when selecting Email entry !! Problem is that user can enter any character strings as Email value, example “-6,5gh[y42)”, How to reject such invalid entry ? and accept at least “alphabet characters, numbers and special characters “. and @” or at least entry containing “@” ? - Quantity (I want to to be always \>= 0 and fractional, eg “5,6”) =\> I didn’t find such format option in Gsheets, options in Glide Data (type is “123 Number Entry”), are limited to “Precision”, “1000 separator” and “Units” (visible or not), means user may enter negative numbers as Quantity to be ordered, so how to reject such entry ? - Tel Number (digits) =\> I didn’t find such format option in Gsheets, option in Glide Data is limited to “numeric pad” values (type is “123 Number Entry”), means user may enter “-123,456” as Tel numbery, so how to reject such entry ? and accept at least “positive non fractional” number (x digits”) ? ---
**Author:** ![Mrinal\_Chakraborty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mrinal_chakraborty/32/5239_2.png) [@Mrinal\_Chakraborty](https://community.glideapps.com/u/Mrinal_Chakraborty)\ **Post date:** [April 9, 2020, 9:16am UTC](https://community.glideapps.com/t/data-entry-format-check/6291/7 "2020-04-09T09:16:36Z")
@Mark can you please help ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [April 9, 2020, 11:11am UTC](https://community.glideapps.com/t/data-entry-format-check/6291/8 "2020-04-09T11:11:44Z")
There is no way to do that kind of validations in Glide @Jean-Philippe ( except Date/Time). I have done this but using native Google forms, they have an option where you can build your own schema, very powerfull. A feature that could be copied by Glide I think. This could be your workaround but doesn’t look like elegant Saludos Gavp