Beginner - Trying to build app to track pace of play on golf course

New user trying to track the pace of play on a golf course. I have a tee sheet table set up that collects tee time, golfer’s names, cart numbers and number of walkers. In Layout, when I click on a group of golfers, I want to be able to add an “observation” of what hole the group was on and what time they were seen. Ideally, there could be three or four observations for each group.
Then based on a pace of play table, I want to display a value for each group that is either on time, behind or ahead of pace of play. I have a spreadsheet that does all of this now but I was looking to convert it to an app for ease of entry.
Any ideas would be appreciated.
Thanks.

A few things to maybe get you started. It should be fairly easy.

First, I’m assuming that in your tee time sheet, golfers are grouped in foursomes. So the tee time and cart numbers are the same for 2-4 golfers yes? You probably want to have one sheet that is just for the tee time that applies to each group.

Then you’ll want a different table (or sheet) that captures the names of golfers and their cart numbers and relates back to the tee time table. The way you do this to link the two tables by a relation column that relates a value in the golfer table to to the tee time table’s row id (which you may need to add if you’re starting from a google sheet. ). When you add golfers to the second table, the form should be designed to write the row-id from the tee time table to a column in the golfer table, and then you use a relation to group them by tee time.

Use the same approach for observations. Every observation that is added captures the row-id of the tee-time for that golfer’s group. So for example when you click on the group, instead of “show detail screen for this item” you may want to change that to “show new screen” . On the new screen you can add a form to capture your observation, which would add a new row to the observation table. Again you’ll want the form to capture the row id of tee time table and write that to a column in the observation table and then relate them to one another.

The thing about pace of play is a bit more complicated and we might need some more information about your current approach. Likely you’ll want to use a math column to calculate expected pace against actual pace.

One way to help this make sense and get started is to poke around in some of the templates that use a similar approach of grouping people by events. Check out the event management templates, for example.

1 Like