# How would you describe a helper table?

**URL:** <https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497>\
**Category:** Ask for Help\
**Created:** [November 19, 2022, 8:46am UTC](https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497 "2022-11-19T08:46:56Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**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:** [January 30, 2023, 2:35am UTC](https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497/16 "2023-01-30T02:35:27Z")

</div>

@erwblo - I saw Bob Petitto mention something about golf last night…

> [@Trying to save rows](https://community.glideapps.com/t/trying-to-save-rows/57241/3):
>
> Playing a round of golf where the scores for all 18 holes are on the same line as my “round of golf”

… which reminded me of one of my most “extreme” uses of a Helper Table.

I have a Golf App that tracks scores in PGA Tour events, pulling in scores via an API every 5 minutes when an event is on. When the scores hit my App, they go into a table that looks like so:

 ![Screen Shot 2023-01-30 at 10.14.12 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/844c0b96f186fbff251e2dff2d1ec751caec4efe.jpeg)

GolferID should be obvious, Raw is a comma separated list of their scores - 72 holes for a 4 round tournament.

I use a 72 row Helper Table to dynamically transform those comma separated lists in that table to the following:

 ![Screen Shot 2023-01-30 at 10.19.51 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f7bf3c31c8b8b0e1af321a9fc0d58044cac7b34.png)

As you could imagine, the Helper Table has some pretty crazy logic, and somewhere around 200 computed columns. Here is what it looks like:

You would think that with that much going on it might be pretty slow. But it isn’t. Golfers are presented in the App as an Inline List. When you tap on a Golfer, an action sets a couple of User Specific columns in the Helper Table. This triggers the calculations for that Golfer, and their scorecard is dynamically built and instantly displayed on their details screen. Here is what that looks like:

You can do some pretty neat stuff with a Helper Table 🙂

---

_[View the full topic](https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497)._