Adding continuing range then selecting a random number

[loconft2]

Hi Bubble guys and gals,

I need to create the following workflow.

User selects a number of entries (numeric value) against a listing (listing ID).

Once entered I need to populate an entry database with the following structure

User - Current user
Listing - Listing ID
Entry range - last number (1 if blank) - (plus number of entries)

Example (User is the first to enter on specific listing and buys 5 entries)

User - Joe Bloggs
Listing - 123456
Entry range - 1 - 5

Once this database structure is in place I need to select a random number from the max number in the numeric range from a individual listing ID, then populate an additional column with “Won” where that number lies in the rows.

Can this be achieved in Bubble?

Your response will be much appreciated!

[mishav]

Which solution fits best depends on how many users and listings, see discussion of a similar but simpler problem:

Get random value based on probabilities

HI everyone, my problem is that User table has field points ( type : number ) Option table contain who take part in ( list of users ) Vote table list of options and date that make voting expired i want to choose a random user when vote expired ( consider that each user has a probability to be chosen equal to number of point / all users point sum ) Example to simplify it : let A , B, C are users A → point = 10 A → point = 20 A → point = 30 Sum = 10 + 20 + 30 = 60 now probability of A (…