# How to show each student a history of their test scores for each subject? **URL:** \ **Category:** Ask for Help\ **Created:** [August 2, 2020, 6:23pm UTC](https://community.glideapps.com/t/how-to-show-each-student-a-history-of-their-test-scores-for-each-subject/13457 "2020-08-02T18:23:12Z")\ **Posts on this page:** 1\ **Showing post:** 16
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 8, 2020, 10:30pm UTC](https://community.glideapps.com/t/how-to-show-each-student-a-history-of-their-test-scores-for-each-subject/13457/16 "2020-08-08T22:30:24Z")
I tend to shy away from any situation where a sheet is dynamically built from formulas and editable in the app. It’s too easy to get into trouble if you ever resort your primary sheet or delete records. I prefer using a script to add missing records, such as students, to another sheet. Here’s some info on a script that I use to add students to other sheets. If a name is not in the associated sheets, then the student name will be added. In my case I also use RowID and save the rowid in the associated sheets. This way if a students name is changed, the rowid won’t change and it won’t break any relations or erroneously add another record to the other sheets. > [@Populating multipls tabs from one tab in google-sheet](https://community.glideapps.com/t/populating-multipls-tabs-from-one-tab-in-google-sheet/11716): > > I have a registration form that adds a new row into tab=Order\_Form with Company Info and Contact info Email. Based on such received data (the system will generate a unique Client\_Id). I like to Add a new row to tab=companies to add this new company info & tag it with this new Client\_Id. Add a new row to tab=contacts to add this new contact info & tag it with this new Client\_Id. Add a new row to tab=Users to activate this contact as a user & tag it with this new Client\_Id. Add 10 rows to t… --- _[View the full topic](https://community.glideapps.com/t/how-to-show-each-student-a-history-of-their-test-scores-for-each-subject/13457)._