Hi, I wonder if anybody has the answer to thi...

(Chris Jeal) #1

Hi, I wonder if anybody has the answer to this one?

I have a list of staff I have a list of training guides I have a list of staff trained on each guide

How do I go about finding/showing a list of guides vs. staff not trained on each? Or vice versa

Or for each member of staff a related table of guides not complete?

Thanks in advance, Chris.

(Reza Raoofi) #2

Assuming you have already properly set up relationship between Staff and TrainedStaff, i.e. there is a Ref column in TrainedStaff that is referring to Staff table and storing StaffID (Key column in Staff table), then you could use IN(…) function to find Staff that are not trained; for example you could have a slice on Staff table with this condition: NOT(IN([ID], TrainedStaff[StaffID]))

For more details and examples read this document: http://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates