In this video, I demonstrate how to create a dependent drop down in a google web app using Google Apps Script on Google Sheets.
Apps Script Code (Code.gs) can be found at:
https://github.com/codewithcurt/GoogleAppsScript/blob/7995d7fb8ab064cab80a1ec3a5f1bac171628c73/Dependent%20Drop%20Down%20on%20Google%20Web%20App%20-%20Apps%20Script
HTML Code (DependentSelect.html) can be found at:
https://github.com/codewithcurt/GoogleAppsScript/blob/7995d7fb8ab064cab80a1ec3a5f1bac171628c73/Dependent%20Drop%20Down%20on%20Google%20Web%20App%20-%20HTML
Legacy Apps Script Editor Used in Video
Apps Script (Script Editor) is now located under tab ‘Extensions’ instead of ‘Tools’ on Google Sheets