Maybe someone can give me an advice here :) I would like to know what is the best way is to do this.
I am creating an employee database with forms:
One form has all the employee basic data (name, birthday, join date, ...). In addition every employee has certain skills: java, c++, Windows, Linux, ... Each skill should have a different rating for each employee with 1-5 (1 = poor knowledge, 5 = excellent knowledge). Example:
Employe 1:
java 2
Windows 4
Linux 5
Important is: Finally there will be so much skill areas, that only those should appear on each employee record where he has at least some knowledge. In the above case c++ is not saved in the employee record at all.
Finally I want to create reports like this:
Show me all employees with Windows >3 and Linux > 4.
Is that possible? What would be the best way to do this in Zoho Creator?
Thanks,
Mike