# Align Users with Grade Book **URL:** \ **Category:** Ask for Help\ **Created:** [May 4, 2024, 2:16pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072 "2024-05-04T14:16:37Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 2:16pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/1 "2024-05-04T14:16:37Z")
I am trying to align an Excel spreadsheet where I am entering student grades to their USERID in the Users sheet. In the Excel spreadsheet, I also have columns where the students earn XP and GP based on the grades they earn. I have the GPTotal and XPTotal formulas in the Users sheet. I am not sure how to make sure the XP Total and GPTotal from the Excel sheet will get rolled-up into the USER sheet aligned with the correct respective student. Can I copy the ROW ID column over into the Excel sheet and relate them that way? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 4, 2024, 2:31pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/2 "2024-05-04T14:31:47Z")
If you have a UserID in both tables, you can create a single relation from your Users table to your Grades table (matching the UserID), and then use Lookup columns to pull in the values you need via the relation. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 3:52pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/3 "2024-05-04T15:52:00Z")
Thank you, Darren. I will try it out. On a related note, is it safe for me to hide columns in the Glide User sheet? I have so many columns now it is making things difficult to navigate, but at the same time, I don’t want to break any links. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 4, 2024, 4:06pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/4 "2024-05-04T16:06:32Z")
Yes, that is perfectly safe. Another useful thing is [column grouping](https://www.glideapps.com/docs/getting-started/introduction-to-the-data-editor#column-grouping) (in case you are not aware of it). If you group related columns together, you can collapse the entire group. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 4:11pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/5 "2024-05-04T16:11:40Z")
Oh that is a helpful tip, I will try. Thank you! ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 4:15pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/6 "2024-05-04T16:15:54Z")
What about hiding sheets, is that safe to do also? ---
**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:** [May 4, 2024, 4:49pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/7 "2024-05-04T16:49:05Z")
How would you hide a sheet? I’m not aware of that being an option. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 5:09pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/8 "2024-05-04T17:09:32Z")
When I go out of Glide to the Data Source spreadsheet, whether it is Google Sheets or Excel, the sheets can be hidden there. When I am working on my User Sheet outside of Glide (in Google), it would help if I could hide the 500+ sheets that I have there and just have showing the ones I mainly need. But before I do that and wreck relations and links, I wanted to check if that is safe first. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 5:23pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/9 "2024-05-04T17:23:20Z")
When I hide a column, how do I show it once again if I need to access it later? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 4, 2024, 5:27pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/10 "2024-05-04T17:27:01Z")
![CleanShot 2024-05-05 at 01.25.55@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f5ccc9d48192fc4aa7ad16088f473f29f49d70f.png) ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 5:29pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/11 "2024-05-04T17:29:06Z")
Nice! ---
**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:** [May 4, 2024, 5:33pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/12 "2024-05-04T17:33:49Z")
> [@Todd\_Lichtenwalter](#): > > outside of Glide Ah, ok. I guess I’ve never tried it. If you have a sheet tab that’s not being used by glide in any way, then it might be worth trying to hide it and see what happens. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 4, 2024, 5:42pm UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/13 "2024-05-04T17:42:01Z")
Will do, and thank you and Darren @Darren_Murphy for the help today. Glide is addictive. Lol! 🤩 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 5, 2024, 12:59am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/14 "2024-05-05T00:59:22Z")
Long time no see, Todd. Are you transferring your student app to the new version of Glide? ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 5, 2024, 2:28am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/15 "2024-05-05T02:28:51Z")
I am inquiring about it. It just seems like too daunting of a task if I have to rebuilt the majority of it. I am asking the Glide guys if they can let me test out the transfer before paying to see how the transfer turns out. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 5, 2024, 2:29am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/16 "2024-05-05T02:29:34Z")
Do you have experience transferring a complicated app like mine? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 5, 2024, 2:31am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/17 "2024-05-05T02:31:34Z")
I don’t have any idea if they have a better way to transfer things that they plan to release in near future. At the moment it’s basically having to re-do all the front-end stuff. ---
**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\ **Post date:** [May 5, 2024, 3:06am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/18 "2024-05-05T03:06:11Z")
oh dear Lord. I think I will just wait until they kill it off. That would take months. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [May 5, 2024, 3:13am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/19 "2024-05-05T03:13:10Z")
Look on the bright side, at least the front-end adjustments trigger you to explore and learn something new again. Duplicate it to a new application, and you can do it at ease, while your classic application is still functioning. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 5, 2024, 3:21am UTC](https://community.glideapps.com/t/align-users-with-grade-book/73072/20 "2024-05-05T03:21:56Z")
> [@Todd\_Lichtenwalter](#): > > I am asking the Glide guys if they can let me test out the transfer before paying to see how the transfer turns out. Just to be clear, you don’t have to change your plan or pay anything to Glide in order to migrate your App. You’ve already been grandfathered to a legacy team plan, so all you need to do is “Create App from data”. That will copy your entire database including all computed columns, and then you just need to work on the front end. As @Himaladin notes, you can do this without disturbing your existing Classic App. If your App has any value to you, you should absolutely do this, or pay someone to do it for you. [Next page](https://community.glideapps.com/t/align-users-with-grade-book/73072.md?page=2)