Employee Training Database/Matrix

%3CLINGO-SUB%20id%3D%22lingo-sub-737602%22%20slang%3D%22en-US%22%3EEmployee%20Training%20Database%2FMatrix%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737602%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3EI%20have%20setup%20a%20list%20within%20my%20Human%20Resources%20site%20for%20a%20Training%20Register.%3C%2FP%3E%3CP%3EI%20have%20the%20columns%20setup%20as%20per%20the%20attached%20snapshot.%20With%20columns%20being%3C%2FP%3E%3CP%3E-%20Title%20(single%20text)%3C%2FP%3E%3CP%3E-%20Employee%20(drop%20down)%3C%2FP%3E%3CP%3E-%20Induction%20(date)%3C%2FP%3E%3CP%3E-%20Construction%20Card%20(URL%20-%20which%20i%20then%20link%20to%20the%20copy%20of%20the%20certificate%20in%20the%20employee%20document%20library)%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20some%20columns%20that%20are%20a%20simple%20Yes%2FNo%20and%20some%20that%20are%20the%20URL%20with%20display%20text%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20Format%20the%20columns%20so%20that%20some%20cells%20go%20red%20when%20the%20employee%20is%20required%20to%20have%20a%20certain%20licence%20or%20certificate%20but%20doesn't.%20However%2C%20not%20ALL%20employees%20are%20required%20to%20have%20the%20certificates%20so%20i%20dont%20want%20empty%20cells%20red%2C%20just%20some.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20anyone%20knew%20how%20to%20do%20this%20or%20has%20setup%20a%20similar%20thing%20themselves%20in%20a%20different%20way%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All

I have setup a list within my Human Resources site for a Training Register.

I have the columns setup as per the attached snapshot. With columns being

- Title (single text)

- Employee (drop down)

- Induction (date)

- Construction Card (URL - which i then link to the copy of the certificate in the employee document library)

...

 

I have some columns that are a simple Yes/No and some that are the URL with display text

 

I need to Format the columns so that some cells go red when the employee is required to have a certain licence or certificate but doesn't. However, not ALL employees are required to have the certificates so i dont want empty cells red, just some.

 

I was wondering if anyone knew how to do this or has setup a similar thing themselves in a different way?

 

Thanks

 

0 Replies