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









                                                                                                          • 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

                                                                                                            1. What does this page cover? This page will help you get started with understanding the basics of creating an application using various app components. Before proceeding, feel free to learn more about Developer Console. 2. Availability Only the ...
                                                                                                          • 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