Tracking training certification expirations

Tracking training certification expirations

Hi Zoho Community!

I'm looking for some input on the best and most efficient ways to track training expirations in Zoho CRM. I have a very specific workflow that I am looking for - my company offers trainings, and the certification expires every 2 to 4 years (depending on the class).

I need to be able to track the following:
  1. When someone signs up for a training course (and which one)
  2. Which class they signed up for
  3. Date they completed/passed their course
  4. Personal data for filing their certification
    1. First Name
    2. Last Name
    3. Email address
    4. Mailing address
    5. Telephone number
    6. Mobile number
  5. When do they expire
    1. Also triggers a reminder email 3-months prior to their expiration date
  6. I also want to keep a running log for each student of when they took all of their classes... so, in 2-4 years, when they re-certify, I do not want the new training record to overwrite the old training records... I want it to be added to the list of training records.
  7. We offer several different classes and the students can (and are, at times, required to) sign up for multiple classes.  As such, multiple class records should be allowed for each student.
  8. We also need to be able to run reports for certificate generation purposes.
    1. .xlsx, .csv, and PDF formats are ok.
I'm not sure what the best or most efficient way is to accomplish this.

Looking forward to your responses and ideas!!

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方