1

Hi,

I’m trying to build a scoring system based on users inputs for a fantasy football app.

I’ve built a submission form where users can submit 5 responses related to an upcoming game (most passing yards/rushing/TD’s etc) These are recorded in a dataset.

Based on these responses (after the event), I want to be able to automate the scoring based on their responses.

So - Say I picked Daniel Jones as Leading Passer for the week (lol) from a dropdown, this is recorded in the DB on Friday. Then once all the games are finished, I want to attribute 5 pts to all users who selected him if he was 1st, 4 points if he was 2nd (and so on).

Once I can build a scoring engine, I’ll have no issue with building a leaderboard etc. but is there any way to automate the scoring so I identify the scores for each users responses in one data set, so a code/function calculates total scores for users submissions?

At the moment I’m thinking the only way is to export the data into Excel, apply a calculation/IFfuntion, and import it back into Bubble?

Any ideas?