# Data from a user-specific column into my google sheet? **URL:** \ **Category:** Ask for Help\ **Created:** [June 30, 2021, 3:48pm UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524 "2021-06-30T15:48:41Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [July 1, 2021, 2:14pm UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/21 "2021-07-01T14:14:49Z")
Genius ! Yes that will work I am sure - I’ll test it out but yes it does look like the solution. So would this have to be done in the profile page or another sheet? not sure I understand this part _you could use that sheet in Glide and then be able to return instant results with a template/relation/lookup column combination._ but I’ll play with it. ---
**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:** [July 1, 2021, 3:19pm UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/22 "2021-07-01T15:19:03Z")
> [@baremeter](#): > > So would this have to be done in the profile page or another sheet? No, I’d have that in a separate sheet. > [@baremeter](#): > > not sure I understand this part _you could use that sheet in Glide and then be able to return instant results with a template/relation/lookup column combination._ but I’ll play with it. I have a copy of your app, if I have some time tomorrow I’ll add some dummy data and make an example for you. ---
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [July 1, 2021, 3:21pm UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/23 "2021-07-01T15:21:24Z")
You are a STAR ! ---
**Author:** ![baremeter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/baremeter/32/28090_2.png) [@baremeter](https://community.glideapps.com/u/baremeter)\ **Post date:** [July 1, 2021, 7:04pm UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/24 "2021-07-01T19:04:20Z")
I’ve got it working a bit - but still having problems getting the data out. I have a sheet with fixed data from 1999 - 2021 in a column with the rates along side. I then created a sheet in Glide that uses a relationship to the sheet and then a lookup up to the same. The data was not individual. I then tried again with user-specific columns for date and value no good Then I used the user profile again with relationship and lookup. It worked on the first name in the list but it does not populate down the page with the relationship and lookup so the calculations do not work. I do feel that I am closer yet mile away! ![Screenshot 2021-07-01 at 20.56.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c10afc02709bcc15ad7f53dee11d11b357ea2abc.png) Thanks ---
**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:** [July 2, 2021, 5:14am UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/25 "2021-07-02T05:14:06Z")
@baremeter @Mike_Greene - here is a copy of your app with a worked example, as promised. > **[FX test Baremeter](https://crowded-meal-0257.glideapp.io/)** > > V21.06 Take a look at the Historical Rates Google Sheet, Glide Table and screen tab ![Screen Shot 2021-07-02 at 1.06.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed548b051fa8c7d01910639995411fb063f3d8ee.png) Notes: - I just added dummy data for the years 2018 to 2021 in order to demonstrate how it works - The values in the Year & Month choice components are dynamically generated, based on the data values. Check the following columns to see how that works: ![Screen Shot 2021-07-02 at 1.09.13 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/2041de3fe039bffb6e65dd469713496700fe3512.png) - the way it works: - the selected year and month go into user specific columns (`usc/year` and `usc/month`) - these are combined in a template (`tp/selected`) - this template is used to form a relation to the actual data (`tp/year-month`) - a lookup (`lk/selected`) retrieves the rate through that relation for the selected year/month combination - the lookup value is combined with the selected year/month values into a template, and that is displayed in a hint component Let me know if you have any questions. Enjoy 🙂 _PS. I’ve removed all the personal data that was in the original copy that you shared with me 😉_ ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [July 2, 2021, 7:09am UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/26 "2021-07-02T07:09:05Z")
My goodness - you have worked so hard on this I am so very grateful - I will replicate it in my working version and add in my display features and correct rates data Just a pity that I cannot copy and paste the Glide Table ! ---
**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:** [July 2, 2021, 7:15am UTC](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524/27 "2021-07-02T07:15:48Z")
> [@Mike\_Greene](#): > > My goodness - you have worked so hard on this hehe, not really. I do this sort of thing a lot, so I’ve had plenty of practice. It might look like a lot of work, but that only took about 20 mins 😉 Anyway, you’re welcome - hope it gives you a few new ideas to play with. [Previous page](https://community.glideapps.com/t/data-from-a-user-specific-column-into-my-google-sheet/28524.md?page=1)