Workaround for lack of and/or functionality on forms rules?

Workaround for lack of and/or functionality on forms rules?

I'm trying to build a form that works something like this:
  1. The user is given a special code during a live webinar and is redirected to my form at the end of the webinar.
  2. The user enters their details on the form, including the session name from a dropdown and enters the code given during the webinar. Each session has a different code.
  3. If the user enters the correct code for the webinar they attended, Zoho forms will automatically send them a certificate of attendance after submitting the form. If the user does not enter the correct code for the session, the form gives them an error and does not allow submission.
If there is only one session and one code, I can use field rules as a workaround. I started by creating a description that says "You have not entered the correct code," which appears by default. I then created a checkbox that says "You entered the correct code. Please check this box to receive your certificate." I made the checkbox mandatory.

Then, I used field rules. IF session attended = ABC Session AND Code = XYZ, THEN Hide "You have not entered the correct code" description AND Show "You entered the correct code. Please check this box to receive your certificate" checkbox.

Again, this works as long as I only have one session, but once you've used a search field in one rule, you can't use it in another, so I cannot create a rule for each session that involves the same search fields or the hide/show functionality like I wanted.

There's also no and/or functionality, meaning I cannot set it up in a way that says IF session attended = ABC AND code = XYZ OR session attended = DEF AND code = UVW, THEN hide the description and show the checkbox. 

Is there a workaround for this? In my perfect world, I would only have one form because then I could easily track who requested certification from all my webinars in one place. Without something that works like this, if someone requests their certification at a later date, I might have to look through dozens of forms to see which session they attended.

We recently became approved to provide continuing education credits through an industry accreditation body. They require us to use a verification code and also have rules about us maintaining lists about who earned CE credits, which is why I want to automate it as much as possible and keep it all in one place. I may never need the info, but if they ask for it and I can't provide it, we'll lose our authority. 

We have Zoho One, so I've looked into other solutions within the suite to help me manage this better. Forms seems like it has the most potential but it's not coming together.

Campaigns does not seem viable because many of our clients share an email address and the name in Campaigns needs to match the name in CRM - imports/ automation override the name which is there by sync.

Flow does not seem viable because it will not provide me with a single list of validated respondents.

Any help/ ideas would be greatly appreciated. 
    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      • Sticky Posts

      • Take control with geofencing: Manage form access based on location

        Hello form builders! Location-based data is not just about knowing where your users are—it's about making better decisions. With Zoho Forms, you can now collect your respondents' coordinates and define virtual boundaries, limiting form submissions to
      • Introducing Card Forms!

        Hello form builders, Zoho Forms is now introducing an elegant, free-flowing fluid design of Card forms that will give your forms a visually appealing look, while avoiding any visual clutter for users who are attempting to answer multiple questions at
      • Important update in Zoho Forms: Enhancements for improved email deliverability

        Hello, form builders! We would like to inform you about some changes we're making in Zoho Forms to ensure the deliverability of your outbound emails. Changes to Gmail policies Gmail has updated its DMARC policy which quarantines emails sent with gmail.com
      • Form language translation in Zoho Forms

        Hello everyone, Any business needs to satisfy its customers to gain favorable results, and it's not always easy. Various factors, like culture, education, and economics, can influence how they react to your products and services. When you're looking to
      • Enhancing user experience with Audio/Video Upload in Zoho Forms

        Hello form builders! Today, interactive forms are an integral part of websites and applications. While text-based inputs serve a variety of purposes, audio and video uploads can open up a world of possibilities for businesses. Imagine you are a talent

      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 Campaigns 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 コンテンツ




                              ご検討中の方