# How could I create a report from "user-specific" columns?
**URL:** https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316
**Category:** Ask for Help
**Created:** [September 1, 2022, 5:13pm UTC](https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316 "2022-09-01T17:13:47Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [September 1, 2022, 5:13pm UTC](https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316/1 "2022-09-01T17:13:47Z")
I made an app for my gym and we have challenges that members participate in. I have an “Admin” section in the app for the trainers at the gym to see various info about the members.
I’m trying to figure out how to create a report for a specific challenge. On the user side, they check a box that toggles a Boolean column named “Complete” and that column is user-specific. There are 21 challenges, i.e. “Try a new food” or “Average 10k steps/day”. Is there any way to have the user submit these results to be recorded in a new row?
I currently have a button “Submit Final Results” that records other info from user-specific columns in a new row, but those each have their own specific column for each challenge. I’m trying to wrap my head around how to do it for this group of challenges, because there is only one “Complete” column with different values in each row.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 1, 2022, 7:40pm UTC](https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316/2 "2022-09-01T19:40:41Z")
Ya…no easy solution. If you’re looking for JUST an export of data for yourself, you can export a table by right clicking on it from the data editor.
However, if you’re looking to create in-app reports/leaderboards etc using completion data, then you’re best bet is to either add new rows to a “completion log” sheet (row intensive) or by using the “trebuchet method” to create a comma separated list of users that have created a challenge (very lean, but doesn’t capture any additional data past “who completed what”).
Here’s a video I just created that outlines how:
> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…
---
### Author:  [@Clifton\_Crouch](https://community.glideapps.com/u/Clifton_Crouch)
#### Post date: [September 2, 2022, 6:30pm UTC](https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316/3 "2022-09-02T18:30:01Z")
Thanks, I think this may work for my scenario. I’ll try to implement it soon and report back.
I noticed you were using Pages in the video. My app is built for mobile, so I just need to figure out the cleanest way to present the list and buttons.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [September 12, 2022, 2:00pm UTC](https://community.glideapps.com/t/how-could-i-create-a-report-from-user-specific-columns/48316/4 "2022-09-12T14:00:18Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.