Logic-based form calculations - Introducing Conditional Formula for Zoho Forms

Logic-based form calculations - Introducing Conditional Formula for Zoho Forms

Hello fellow form builders,

We hope that our  rewind post got you on the edge of your seat, intrigued about the useful, new features for 2020. Well, we are very excited to roll out the first one for the year! :)    

When our team analyzed customer feedback and use cases last year, we realized how much effort our form builders were exerting to craft a personalized form filling experience for their customers/users. We know that our conditional logics feature has saved you a lot of time when creating specific complex forms. We wanted to take this one step further. With the new Conditional Formula  feature, you can track customer actions with your forms, perform data-driven calculations, and provide specific, customized payments. 



Your forms are already geared up with this newest update. When a customer inputs their preferences, the form will provide them with a unique payment or a solved mathematical output.

What was there before? A formula field that allows you to set a static and predefined mathematical calculation in your form.  

What has changed? A new  Advanced  icon is available, which takes you to a platform where you can set up conditional mathematical formulas. 


 
It's similar to the IF AND ELSE statements that we use in excel statements. Imagine a few of these scenarios:  
  • Discount 20% on the total transaction price when more than five items are ordered.
  • Apply a discount of $10 for red shirts and $5 for yellow ones.
  • Set a 5% deduction when the total number is 20,000. Let's break down one of these examples.  Imagine a scenario where a company has decided to give a 20% discount from the total price on orders of more than five shirts. 

Let's break down one of these examples. Imagine a scenario where a company has decided to give a 20% discount from the total price on orders of more than five shirts. When the customer orders from the T-shirt Order Form, they will include the total number of shirts they want along with the respective color.  




By answering the question "Enter the number of shirts you like to order" with five or above, the total price of the purchase will automatically be reduced by 20%. 


To do this, the form owner should set up the conditional formula as follows:




Over to you! 
Making your user's experience a priority is smart, but when you can get your internal management sorted too, it's a jackpot!  Worried about how to get started? Read our detailed help guide here. Once you get a hang of it, start creating conditional formulas for your forms, and let us know how you are enjoying it in the comments below! 

Until next time, 
Prasana 


To get updated every fortnight on useful form tips, click follow under our community learning series.















                            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

                                        • 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
                                        • Introducing Auto-Trash Submissions!

                                          Hello form builders! Are you tired of sifting through and deleting form submission data? Try out the latest addition to Zoho Forms: Auto-Trash Submissions. This new feature is designed to help you control and manage data collected through your forms.
                                        • 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


                                        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 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

                                                                    





                                                                    




                                                                        Design. Discuss. Deliver.

                                                                        Create visually engaging stories with Zoho Show.

                                                                        Get Started Now