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?

No. When you duplicate the App, you will get an exact copy of the database with all computed columns intact.

[image] 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.

Will do, and thank you and Darren @Darren_Murphy for the help today. Glide is addictive. Lol! :star_struck:

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.

[image] 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.

Align Users with Grade Book

Ask for Help

Darren_Murphy May 5, 2024, 11:54am 24

Have a read of the below before deciding:

Topic		Replies	Views
Moving data contained within user specific columns Ask for Help	10	154	February 4, 2025
How to retrieve data after duplicating and relation in Google sheets Ask for Help	17	1078	February 24, 2021
Using data from a user specific to a row arranged sheet Ask for Help	2	290	April 6, 2021
Relations in glide table Report a Bug	3	333	October 20, 2020
Trouble linking some cells in Goggle spread sheets Ask for Help	3	375	June 8, 2022

Align Users with Grade Book

Related topics