OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Google Apps Script: Display data on a dropdown list based on a certain cell

  • Thread starter Thread starter cjvdg
  • Start date Start date


I'm trying to generate a Student Number dropdown list depending on the value of a specific cell, which is a Grade and Section dropdown list. However, I am unsure how to begin.

enter image description here

I used a support data sheet to display the entire Grade and Section list in the dropdown menu. I also have multiple sheets based on the grade and section (7 - One, 7 - Two, 7 - Three) which contain all of the student information for each grade and unit.

enter image description here

Is there a way for me to display all student numbers according to their grade and section?

Here's the sample spreadsheet: LINK

Continue reading...

Latest posts