# Best way to record data for this gym program **URL:** \ **Category:** Ask for Help\ **Created:** [May 15, 2024, 3:50am UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386 "2024-05-15T03:50:30Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [May 15, 2024, 3:50am UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/1 "2024-05-15T03:50:30Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/238807d297cf681b851fd797107fd8f5ed27da40.jpeg) **Goal** Provide the easiest way for athletes to record results (in kgs in this example) based on a gym program. It doesn’t need to be laid out or formatted like this. It could be broken up into: 1. A program 2. Has a start date, loading and macro/micro cycle (what is that? 😂 ) 3. Has a week number 4. Has a day (1 or 2) 5. Has exercises 6. Has reps and a result The result is unique to each athlete, but want to be able to view results for all athletes, so not sure how user-specific columns would work. Again, there are no preconceptions about how to tackle this. **Progress** ![Screenshot 2024-05-15 at 13.51.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/721920007bb78da42aef8fb0286b06e10f3f14f5.png) ![Screenshot 2024-05-15 at 13.51.47](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/0249ada8dccdbd3dd8e67d3f1b6c978825e326d8.png) ![Screenshot 2024-05-15 at 13.52.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/3876625757eeac1eb62f7ef3db4977d0c4a6420a.png) ![Screenshot 2024-05-15 at 13.52.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/adc01299fbd0323b7adf1ce3f713680e5ee19ffb.png) **Help needed** - How do I structure this data? - What component(s) would work best to record the data? Considering using a data grid potentially. Thanks! ---
**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 15, 2024, 2:18pm UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/2 "2024-05-15T14:18:49Z")
I don’t have a good suggestion for this, when I read topics like this I just wish we have a custom code component to craft things up and tie them to as many columns as we need. Can also be a market for experts to help with crafting custom components like that. ---
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [May 16, 2024, 1:01pm UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/3 "2024-05-16T13:01:53Z")
Here is my first attempt at structuring the tables/data in Glide. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/d/8da105d76851d597ed5fb5e9b5c0bb59112f98f2.jpeg) Should I be using arrays or some other data structure to store this data? Data grid for UI component? ---
**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 16, 2024, 11:45pm UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/4 "2024-05-16T23:45:47Z")
So each combination of day & exercise should produce a result? Do you plan to store this in multiple tables? ---
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [May 17, 2024, 12:47am UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/5 "2024-05-17T00:47:25Z")
Yes, exercise A will have a result for day 1 (day 1 and 2 seem to refer to doing 2 days per week, and each day has a diff set of exercises). Yes, storing in multiple tables for now, unless there is an easier way to do it. That’s why I thought I’d try a grid or use arrays (I know how arrays work, haven’t thought through how to use in this case as not sure if it’s the right approach). **Goal** Each athlete can record a result for each exercise on each week for day 1 and day 2 of that week (could be session 1 and session 2, same thing). Days \> Exercises \> Weeks (specific sets and reps) \> Results Admins can view and report on data for individuals and full group. Will using user-specific columns be the right approach? Might be a simpler way to structure the program and get same result. Seems kind of complex the way the trainer has done it. Thanks Thinh! ---
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [May 17, 2024, 1:03am UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/6 "2024-05-17T01:03:35Z")
**Screenshots showing table set up** ![Screenshot 2024-05-17 at 10.59.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/42ad82945677fd8fe6937c8d0dcf2f58031d5823.png) ![Screenshot 2024-05-17 at 11.00.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2fc0d0da71c804022f3ae15f20575d8267e1fb0c.png) ![Screenshot 2024-05-17 at 11.00.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/e/1e37dd6f1ba273dbdc3f8fb999129d83b088ea36.png) ![Screenshot 2024-05-17 at 11.00.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c1ca7c836e3d3f41744471bd87cf45ec236001f4.png) **Screenshots showing UI** ![Screenshot 2024-05-17 at 11.01.07](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4ef90e3ccef864ee149a010ee53a4e74a349871.png) ![Screenshot 2024-05-17 at 11.01.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/793595bf715dc5011d4566af034ce9f5b20f82d7.png) ![Screenshot 2024-05-17 at 11.02.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/325fc7e5c1e9475f43ea950232568705b5a600cf.png) ![Screenshot 2024-05-17 at 11.03.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b301cbbca6fa54416953c2cd576234abd17ecde5.png) Two ways to enter results for same exercise on different weeks (9…12 in original program). Seems so complicated 😢 ---
**Author:** ![blairrorani](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blairrorani/32/43426_2.png) [@blairrorani](https://community.glideapps.com/u/blairrorani)\ **Post date:** [May 17, 2024, 2:37am UTC](https://community.glideapps.com/t/best-way-to-record-data-for-this-gym-program/73386/7 "2024-05-17T02:37:55Z")
Maybe I have too many levels of data. How could I simplify this?