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?
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.
1 Like
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.
Yes, that is perfectly safe.
Another useful thing is column grouping (in case you are not aware of it). If you group related columns together, you can collapse the entire group.
1 Like
Oh that is a helpful tip, I will try. Thank you!
What about hiding sheets, is that safe to do also?
How would you hide a sheet? I’m not aware of that being an option.
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.
When I hide a column, how do I show it once again if I need to access it later?
Nice!
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.
Will do, and thank you and Darren @Darren_Murphy for the help today. Glide is addictive. Lol! 
2 Likes
Long time no see, Todd. Are you transferring your student app to the new version of Glide?
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.
Do you have experience transferring a complicated app like mine?
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.
oh dear Lord. I think I will just wait until they kill it off. That would take months.
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.
2 Likes
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.
3 Likes