Google Sheets Pupil Lookup Script -- 2
Budget: $10 – $30 USD
I have a sizeable Google Sheet containing pupils' names and their corresponding grades, each in a single row. I need a script that enables a user to input a unique pupil ID to look up their information, displaying only that specific row. The script should also include the following functionalities:
- Show a direct link to the data in the selected row on another sheet, namely 'mywork sheet'.
Ideal Skills and Experience:
- Proficiency in Google Apps Script.
- In-depth understanding of Google Sheets functionalities.
- Experience in creating interactive scripts for Google Sheets.
- Ability to build clear user interface for data lookup.
- Familiarity with data linking across sheets.
And in my words below
I have a list of names on a Google sheet. - Pupils and their grades in each row.
Currently I share this in view mode but they can all see each other's row of grades.
I want to hide this sheet, and share another sheet “My Work” where they can enter their number and it shows only this row of grades. - not all rows.
See the link and the sheet called Y11 grades - see copy below
The names appear in column C - I will hide this column
Their ID is in col B
I need a new sheet which shows the same headings. Rows - 1 - 7 - with a link to my main sheet. This must change when I change my main sheet to always be the same.
In this new “My Work” sheet they should enter a number and their row is shown.
Can you update my version below to do this? BUT I would want the solution so that I could understand it and apply to my other gradebooks.
If you can think of any other/better way to do this then suggest it. But I only want to maintain one copy that I can see all names and the students only see their row!
https://docs.google.com/spreadsheets/d/1WGOq0pApsHf4YiAlxFj8y70bR_vfSNogQW05IMoW9mw/edit?usp=sharing
I was looking at chatGPT adivce on how to do this and it suggests a front end of a Google form for the student.
Would you be able to have a nice user friendly google form front end where they input their ID number?
I would like another option to just show incomplete tasks. The columns whose values are 0 or 1 (0 means not submitted. 1 is submitted but there is a problem.)
I will have a different Google spreadsheet for each class so I need a different form/student entry for each class to access their correct grade book.
I need full edit/ ownership access of whatever you create so I can copy your solution to my own files - with some instructions on how to do this... so I can remember next year!
If possible, I would like to keep the master grade book as restricted access but the form can be open access. Anyone can use it but they need to know their ID to pull back their onw detais. They have to be able to access this form without a Google account.
They must be able to have working hyperlink to the see the work - as in row 3
Try to keep the version they see as identical in format and content to my master version. I could not get this to work
- Show a direct link to the data in the selected row on another sheet, namely 'mywork sheet'.
Ideal Skills and Experience:
- Proficiency in Google Apps Script.
- In-depth understanding of Google Sheets functionalities.
- Experience in creating interactive scripts for Google Sheets.
- Ability to build clear user interface for data lookup.
- Familiarity with data linking across sheets.
And in my words below
I have a list of names on a Google sheet. - Pupils and their grades in each row.
Currently I share this in view mode but they can all see each other's row of grades.
I want to hide this sheet, and share another sheet “My Work” where they can enter their number and it shows only this row of grades. - not all rows.
See the link and the sheet called Y11 grades - see copy below
The names appear in column C - I will hide this column
Their ID is in col B
I need a new sheet which shows the same headings. Rows - 1 - 7 - with a link to my main sheet. This must change when I change my main sheet to always be the same.
In this new “My Work” sheet they should enter a number and their row is shown.
Can you update my version below to do this? BUT I would want the solution so that I could understand it and apply to my other gradebooks.
If you can think of any other/better way to do this then suggest it. But I only want to maintain one copy that I can see all names and the students only see their row!
https://docs.google.com/spreadsheets/d/1WGOq0pApsHf4YiAlxFj8y70bR_vfSNogQW05IMoW9mw/edit?usp=sharing
I was looking at chatGPT adivce on how to do this and it suggests a front end of a Google form for the student.
Would you be able to have a nice user friendly google form front end where they input their ID number?
I would like another option to just show incomplete tasks. The columns whose values are 0 or 1 (0 means not submitted. 1 is submitted but there is a problem.)
I will have a different Google spreadsheet for each class so I need a different form/student entry for each class to access their correct grade book.
I need full edit/ ownership access of whatever you create so I can copy your solution to my own files - with some instructions on how to do this... so I can remember next year!
If possible, I would like to keep the master grade book as restricted access but the form can be open access. Anyone can use it but they need to know their ID to pull back their onw detais. They have to be able to access this form without a Google account.
They must be able to have working hyperlink to the see the work - as in row 3
Try to keep the version they see as identical in format and content to my master version. I could not get this to work