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.




    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







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • 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 ...
                                                                                                  • 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 ...
                                                                                                  • Modes of an Application

                                                                                                    Overview Zoho Creator has two modes through which you can establish an application from start to finish. You can create an application from scratch or from a template and customize it according to your needs in an app-building space. During that ...
                                                                                                  • Understand application settings

                                                                                                    This help page is for users in Creator 6. If you are in the older version (Creator 5), click here. Know your Creator version. The Settings section allows you to make application level configurations. You can view and change information about and ...
                                                                                                    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