Staff Database: We wish to create a Database. This database will have approximately 300 Staff. When you click on a Staff Member, it will show the details of the Staff Member, including an image of the staff member, name, where they work, the department they work in (branch location), which area they work in etc. Now. There will also be 500 different Qualifications. Each member of staff can complete these qualifications in real life. When they have completed a qualification, the Admin needs to be able to go into this staff member and mark that he has completed this qualification. Which means that if someone views the Staff Member’s Profile, they’ll be able to see that this person has completed the qualification. This will mean that you’ll need to create all of the Qualifications as fields, and allow the admin to mark who has done what. Which will then automatically display in their Profile. Another thing with the qualification is that when a person has completed the qualification. The admin will be able to also set: - The Date they completed this qualification and - The Trainer For a better representation of this, please view Staff Training Database – 1.jpg You can see in the image that the staff profile has a list of Qualifications he has completed. - You can see that the admin has set “Yes” it has been completed. - There is also a “> Go” button which if clicked, the admin can view more details of this Qualification (in a separate directory, I will talk about this later). - The date the person completed the qualification and - Who the trainer was. So basically the admin would log into the system, go to the staff member, see a listing of all the qualifications. Tick the qualifications they have completed, set the date and trainer, press Save. And then this information would be displayed in the Profile. This database can be viewed online by anyone. Only the admin can edit the staff profiles and their qualifications by logging into the admin system. Now here is the other important thing. The Search: Anyone will be able to go onto the website and do a search. In the search, the person will be able to filter the database. So they can search for someone’s name. And the results will come up. They can also search for which department they work in / branch location, or which area they’re in or whatever. And if they search, it will filter and the results will come up. Now they can also filter by the Qualifications. So for example the person can search for Everyone who is located at this branch, in this department, and have completed these qualifications. They hit search and all the results are filtered and will show only the people who have completed those qualifications and are located in that branch and are in that department. Does that make sense? The results will show the listing of people, and then if they click on the person, it will bring up their staff profile. Pretty simple database stuff. Qualification Database: Now there will also be a separate database. This database will be a database of all of the Qualifications. Anyone can search the Qualification database and see all of the details/description on the qualification. We would want the 2 databases to link together, so when the admin creates a new Qualification, the admin will be able to mark that the staff member has completed that qualification and it will be displayed in their profile. You can also see from the Staff Training Database – 1.jpg that there is a “> Go” button, if the user clicks this button, it will open up in a new tab/page (_blank) it will take them to the Qualification details so they can read more about it. This would be the qualification in the Qualification database that they’re viewing. So how the two connect? Is something like this possible to create in Zoho? Please send us an email immediately if you would like to discuss this project: kim@iformat.com.au or pm@iformat.com.au or declan@iformat.com.au We’re based in Melbourne, Australia.