AnsweredAssumed Answered

List calculation with additional criteria

Question asked by ericmiller on Apr 19, 2018
Latest reply on May 11, 2018 by ericmiller

I will do my best to explain what I'm trying to do.


Talent Table

This table holds information for people I hire.  I have a table for the different skills, and then a Ranking Table which joins the talent and skill table and it allows me to also give the Rank record a rating on a 5 star system.


On my Table list I can filter the talent based on skills they have. I use a global field "gSkillListGlobalField" for a check box field for me to select the different skills I want to filter by.


Each talent record has a field called "cSkillListField" which makes a list of all the skills which the talent has.  Then is what the script compares to the "gSkillListGlobalField" to get my filter.


What I would like to add.  I would like to be able to add another global field where I can at a star selection.  For example I would add 4 stars, so only people who not only have the skill, are also 4 stars.


Right now "cSkillListField" calculation is simply "List (Skills::__kpnID)".  I'm wondering if I can add to this to then only list skills the person has which is X amount.


Then I could create a global field which might be "gSkillScoreGloabalField" which will hold a number score.  Then the formula would be something like List (Skills::__kpnID with score higher then gSkillScoreGloabalField).


Obviously that formula would not work, so I'm wondering how I could do this?



Thank you,



Screen Shot 2018-04-19 at 1.18.20 PM.png


Screen Shot 2018-04-19 at 1.04.11 PM.png


Screen Shot 2018-04-19 at 1.03.43 PM.png