I need a Google Sheets, Form and Script expert
Budget: $250 – $750 USD
This is for a school project. I'm NOT looking for exact answers. I'm more so looking for tips on how can this be achieved as I have no coding/scripting knowledge. Any help would be greatly appreciated.
Students ID numbers, First name, Last name and GPA are put onto a google spreadsheet. I need students to fill out additional fields that would be put onto the spreadsheet. These can be called Field 1, Field 2 and Field 3. By using Google Script, Sheets and Forms I need the following to be achieve:
• Students should be able to search for their information by using their ID number and fill in their information for field 1,2 and 3
• If the students ID is not in the spreadsheet, then they should be able to input their information to every field and a mark/icon should be added to show the student placed the information on their own
• Once the student enters the additional information for fields 1,2 and 3. The student should be able to see their entire record (all fields) without being able to edit it
Students ID numbers, First name, Last name and GPA are put onto a google spreadsheet. I need students to fill out additional fields that would be put onto the spreadsheet. These can be called Field 1, Field 2 and Field 3. By using Google Script, Sheets and Forms I need the following to be achieve:
• Students should be able to search for their information by using their ID number and fill in their information for field 1,2 and 3
• If the students ID is not in the spreadsheet, then they should be able to input their information to every field and a mark/icon should be added to show the student placed the information on their own
• Once the student enters the additional information for fields 1,2 and 3. The student should be able to see their entire record (all fields) without being able to edit it
Related categories:
Google Sheets