googleapp script
Budget: ₹600 – ₹1,500 INR
Hello,
You need to write a Google Apps Script to implement the following in a new Google Spreadsheet. Google Apps Script is simply JavaScript that runs on Google's servers and is used to add features to Google Spreadsheets/Docs and other products.
1. Add a custom Menu: JS Tigers
2. Add following sub-menus under JS Tigers:
a) Create: Add a new sheet name Students with data given below. If the sheet already exists, display a message: "Students" sheet already exists.
b) Read: Copy data in "Students" sheet to a new sheet "Next Class". Create a "Next Class" sheet if it does not exist. Ignore students which already exist in the "Next Class" sheet.
c) Update: Update Age for each Student in "Next Class" by +1. If Updated Age > 17, Update Score to 0.
d) Delete: Delete Students in "Next Class" with Age > 17. Remove the row from Sheet.
You need to write a Google Apps Script to implement the following in a new Google Spreadsheet. Google Apps Script is simply JavaScript that runs on Google's servers and is used to add features to Google Spreadsheets/Docs and other products.
1. Add a custom Menu: JS Tigers
2. Add following sub-menus under JS Tigers:
a) Create: Add a new sheet name Students with data given below. If the sheet already exists, display a message: "Students" sheet already exists.
b) Read: Copy data in "Students" sheet to a new sheet "Next Class". Create a "Next Class" sheet if it does not exist. Ignore students which already exist in the "Next Class" sheet.
c) Update: Update Age for each Student in "Next Class" by +1. If Updated Age > 17, Update Score to 0.
d) Delete: Delete Students in "Next Class" with Age > 17. Remove the row from Sheet.