I’m looking to build an app that allows you to answer questions that have numbers assigned to an answer. Once the questions are all answered, the respective numbers are averaged, and a specific grade is given.
Is there a way with the database to allow me to have a field change to a specific given item depending on a calculated average in the database (I was thinking relationships between a “Questions” database, with a relationship to a “Grades” database would work).
Any help is appreciated, thanks!
Just wanting to know if this is at all possible.