I'm trying to create a platform for my school and I want it to include a feature which lets student find out how many "passport" points they have. I'm trying to have an input and button command which allows students to input their Student ID (a 9-digit number), and it should return them the points that correspond with their id-number. I have a master google spreadsheet, and it contains some of the data. Here's how it looks.
For example, if someone were to input 000123456 and the website would return 12. Could someone guide me in terms of how I could link my website with a google spreadsheet? I'd really appreciate any help. Thank You!
