I am building an app for someone to review a call centre contact. The contact is marked based on a variety of attributes and the user will mark each attribute as either yes, no or N/A.
This is then submitted as a form to a sharepoint list called "QA Form Entries" where the columns are the agent, the reviewer, and all of the attributes, along with a pass or fail on the call.
I have a separate list called "Attribute Descriptions" where the attributes are stored as rows, and each attribute has a name, score weight, and description as well as an yes/no column called "is zero score?" for if failing this attribute will fail the contact as a whole (such as if they didn't pass DPA). I have it stored this way so that the user can click an info box on any attribute in the form to pull up the description of that attribute, and since it is stored in the sharepoint it makes it easy to maintain if any of the attribute descriptions need amended.
Where I've gotten stuck is, working out whether the call passes or fails. I know I could code in a bunch of if statements so say, if any of these attributes are not a "Yes" or N/A, then fail then call. I'm wondering if there's a way to use the yes/no column in the attributes list, to then check those columns in the contact list without having to code for each individual one. This will make it easier to maintain if any of the attributes become automatic fail attributes in future as it would just require the box to be ticked in the sharepoint list.
I've attached screenshots of the list layouts for reference, any suggestions would be much appreciated. The furthest I've gotten is creating a collection of Attribute Names that are zero scores. Just not sure if it's possible to compare the list of attribute names to column names in a different list.
App is still in early development so if either list layout needs changed I can look in to that.
