# Favorites Components **URL:** https://community.glideapps.com/t/favorites-components/21434 **Category:** Ask for Help **Created:** [January 20, 2021, 5:22am UTC](https://community.glideapps.com/t/favorites-components/21434 "2021-01-20T05:22:25Z") **Posts on this page:** 1 **Showing post:** 21
### 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: [January 24, 2021, 5:30am UTC](https://community.glideapps.com/t/favorites-components/21434/21 "2021-01-24T05:30:58Z")
That looks like more of a direct sheet copy script. I’m talking about a script thay only adds new rows that haven’t been added yet, but also checks for updated data or deleted data in the master sheet. I used to have a script set up to copy student names to a few other sheets, but later changed to copy student ID’s instead. Finally I ditched the script altogether and changed my app flows, so I no longer needed the script. The script I used would only add missing students to other sheets if they didn’t already exist in those other sheets. It did not touch any existing rows or headings. It only copied a single column to identify the student, but there were other columns of data related to each student. I used this because I needed the student names/ID’s to exist in the other sheets, but I could not risk the student name/ID jumping around in those sheets if the order was ever changed in the master sheet. Using a direct copy formula or unique formula would have caused a hole host of issues for me because the student names/ID’s would eventually become misaligned from the other columns of data in those other sheets. These are a few posts that are related to the formula I used to use. The third post is a modified version of the original script to fit a particular situation. This script ONLY adds missing student names to other sheets. It does not handle any updated names or deleted names. If a name would have ever been changed, then it would copy to the other sheets as a new name with the other columns empty instead of updating an existing row. That’s why I eventually migrated to using ID’s instead of names, but like I said, I don’t use any script at all, because I changed how the app works. > [@App for CSA](https://community.glideapps.com/t/app-for-csa/610/4): > > This is a script that I use to copy names from one sheet to 3 others. It’s a copied script that I found on the web and modified until it worked for me, so I don’t really have great details on how it works, but essentially I have a primary sheet with names. Whenever there is a new name added, the script will run automatically, check the 3 other sheets if the name exists, then add it to the next empty row if it does not already exists. It should work for sure as long as the value you want copie… > [@Email registration reference](https://community.glideapps.com/t/email-registration-reference/2156/2): > > App:Logins would be the place to get emails. You can use a UNIQUE formula in a new sheet to build a list, but you could run into problems if have other columns in your new sheet that need to match up to the email being pulled from App:Logins. I wouldn’t trust googles UNIQUE function in this case. Things can get out of whack if you’re not careful, as the order of emails could change. Instead I would use a script that will check for unique emails and apply them to another sheet. I use the fol… > [@Populating multipls tabs from one tab in google-sheet](https://community.glideapps.com/t/populating-multipls-tabs-from-one-tab-in-google-sheet/11716/7): > > The concept would be the same. Instead of a single function to copy\_new\_names, you could probably create separate functions to handle each sheet you are adding to. I would also possibly make a duplicate of subscriber and date in between company name and contact email to the getrange in the script works. There are probably better ways to handle this, such as concatenating the 3 columns into one column with a delimiter (such as a pipe “|” or a comma “,”), writing that to the first column like m… --- _[View the full topic](https://community.glideapps.com/t/favorites-components/21434)._