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. 

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • 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


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now