How To Create an External reference page for Google Sheet On a Google Site

I Have created a Google Sheet Including some data of the students.Example Data Sheet

Now I want to create a google site page ,So that my Students can confirm whether the data entered is correct (My Google sheet will include over 3000 Student data)

CREATING A SEARCH PAGE

The Page will look like this and when the student start typing his/her unique Id this must give predictive Id's from the Id list in the column A in Google Sheet

in example when the student start typing 199 something like a dropdown will show filter the id's that starts with 199 that is in the column A in Google Sheet

CREATING A DETAIL PAGE

• After the Student type his/her Id and click on the search button the data entered under that ID should be shown vertically

As an example when a student search his ID 198980204105, then it should search column A in Google Sheet for his id and accordingly give the other results as in the below picture

In this example

• The student searched for his ID 198980204105
• This id 198980204105 is located in the cell A11 in the Google Sheet
• Because the ID is in row 11 the details in the row 11 is shown as in the above picture

POINTS TO CONCERN

• I want this User interface to be added into a google site therefore it should be compatible with google site
• I have more than 3000 User Data

https://stackoverflow.com/questions/66575506/how-to-create-an-external-reference-page-for-google-sheet-on-a-google-site March 11, 2021 at 10:07AM