So, with Oscar season around the corner, I thought I’d create a base containing all of the Films, Actors, Categories, etc. Then I’d like to create a form that allows folks to cast their votes in each category (via a form).
When the votes are in - I’d like to update the categories table with the winners in each category and tally the scores for ballots accordingly.
So here is the issue I’m having - How can I can I compare the ballot with the winning film to tally the scores for each ballot? Has anyone ever created something like this?