Validate a date in Google Forms
In this tip, we will try to create a validation for specific dates in Google Forms.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
Here is the RegEx used:
^0[13578]/[12][0-9]/2021$|^0[13578]/0[123456789]/2021$|^0[13578]/3[01]/2021$|^0[469]/[12][0-9]/2021$|^0[469]/0[123456789]/2021$|^0[469]/30/2021$|^02/[1][0-9]/2021$|^02/0[123456789]/2021$|^02/2[12345678]/2021$|^11/[12][0-9]/2021$|^11/0[123456789]/2021$|^11/30/2021$|^1[02]/[12][0-9]/2021$|^1[02]/0[123456789]/2021$|^1[02]/3[01]/2021$
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: https://practicalsheets.com/patreon
➤Webpage: https://practicalsheets.com
➤Newsletter: https://practicalsheets.com/newsletter
➤Telegram: https://practicalsheets.com/telegram
➤Facebook: https://practicalsheets.com/facebook
➤Twitter: https://practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Видео Validate a date in Google Forms канала Practical Sheets
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
Here is the RegEx used:
^0[13578]/[12][0-9]/2021$|^0[13578]/0[123456789]/2021$|^0[13578]/3[01]/2021$|^0[469]/[12][0-9]/2021$|^0[469]/0[123456789]/2021$|^0[469]/30/2021$|^02/[1][0-9]/2021$|^02/0[123456789]/2021$|^02/2[12345678]/2021$|^11/[12][0-9]/2021$|^11/0[123456789]/2021$|^11/30/2021$|^1[02]/[12][0-9]/2021$|^1[02]/0[123456789]/2021$|^1[02]/3[01]/2021$
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: https://practicalsheets.com/patreon
➤Webpage: https://practicalsheets.com
➤Newsletter: https://practicalsheets.com/newsletter
➤Telegram: https://practicalsheets.com/telegram
➤Facebook: https://practicalsheets.com/facebook
➤Twitter: https://practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
Видео Validate a date in Google Forms канала Practical Sheets
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
EVENT GENERATOR in Google Sheets 📅 - Part 3 - Edit and delete eventsConnect different Google Sheets files, and choose any column with IMPORTRANGEQUERY Course for Google SHEETS - Lesson 2 - Filtering with WHEREHow to order a table automatically in Google SheetsCurrency Converter in Google SheetsQUERY Course for Google SHEETS - Lesson 1 - Introduction and SELECTSend email from Google FormsQUERY for Google Sheets - Complete Course - Part 4 - LIMIT, AND OFFSETDinamically merge 2 tables from different Files in 1, with Google Sheets (NO CODE)Journal Entries App with AppSheet - Introduction to AppSheetGenerate automatic Serial number with Google SHEETS and Google APPS SCRIPT - Optimizing the scriptEnhance Google Sheets's QUERY function with Google Apps ScriptCreate Recurring Calendar Events from Google SheetsAdvanced Alerts in Google Sheets: Customizable Pop-upsHelp Desk System in Google Sheets, Forms and Google Apps Scripts - Part 3: Send initial emailMAIL MERGE SYSTEM with Google Sheets 📧 - Part 1 - Send multiple emails to your contactsWorkout logger in Google Sheets - Part 3 - Easliy bring exercises grouped by categoryPersonal Finance System in Google Sheets - Part 3 - Tracking Income 💰💲Inventory System Management with Google Sheets - Part 2 - Dashboard and TablesInventory Management in Google Sheets - Start with exiting inventoryAdvanced Number Sequence by Categories in Google Sheets