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.
Pretty easy and straighforward task for me. I have made such scripts earlier and can do this for you as well.
I am ready to start immediately. Can add the custom menu options using appscript which can perform the actions mentioned in the task description.
₹1,300 INR in 1 day
5.0 (10 reviews)
3.5
3.5
2 freelancers are bidding on average ₹1,175 INR for this job