Forgive me if this has been asked and answered - I couldn't find it based on my search.
I'm trying to understand if it's possible to create a calculated field based on multiple criteria from a connected table. Here's a general description:
Each year, team members are assigned to a class and within that, a level. So, for instance, in 2017 there is an A class and a B class. Within each class, there are four levels, e.g. A1, A2, A3, A4. Each one gets a % value. A1 - 14%; A2 - 4.3%; B1 - 2.2%, B2 - 5.5%, etc.
So I created an Object where I select the relevant year, then the relevant class (A or B) and then the relevant level (1 to 4). And finally I assign the % value that I want each class/level to have for a specific year.
In a separate object, I have team members. Each team member record provides them with a class and level and list the relevant year.
Is there a way to bring the % value, for the correct year, class and level, to the team member object?
Thanks for any advice. And if this isn't possible in Knack, it would be great to get confirmation of that.