After animals go through the different stages of endangered, they eventually become extinct. Extinct is no longer in existence. In the beginning, many animals left the Sahara because they realized…
Welcome to my blog again. This time I’m here to teach you Google App Script
Today we will see how to write data validations & adding dynamic dropdown in excel sheet.
After clicking on Data Validation below image will come-up
Today our main focus is on second approach that is, google app script. I’m assuming while reading this blog you have prior knowledge to google app scripts.
In this blog we will use SpreadsheetApp class from google sheets. Below are the methods which will be used for reading and writing the sheets.
We will understand this class and above methods one by one.
2. openById ( fileId )
3. newDataValidation ( )
4. requireValueInList ( range, showDropDown)
5. setDataValidation ( rule )
Below is the example code snippet that will access a sheet and will create a dropdown in Sheet1 using Sheet2
I hope you enjoyed my blog. I would love to hear from you. Do comment, share & don’t forget to clap !!!
Five days before Christian Eriksen arrived at Brentford, Thomas Frank predicted he could be the club’s “greatest signing.” Frank hadn’t yet seen him train, but the Brentford manager — who coached…
The 17th Wall Street Green Summit (link is external) put that notion that CleanTech is solar and wind to shame. Investors and market makers convened to talk about water, agriculture, drones…
Come with me in the silence of darkness I want to show you secrets of life I will ___ you where dreams could’t take you She seldom flew away in the night You’re the ____ flower You’re the…