I have never built an app and am trying to learn. But i want to see how difficult this would be and if someone could point to videos on how to get started and what topics i should focus on to learn to build this.
I want to build an app for an online golf game that will help calculate adjustments and track shots.
Adjustments.
I have a general formula I use that based on wind direction, speed and distance can apply. But each club has different multipliers. I have it all charted out and currently have a google sheets file that I can run all my calculations from. I want to convert this to an app
Shot logs
I want the option to export the inforamtion from the adjustment screen to a shot log where you can recall later that on a given hole you always miss left or long or something so i can make adjustments on said hole.
For someone new to glide and new to creating apps how difficult will this be? What tips do you have? I have a good google sheets file that has all my current calculations and I was using Open as App for calcs but they are increasing price and i have no way to log shots.
I would say it is moderatly complicated. I currently have multiple calculations in the table based on entries on the âcalculatorâ tab. Then those calcs are used for the final calculation. I could write it all in one formula based on multiple lookups if i need to.
Basically each club at each advancement level has a base multipler then that multiplier is adjusted based on wind direction and how far from max that club is. The wind direction uses a basic trig funtion.
There is also a rollout calculation that calculates how far from the cup to land based on the shot view abd wind direction.
The way I envision the app working is you input the data (club, ball power, wind speed, wind direct, distance from max, rollout, elevation) then the calculator gives you your pull (adjustment) and your rollout. Then after the shot is taken you can select the course, hole and pin location (front, middle or back) and mark if you made the shot or short notes on how you missed. Then next time you play the hole you can look at your notes and make adjustments.
Alsobi would want a screen to set your bag up to help limit the club selection screen
A lot of the best players already have their own notes but it is in sperate apps. There are 2-3 apps for calculations but I like my numbers better so i want to build an all in one app i can use and share with some members in my club.
I think what I am looking for the most is some direction. I am syre it can be done on glide
Having never done anything like this i feel like i am trying to fly a plane but donât know what 90% of the buttons in front of me are. I have watched several toutorials and for the most part they make sense. But most everything is data only or very simple math. I have uploaded my sheets into tables and have poked around some but feel lost.
Bit hard to give specific direction without seeing what you are working with. Would you mind sharing some screen shots of how you have this setup in Google Sheets, and show/explain the formulas that are used? If we can see what you are dealing with, we can help translate it to Glide.
OK here is what all I am working with in my google sheets
Tab 1 - Bag Setup. Select the clubs you use regularly and what level they are. Only selected clubs show up in drop down and you can use the calibration to make small adjustments if the numbers donât work properly for you. The pull to or pull through column is based on how you play the club. pulling through adjust the number slightly.
All the green cells are manually entered. The rest are pulled from the table (where calculations take place) based on lookups of the club. The data entered in the green cells are used in calculation son the club data table. The dial doesnât move here but I have seen other make an app where the wind dial moves. I donât care that much if it does or not. It is there for reference
Tab 3 - Data table tab
Everything colored is calculated and everything white is base info about the club or used in equations.
Column B and C is a simple equation based on the calibration data in the bag setup tab. This number is applied in the final formula
Column J is a trig formula based on the wind direction. This number is used in the final âpullâ calculations. Actual formula is âsin(radians(450-âPull and Rolloutâ!$C$4*30))ABS((sin(radians(450-âPull and Rolloutâ!$C$430))))â
Column O is a number based on the RFM adjustment multiplier *RFM on the calculator page. This number is also used in the final âpullâ calculations
Column P is the actual pull number. formula looks like this â(((I2+B2)-O2+(M2*âPull and Rolloutâ!$C$6))((J2âPull and Rolloutâ!$C$3K2)+1)âPull and Rolloutâ!$C$3)-'Bag setup '!D2â
Column AB and AC are numbers based on Shot View or Rollout that tell me where to put the pin in relation to the landing based on the shot view and the inverse of that being if the pin is 2 rings away the SV needs to be X.
Hidden columns were things I was testing that are not working or not relevant.
Like I said earlier. I can simplify this to a single formula and make these steps all one long formula and just load the data into glide. I really need a point in the right direction
I also donât mind sharing this google sheet if needed.
As a matter of interest here is a web app someone else already created. But I want to add a data logger and use the numbers I have not their numbers. And of course a much different layout as to not steel theirs.
That isnr really needed in tbis application. But inappreciate the input. Mainly trying to get ditection on how to create this with Glide. What videos should ibbe watching. What ahould i read to learn how to do all this.
Thank you. I discovered him 2 nights ago and his videos are great but I feel I am jumping around a bit. I need to find a video that explains the layout and flow of Glide. I am sure he has one but with all the videos it is easy to watch things out of order or get distracted by things I may not need yet.
I have my tables loaded into glide and I can fill manually fill out a shot log. But leaning how to build a calculator based on inputs and formulas with lookups is where I get lost. I donât even know how to build the calculator screen with blank sections for inputs. I am so good with Excel/Sheets and so many other applications but I am really struggling to wrap my head around navigating and designing on Glide.
@jason_zeller Hey again Jason,
Again, I would suggest to use Make for scenarios/workflows, itâs cheap and very good. With the help of a good freelance. I would suggest me, I also sell my hour/rate if commissionned.
Take care,
