I play golf with my friend at my local course many many times during a one year period. We always play matchplay (lowest score on a hole wins the hole so… +1, even, or -1). We have been keeping track of each round in excel for 2020, and I decided to build a web app on bubble here to track it for us. The app is built, I have pages to enter scores hole-by-hole and all…but now I am at the point where I need my submit button to:
Hit the submit button to make this happen:
- Take the selected players name (dropdown) and date
- Check the database for a “score” from the “user” on specified “date” on same “course”
- If we both played on the same “course” and the same “date”, then compare our hole-by-hole scores (+1, even, -1) and give us the result of the 18 hole match
- Log the outcome of the match for both “users” alongside their “score” for that “date”
I understand there is a lot there, but here’s the real world problem we’re trying to automate and track. Presently we play on the same dates regularly, but not always in the same foursome as we may have 8-12 players. So after each round we have to sit down and compare hole-by-hole scores, then write down who won and what each person shot that date.
Example: Kyle win and shot 78 (net 76) vs Peter loss and shot 80 (net 77)
This leads to an end of year list that we have to add up and review to see who won more, and it’s a lot of manual work. Therefore I’ve built my add interface, the homepage, signup/login, enter scores, enter course, user dashboard, etc. But now I need my form on the user dashboard which allows me to select someone to PLAY, to compare my score against their score as explained above. Any/all help would be much appreciated. I just started on bubble so I’m a complete rookie outside of getting the general layout and functionality (outside of this advanced math) working.