Plan an Application | Applications | Zoho Creator Help

Plan Before Creating an Application

It is essential to know the purpose for your database or the problem you want to solve using your application. You must consider the following points before you start creating an application.

  1. What information do you want it to capture maintain? For example, “To track my orders” , “To manage my inventory”, etc.
  2. Classify the information to be stored into different categories. For example, a database meant to track orders will store data such as "Order", "Quantity", and "Amount". A database for inventory details can record details such as "Product", "Product Type", "Quanity", and "Stock Left". Each individual data entry then becomes a field.
  3. Try to distribute the data into as many fields as possible. For example city, state, country and code to collect an address. This makes it easier to perform Data Access actions such as Update and Fetch because of the availability of multiple fields.
  4. Based on the fields to be created, group fields containing similar data into one category. This category becomes a form. Note down the fields that fall in one category. For example,
     Customer Form Order Form    Invoice Form Product Form
     First Name Customer ID Invoice ID Product category
     Last Name Order  Product ID Product ID
     Phone Number QuantityCustomer ID Unit Price
     Address Total Amount Paid Discount
     Customer ID Invoice ID Order Date
  5. In the table displayed above, try to match the different fields and see if any relationship can be created. Try to link pairs of match field from one form to match field of another form. For example,"Order" contains the ordered products and "Products" contains the products that can be ordered. You can create a relationship between the "Order" field and "Product" field so that "Order" will refer to the product list from the "Product" field. 
  6. Similarly, Customer ID field in Customer Form and Order Form. Invoice ID field in Order Form and Invoice Form. Product ID field in Invoice Form and Product Form. The Customer ID field will store the customer details in the Customer Form and can be looked up from the Order Form to fetch the customer's details. The Invoice ID field in Order Form generates the invoice ID of the order and can be looked up from the Invoice Form to fetch the details of the order. The Product ID field stores the Id of the products in the Product Form and can be referred from the Invoice Form as well.
  7. Such relationship between related fields across forms helps avoid data duplication and reduces the complexity of the application. Once the database has been planned according to your requirement, you can get started with creating an application.
Also watch the video "Planning Apps" to know more about planning applications for your business.




    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • FAQs: Creating an Application

                                                                                                                This page offers insights on creating applications from scratch, the steps involved in creating an app, exploring different components of an application and deluge, importing data and the limitations involved. How to create an application? Locate and ...
                                                                                                              • Manage Application Summary

                                                                                                                The application summary page is a cumulative view of the application in Zoho Creator. This page serves as a common navigation point to branch out into various modules and perform actions relevant to those modules from here, and view the details ...
                                                                                                              • Creating and managing apps

                                                                                                                This help page is for users in Developer Console version 6. If you are in the older version (Developer Console 5), click here. Know your Developer Console version. 1. What does this page cover? This page will help you get started with understanding ...
                                                                                                              • Understand Application

                                                                                                                An application is built by an app owner to collect data from users. The first step in creating an application is to set up an interface to collect data. This interface is called a form. A form is the component of your Zoho Creator app that enables ...
                                                                                                              • Create New Application

                                                                                                                This document provides a brief understanding of how creating an application is different in Creator 6 from Creator 5. Current: In your existing creator account, you will be able to create an application that enables you to collect and manage data ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources