I’m facing a problem and I don’t think I know the right method.
I need to create a championship type event and define a point system (1st = 50pts, 2nd 45pts…) the points can be chosen by the user.
I’ve tried everything I know about bubble but I think I’m never taking the right direction in configuring the database.
Does anyone have an idea of how I should proceed?
Hi there, @gary45… if a user needs to be able to configure the point system for their event, then you are going to need to store the places and associated points in a data type. Can you share more info about your app/setup and maybe screenshots of your data types?
Indeed yes, I would like the user to be able to configure the number of points allocated per position in the event configuration.
To describe in detail: The finishing positions are edited manually at the end of the event (userA = 1st, userB = 2nd…) and I would like that depending on the position, the points defined for this event are displays to update your score.
Unfortunately I don’t have anything to share in the database because I don’t know how to take it.
I would simply like to say: ok, for this event, the 1st will earn 40 points…
I tried to create a line per position linked to an event but I don’t think this is the best solution because that would mean that it would be necessary to create a lot of lines because an event can have 50, 100 participants.
You could probably just keep it simple and have number fields on the event data type for first, second, and third place, and simply store the number of points for each place in the appropriate field.
If I understood correctly, this would mean that in the data type of the event, I must create 50 or 100 fields with all the positions? That’s a lot of fields to add, right?
Ah, I thought there might only be points associated with first, second, and third place.
So, for each event, you are expecting a user to define the points associated with each place from 1 to 100?
Yes, each event can have 10, 20 or 100 places with an assigned point system. The events are online car races and the finishing positions are edited manually via an input system or by drag and drop. So when the event is finished and edited the points are assigned according to the configuration of the event points.
Well, you gotta store the points somewhere… so lots of fields on an event or a separate data type that links points to an event… or possibly a list of numbers field on an event (I haven’t really thought through that one, though).
yes complicated I thought about it too much and I don’t know what to do anymore
This topic was automatically closed after 70 days. New replies are no longer allowed.