Question
with multiple pre-populated fields: college ID, First Name, Last Name, and GPA. There is a need to have the students fill out additional fields that
with multiple pre-populated fields: college ID, First Name, Last Name, and GPA. There is a need to have the students fill out additional fields that will be appended to this sheet (call them Q1, Q2, and Q3). You need to devise and implement a solution (using Google Sheets, Google Scripts,and Google Forms) that allows a student to search the sheet using his/her college Id (first field in the sheet), see his/her record, and then fill in the needed information (Q1, Q2, and Q3) if his /her information are in the sheet. If the student's college ID is not in the sheet, the student should be able to add his information (all the fields), and a mark should be added to the sheet indicating that this record was manually added by the student. After entering the additional information Q1, Q2, and Q3 the student should be able to see his whole record (including the newly added fields) but should not be able to edit it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started