Insert Data Validation using Google Apps Script
12,267
An Apps Script API for data validation was just released: http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html
Related references:
- Drop-down validation list created dynamically (google apps script)
- https://code.google.com/p/google-apps-script-issues/issues/detail?id=2958
- https://code.google.com/p/google-apps-script-issues/issues/detail?id=219
Related videos on Youtube
51 : 01
Automated Data Entry Form in Google Sheets & Apps Script - Part 1 (User Form Design & Transfer Code)
23 : 38
Form Validation HTML5 + JavaScript + RegEx - Google Apps Script Web App Tutorial - Part 10
09 : 08
Data Validation - Apps Script Crash Course
31 : 47
How to modify a datavalidation box with Google Apps Script
05 : 44
Google Script - Create Data Validation on Drop Down List on Google Sheets
Author by
Frank Montemorano
Updated on September 15, 2022Comments
-
Frank Montemorano over 1 year
I'm trying to insert an in cell dropdown menu (Data > Validation > List of Items) in a Gsheet using Google Apps Script. I want to do this because every time I use the spreadsheet the 'list of items' will change slightly and I don't wanna have to go to "Data > Validation > List of Items" every time I open the spreadsheet.
I'm aware that "Data > Validation > List from a Range" exists but I'd rather not use it.