Relation Issue - Categories to Items within Glide

Thanks :slightly_smiling_face:

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.

2 Likes

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 :slight_smile:

1 Like

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?

1 Like

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.

3 Likes

Exactly, this is also my thought

2 Likes

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

@Roldy + @ThinhDinh

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 (:laughing:) 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?

1 Like

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?

2 Likes

That’s exactly what I was curious about…

3 Likes

Sorry for the late reply @Roldy

you can solve this scenario building the relation from a calculated column (not from a fixed data)

Maybe you can show me how to do that? :slight_smile:

This is how I have relation columns built right now:

Items Sheet:

Cost in Units
CostUnits

Cost In Dollars
CostDollars

Categories Sheet:

Units
Units

Dollars
Dollars

Budget Remaining

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 :slight_smile: 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 :slight_smile:

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 :slight_smile:

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.

2 Likes

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 :slight_smile: 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 :slight_smile:

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.

1 Like

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 :slight_smile: 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.

1 Like

Ok I PM you

1 Like

Normally I would say yes, but I’m totally swamped at the moment, so I’ll have to pass this time. Sorry.

1 Like

No need to be sorry! I really appreciate it :slight_smile: