First of all, I’m beyond grateful for all the help I’ve received so far. ThinhDinh and Robert_Petitto have been amazing, and I wouldn’t have gotten this far without them.
As I look to complete my app (Monte Carlo) I’ve been stuck at two issue for a few days now, and could really use some help
The app works pretty simply – users can ‘Add A Bet’ with the options of: Name of the Bet, Cost (Units), and the Sportsbook it’s associated with (a dropdown)
The Sportsbook (Categories) page, shows the following related to what the user would set: Monthly Units Limit, Units Spent This Month, and Units Remaining.
They can also see All Time bets and a Start Betting button
Right now, the Units Spent this Month within Sportsbook shows 1 Unit Spent, which is related to the actual Bet added. It needs to be related to how many Units are spent on an Added Bet
I tried to change the Budget Remaining in Categories which is Math from limit - total, but I cannot select the Cost [Units] from the Items tab in Glide
Any thoughts on how I can related the Budget Remaining in Categories to the Cost [Units] in Items
Have you tried changing the “cost [unit]” column type in the data editor? It would seem more natural to me to use a numeric column for this rather than an RT column.
I can’t verify now but it could be because of it.
Eureka!! It worked!! You are amazing, thank you sir!
A last question - if I wanted to replicate the way I have Units set up, but to add dollar amounts, would I duplicate the Cost [Units] to be Cost [$$] and duplicate the Budget Remaining to have Budget Remaining for dollar values?
Regarding your question, I seem to understand that what you call “Cost [Unit]” is the APP’s internal currency type; and now you want to add another type of currency that can alternatively be used for betting; dollars in this case.
I’m wrong?
However just a consideration: it may be easier to think of an exchange rate between the two currencies; consequently rather than doubling columns of data, you could instead use math columns to represent one currency or the other, depending on the type that the user wants to use to place the bet.
You are right on the nose with how it works - Units is a “currency” used in betting and right now the main focus of the app (for serious betters, where their bankroll can be $100 or $10000 but they are wagering 2.5 units which is 10% of their bankroll)
However, some users may want to only track dollars spent on a bet, where the other associations are the same. So I do get what you’re saying about exchange rate - however I want to give users both options, which one I will make required
Maybe it’s my limit (because I don’t know the betting argument well) but once again I see that the conversion rate can be the only way to avoid repeating the existing associations.
So, for users who want to play with Units, they will see all calculated Units, while for users who want to play in dollars they will see all calculated in dollars.
In practice, Units and Dollars are the same thing, from my point of view, only they have a differently proportioned numerical representation.
So a user can bet $ 10 or he can bet 2.5 Units, but he is always betting the same value. Is that so?
Maybe a column to store info of how many dollars is a unit for a player, then another to let them choose between dollar or unit to show in the app. More to configure from there to keep the dual numbers though, and show what’s relevant to the user’s preference.
I think the biggest challenge is when they input a new bet, then work must be done to either let them input a bet in units, or in dollars.
Are you able to expand a little more on what this means?
This is correct. While I do want to relate Units to bets (1.0 unit = 10% of the dollar amount), that can be a next step. For now I want to allow users to enter a dollar amount, separate of the Unit amount
Units and Dollar are connected but work in this formula:
1.0 Units = 10% of total dollars … example if I have $100 and I’m betting 1.0 unit, it will be $10 only, etc
This way, in the betting world, it doesn’t matter how much you have as everyone can bet the same way using Units
Maybe a column to store info of how many dollars is a unit for a player, then another to let them choose between dollar or unit to show in the app. More to configure from there to keep the dual numbers though, and show what’s relevant to the user’s preference.
For sure! For now, I want to show both and the next step is the relation between Units to Dollars (1.0 Unit = 10% of the total budget) I could duplicate two of the columns essentially in each sheet (within Glide) and change the Units to $$
I think the biggest challenge is when they input a new bet, then work must be done to either let them input a bet in units, or in dollars.
Agreed! Though, many users will want both or just one - but I did build this in mind being Unit based but one of the two will be required .
Any input on the best practice in terms of how to implement this would be amazing! Thank you both <3
I created the columns for the $$ amount - right now however it is relating to the Items Total and the Math is not getting the right amount for the bet. Any thoughts on how I would connect it? I have my Cost in Dollars in the Items sheet
From my point of view, i’m betting () you can solve this scenario building the relation from a calculated column (not from a fixed data).
But Kevin, it’s not very clear to me how you’ve built relation columns right now.
Can you show me?
A further question, as you are making an APP to distribute to bettors, where is the user table? Each user will have their different bets to make, but here I do not see variability depending on the user who is betting.
So my more precise question is: what is the privacy model you have set for this APP?
A further question, as you are making an APP to distribute to bettors, where is the user table? Each user will have their different bets to make, but here I do not see variability depending on the user who is betting.
They are not betting on the platform, they are adding bets they made on other sportsbook. This is basically a budget tracker for betting So Add A Bet is the equivalent of Add An Expense. The Sportsbooks are Categories like Groceries. This is a way for betters to track their Units Bet and Dollars Bet on each bet, and sportsbook
So my more precise question is: what is the privacy model you have set for this APP?
This is my next step - which I will need some help on. How do I make sure it is secure? There will be no money held on the app itself - this is just a budget tracker for betting, made specifically for those who want to track their betting
Is there a way for me to set this up? Every user logs in and has their own access to track their bets
In simplest terms - this is the Glide Budget Tracker app (with the pig icon) that I’m repurposing for Betting. No actual bets are made, just tracking of bets
Okay, I’ll give you some time but now I don’t have any because I’m about to go to sleep. In the meantime, you should be mindful of your APP’s business model. The choice of the most suitable Glide plan depends a lot on that; then look at Glide’s plans and evaluate what you think might best fit your business model (how many users will use my application? what personal data will I collect and what will I do with it?).
In this scenario, if I were to make the choice, I would probably opt for a public privacy with email, hiding the user’s email address, and if I believe that the 500 rows are not enough, then the forced choice would be to adopt a Pro App plan.
So: will you fit in with 500 rows? (to give you an example: for each user a bet will be one line, so: if you have 20 users placing 20 bets you are already close to the limit of what the free plan can offer).
Tomorrow I will explain the technical part to you better, in the meantime, however, try to better understand your business model and consequently the most coherent Glide plan and, consequently, the right privacy setting.
I see that @Darren_Murphy is also following this discussion and will probably have good advice to give you on these aspects as well.
→ Also look at the platform documentation, it’s very well done and easy to understand, and there is probably the answer to many of your concerns.
Thank you so much @Roldy - I will compensate of course for any help, and will give access. I think will be pretty easy for you There may be a few things if you can do, we can task it out and obviously pay you for your time!
So I will most likely need to go with the Pro Plan for sure - and as for privacy, when can hopefully discuss that over a call or online and get that set up as apart of the tasks?
Business model wise - works like this:
Users login with email or Google sign in. I don’t need to really store any info other than emails - their data on their betting and budget info is private to them. Other than email, I don’t store any money nor can they add money (for now) there is nothing to be paid for from the user, as the APP will be free to use. The emails I will only use to sent bi-monthly newsletters at most.
We can work to set up the right settings, as I think we’re not far enough.
Once the budget remaining issue with the dollars is solved, I want to add one more feature - which is a Win and Loss for each bet, which when the users sets will have info in a drop down of Win or Loss, than they type in a numerical field the +/- of the Units and Dollars.
Once those are done, and we have solved security - it will be good to go
Thanks for your proposal, but in case I prefer to help for free; certainly I have enough experience to be able to intervene however I must warn you that this would be the first support I do remotely, and therefore I do not feel like asking you for any compensation, also because I see this thing as a gym for me. Another thing for which I must warn you is related to the fact that my English is not good at all, I can write it and I can read it but I am not able to speak it and even listening to it makes me difficult, especially when it is spoken quickly; so I believe that our discussions could take place via whatsapp or other such chats.
If you feel comfortable with all this I will be happy to help you, otherwise you can turn to many other certified experts (I am not certified) that you can find here in the community and who will surely be happy to support you; if you decide so I will not be sorry.
Check out the Certified Experts page:
for example @Darren_Murphy and @ThinhDinh who have already participated in this discussion, I can assure you that they are Aces and can help you even better than me if they are available.
Working remotely and over Whatsapp sounds great! Even though this is like practice for you, I would still like to pay you but that is up to you if you want to let me! I appreciate this a lot and would love a change to have your skill set on this. Let me know in PM where I can email / number to add to Whatsapp We will go through the tasks more in detail
I’m more than comfortable with this, and @Darren_Murphy if available, would love your input too and even to have you on board for some consultation.
) you can solve this scenario building the relation from a calculated column (not from a fixed data).
