Hey @Darren_Murphy so sorry I didn’t see this !!
Thanks so much for the response
But your table structure still looks a little odd to me - what happens when you have multiple users, how do you know which bets apply to which users?
This is a part that kind of puzzles me - am I able to set certain columns to be user specific? Some are greyed out but not sure if that’s because I’m not upgraded.
Basically the user would be able to add all their bets, and budgeting for units and dollars - they just cannot add or edit Sportsbooks.
Okay, so you’d add a Single Relation column to your Categories table, that joins the Category Name in that table to the Category Name in the Items table.
I will try this out now and reply shortly!
Then create a Lookup column that fetches the value you need from the Items table via that relation.
You can then use that second column in your math formula.
Will give this a go as well - lets hope I’m smart enough to figure it out