Google Sheets Pupil Lookup Script
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
- 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