if you want to allow the input as 21-xxxx then you can use ^21-\d{4}$ ^: Asserts the start of the string. 21-: Matches the literal characters "21-" at the beginning. \d{4}: Matches exactly four digits (0-9). $: Asserts the end of the string

We need to check the possibility using app script

Thank you for your feedback

Hello there! Thank you for reaching out. It's great to hear that you're interested in using regular expressions for Netherlands postal codes. To better assist you, could you kindly provide a few more examples of the postal codes you're dealing with? This will help ensure that we tailor the regex pattern accurately to the specific format. Regarding the 'EU' part at the end of the postal code, is this consistent for all postal codes? Additionally, can we expect postal codes to start with a '0'? Are they always comprised of exactly 4 digits followed by a space and then 'EU'? Based on my initial understanding, here are a few examples: 1234 EU 0298 EU 9999 EU 9890 EU If these examples hold true for the postal codes you're working with, a potential regex pattern could be: "^[0-9]{4} EU$". This pattern ensures that there are exactly four digits at the beginning, followed by a space and then 'EU', with nothing else before or after. Note: don't consider the " in above regex. However, for a more precise regex pattern, it would be helpful to have additional examples or information. Feel free to provide more details so that I can assist you in crafting the most accurate regex pattern for your needs.

Thank you for your interest. Postal codes here do not start with a 0. I just learned this now. Sorry for not stating that. Postal codes consist of 4 numbers, a space and two capital letters. Example Postal Code formats: 9999 XZ 1000 QK 7859 WA

then try this ^[1-9][0-9]{3} [A-Z]{2}$@@Ronaldo72582

From chatgpt regular expression max length is 2048 characters. I e around 200 phone numbers. But we need to refer googl forms official documentation to check latest updates

Not yet, but will work on it using Appscript

@@poornavangara3014, thank you! When you have any such solution, please update here on youtube!

Absolutely, we can add a country code pattern to the phone number validation in Google Forms. However, it's important to consider that different countries have varying phone number lengths and formats. To ensure accurate validation, it's advisable to first ask the user to select their country from a dropdown or list. This way, we can then validate the phone number based on the specific format and length requirements for that country. By incorporating the country selection step, we can provide a more robust and tailored validation process. Thank you for raising this point!

@@poornavangara3014 thanks but its still nit clear hoe to add. I am creating a registration form, so there is nationality, country if residence etx but i m stuck at adding mobile nbr with country code. Pls share exact way to do it 🙏🙏

@@monalimitra3712 Step1: add a field which is list of countries you need Step2: based on selected country add a new phone number field (categorise the countries based on phone number size.. example all countries having 10 digit phone number as one group and for all the countries in this group have one specific phone number field and same way for other groups)

Thank you so much ....let me know any other doubts and do subscribe to my channel

Yes, you are correct. Unfortunately, Google Forms does not have a built-in feature that automatically converts lowercase text to uppercase. We need to check with Google app script to achieve this. I will update on this if I found any info.

One simple Appscript we can use is to convert lowercase responses to uppercase in the response sheet. This means that regardless of how the user enters the text in the form, they will see their input exactly as they typed it. However, in the background, we are converting all the text to capital letters. To achieve real-time character conversion or formatting as the user is typing, you would need a more interactive platform or custom web development. Google Forms alone does not offer this functionality.

@@poornavangara3014 Thanks for your perspective on this.

Please give the regex used ..I will try once

Yes

I am looking for a solution using app script to handle more number of phone numbers..will update if I find any

3,7,15,11 are adjacent to each other If you still have doubt WhatsApp me on 9573393994

My pleasure!

Thank you too!

Great to hear!