First post, so apologize if I have not chosen the best spot for it:
If I had table of values, let's say corresponding to a question number and its corresponding answer, what is the correct way to plan a database to allow users to store formulas to calculate a score based on said answers?
Let's say I have a table of answer given to a series of questions:
Then I have 3 different users, User1, User2, User 3.
If I want each user to be able to define how they want to weigh the answers to determine a final score
ex: User1: A1*3-A2*2+A3*7*A4=SCORE
what's the best way to handle storing a formula for each user?
Thank you for your time and help!