How to create a two part contact database in Zoho Creator
Greetings,
I'm new to Zoho and work in the field of education. I'm trying to create a two part faculty contact database. Part 1 needs to be a standard generic form that I send to each instructor to complete. I need to be able to email a link to each instructor to access the form and submit the form. This I have completed in Zoho Creator.
My problem lies with Part 2 of the contact information. Once each instructor submits the form I need for it to be send back to me so I can add their ID numbers, their university email address, their employee number, the courses in our program they are qualified to teach, their license information (type, state, number, expiration), their degree information for bachelor, graduate and post graduate, etc.
Once I enter this information I need it to report out in a spreadsheet format.
I would also like to click on each faculty name in the spreadsheet and see a page with their details of all their information.
I've watched some of your CRM videos but I don't think this is what I need since this contact database is more for course scheduling, then for sales.
Grateful for any advice,
Lisa