# How to collect datas from a progress bar? **URL:** \ **Category:** Feature Requests\ **Created:** [June 30, 2020, 8:01am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715 "2020-06-30T08:01:05Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)\ **Post date:** [June 30, 2020, 8:01am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/1 "2020-06-30T08:01:05Z")
I’ve set up a user-specific progress bar so that each one could follow its own progress in a training program. I’d like to collect the progress of each user. Today I have to use “preview as” and copy each email to see each score but I’m sure I can find a better solution. Any ideas? ---
**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:** [June 30, 2020, 8:34am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/2 "2020-06-30T08:34:51Z")
Are you counting the number of “done” items in a program by rollup? ---
**Author:** ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)\ **Post date:** [June 30, 2020, 9:59am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/3 "2020-06-30T09:59:28Z")
Yes, the sum of modules done fill the progress bar. I just want to link that sum to the user email. ---
**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:** [June 30, 2020, 10:05am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/4 "2020-06-30T10:05:41Z")
You have your “User profiles” sheet right? Where are you counting the modules done for the progress bar? I suppose you can make a single relation matching the email in the “User profiles” sheet to the “Modules” sheet, then have a lookup to pull back the number from the rollup column. ---
**Author:** ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)\ **Post date:** [June 30, 2020, 11:58am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/5 "2020-06-30T11:58:30Z")
Yes I have the email in “user profiles” sheet. But I don’t have the email in my “modules” sheet: this a just a list of things to do with the score of the user. I’ve made a screenshot for you ![link progress mail](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6f9b0e3052afff753aa96b762556dda6a2940a88.png) . Thanks a lot for your help ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [July 1, 2020, 2:56am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/6 "2020-07-01T02:56:05Z")
If you do not have a way to create a relationship across the google sheet tabs may I suggest using a arrayformula to perform a vlookup in the page without any relation data so that you can use that same vlookup result to create a relation in the app. ---
**Author:** ![Jim\_Parish](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_parish/32/7653_2.png) [@Jim\_Parish](https://community.glideapps.com/u/Jim_Parish)\ **Post date:** [July 1, 2020, 8:31am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/7 "2020-07-01T08:31:27Z")
I don’t think I’ve caught it. The score doesn’t appear in my google sheet, only in DATA from Glide. I indeed want to create a relation between the "“modules” sheet and the “user profile” sheet by linking the email but I don’t manage to do it. ---
**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:** [July 1, 2020, 8:35am UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/8 "2020-07-01T08:35:50Z")
As you have realized, there’s no way to link the data when your “Modules” sheet contains all the information in a user-specific way. I can’t think of a way to collect data back to your profiles sheet with this structure, apart from asking the players to submit their score back to your sheet via a form. But as you have launched it, I don’t think it’s a good way. At the start, you should have let the users create one row for each of their “module” challenge so that you can relate to that via their email. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [July 2, 2020, 5:00pm UTC](https://community.glideapps.com/t/how-to-collect-datas-from-a-progress-bar/11715/9 "2020-07-02T17:00:46Z")
create a editable space that is set to their scores andhave the progress bar pull from that list