How to Structure Data in Zoho Creator Applications

How to Structure Data in Zoho Creator Applications

Data structure is undoubtedly one of the most critical pillars in application development within Zoho Creator. Well-structured projects scale easily, enable more robust automations, and drastically reduce rework. Poorly modeled applications, on the other hand, quickly become difficult to maintain, integrate, and evolve.

In this article, I will explore best practices for structuring data efficiently in Zoho Creator, with an architectural perspective suited for medium and large-scale projects.

Why is data modeling so important?  

Before diving into techniques, it’s important to understand the impact:

  • Facilitates automation

  • Improves application performance

  • Simplifies integrations

  • Reduces errors and inconsistencies

  • Increases solution scalability

A well-designed data structure prevents your application from becoming a problem instead of solving one in the medium term.


1. Think in terms of entities, not forms  

A common mistake in Zoho Creator is modeling directly around forms.

Wrong mindset:
“I need a travel request form.”

Correct mindset:
“What are the entities involved?”

Example of entities in a corporate travel system:

  • Employee

  • Trip

  • Cost Center

  • Approval

  • Vendor

  • Expenses

Each of these entities will become a form within the system.


2. Avoid data redundancy  

Avoid repeating information across multiple places.

What NOT to do:

  • Employee name repeated in multiple forms

  • Duplicate vendor data

Correct approach:

  • Create a “Employees” table

  • Create a “Vendors” table

  • Use lookup fields for relationships

Benefits:

  • Centralized updates

  • Fewer inconsistencies

  • Better data governance


3. Use relationships correctly (Lookup + Subform)  

In Zoho Creator, you have two main mechanisms:

- Lookup (1:N relationship)
Use when:

  • A record belongs to another

  • Example: A Trip belongs to an Employee

- Subform (1:N within the same record)
Use when:

  • Data depends directly on the parent record

  • Example: Multiple expenses within a trip

Rule of thumb:

  • Lookup = relationship between entities

  • Subform = operational detail dependent on the parent record


4. Separate master data from transactional data  

This is one of the most important practices in corporate projects.

Master Data:

  • Employees

  • Vendors

  • Products

  • Cost Centers

Transactional Data:

  • Requests

  • Orders

  • Trips

  • Expenses

Never mix both in the same form.


5. Avoid manually entered calculated fields  

If a value can be calculated, it should not be manually entered.

What NOT to do:

  • “Total Amount” field filled manually

Correct approach:

  • Calculate using Deluge or formulas

This prevents human error and ensures consistency.


6. Think about scalability from the start  

Even if the project starts small, think big.

Key questions:

  • Does this model support data growth?

  • Will I need to integrate with other systems?

  • Can this data be reused in other modules?

Avoid “flat” structures (too many fields in a single form).


7. Create naming conventions  

Standardization is essential in larger projects.

Suggested patterns:

  • Forms: frm_Trips, frm_Expenses

  • Fields: travel_date, total_amount

  • Functions: fn_calculate_trip_total

This improves maintainability and team collaboration.


8. Plan governance and access control  

Data structure directly impacts security.

  • Who can see what?

  • Who can edit?

  • Is there segregation by department?

Use:

  • Roles

  • Form-level permissions

  • User-based filters


9. Avoid “workarounds” with generic fields  

Fields like:

  • “Observation 1”

  • “Extra field”

  • “Free text for anything”

are clear signs of poor data modeling.

If the data is important, it deserves a structured field.


10. Document your structure  

Corporate projects require documentation.

Include:

  • Entity diagrams

  • Relationships

  • Business rules

  • Critical fields

This facilitates onboarding and system evolution.


Example of a simple architecture (Zoho Creator)  

A well-structured model for a travel application:

Employees (Master)
Cost Centers (Master)
Trips (Transactional)

  • Lookup: Employee

  • Lookup: Cost Center

Expenses (Subform or separate Form)
Approvals (Workflow + history)


Conclusion  

Structuring data correctly in Zoho Creator is not just a technical concern — it’s a strategic decision.

Well-modeled applications:

  • Scale easily

  • Integrate better

  • Require less maintenance

  • Deliver more business value

If you want to move beyond the operational level and act as a true solution architect in the Zoho ecosystem, mastering data modeling is essential.
    • Recent Topics

    • Sync your CRM Tasks with Zoho Projects

      Zoho Projects integration with Zoho CRM helps you manage your tasks more efficiently. You can create all project related activities right inside your CRM using this integration. Create new portal or associate an existing portal, add projects to the portal,
    • Zoho CRM strips whitespace in text fields

      When editing field text with multiple spaces: CRM - both UI and API trim / compress the whitespace to a single space when saving: Is this known / expected / documented behaviour?
    • Custom Button makes scroll bar go down in report

      I have a report with a Custom button called Completed. A colleague mentionned to me that when he pressed this custom button it scrolled down the page which is annoying since he want to stay at the same space on the repoort. There is no reload linked to
    • Quickbooks Integrations Stopped Working

      All of our Quickbooks integrations have stopped working. I am checking in to see if: a) this is a known issue b) if anyone else is having this issue. As usual, Zoho support is unavailable.
    • Incorrect Functioning of Time Logs API (Version 3)

      We need to fetch the list of time logs for each task for our company internal usage. We are trying to achieve it by using the next endpoint: https://projects.zoho.com/api-docs#bulk-time-logs#get-all-project-time-logs Firstly, in the documentation the
    • Zoho CRM Queries Now Support Databases and Cloud Data Sources

      Hello everyone! We're thrilled to announce a major enhancement to the Queries feature in Zoho CRM! Queries now support a broader range of external data sources, allowing you to fetch live data and combine it with CRM records, all using a unified query
    • Dynamic image in form works in the app but not on the customer portal.

      img = frm_Fichas[ID == input.Nombre].Foto; imgno = Nophoto[ID2 = 1].Image; if(len(img) > 1) { img = img.replaceAll("/sharedBy/appLinkName/",zoho.appuri); img = img.replaceAll("viewLinkName","Fichas_de_personal_public"); img = img.replaceAll("fieldName","Foto");
    • Uplifted homepage experience

      Editions: All editions. Availability update: 17th February 2026: All editions in the CA and SA DC | JP DC (Free, Standard and Professional editions) 23 February 2026: JP (All Editions) | AU, CN (Free, Standard, Professional editions) 27 February 2026:
    • Approval Workflow for Purchase Orders Abrir

      The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can
    • WeTravel + Zoho CRM Integration - Has Anyone Built a Connector or Extension?

      Hi all, I'm exploring options for integrating Zoho CRM with WeTravel (booking & payment platform for tour operators). Zapier seems to be the common method but seems limited. I'm wondering if anyone in the community has developed a more comprehensive solution,
    • Option in pipeline deal to select which hotel or branch or store if client has more than one local store

      Hi, I would like to know if there is an option in the deal pipeline to select which hotel, branch, or store a deal is related to—if the company has more than one location. For example, I have a client that owns several hotels under the same company, and
    • Undo article like/dislike

      It seems to be not possible to undo your like/dislike for an article. Would be great if you can. Kind regards, Helen
    • Nested notebooks

      Dear Sir/Madam, I would like to know if it is possible to nest notebooks. It would be very helpful when there are too many, as it would improve organization. Thank you for your response. Best regards.
    • Tax in Quote

      Each row item in a quote has a tax value. At the total numbers at the bottom, there is also a Tax entry. If you select tax in both of the (line item, and the total), the tax doubles. My assumption is that the Tax total should be totalling the tax from
    • Dynamically Fetching Lookup Field Display Value

      I have an audit trail form, Audit_Changes, that tracks old vs new values across different forms. For lookup fields, the old/new value is the ID, but I also need the display value. What's a best practice for dynamically fetching the display value of the
    • Stop Scrolling, Start Asking: Meet Zia for Your Files

      Hey everyone 👋 The era of 'scrolling and searching' is officially over. Whether it's a dense legal contract or a long meeting recording, searching for specific details is a massive time-sink. We think you should be able to interact with your files, not
    • How do I open MSG files in Microsoft Word?

      If you want to open MSG files in Microsoft Word is not natively supported, as MSG is an email file format created by Microsoft Outlook. However, there are professional approaches to access MSG content in Word. First, open the MSG file in Outlook and copy
    • Unable to charge GST on shipping/packing & Forwarding charges in INDIA

      Currently, tax rates only apply to items. It does not apply tax to any shipping or packing & forwarding charges that may be on the order as well. However, these charges are taxable under GST in India. Please add the ability to apply tax to these charges.
    • How to add packing & forwarding charge in purchase order & quotation???

      Hello Zoho Team I have just started using Zoho for my company and I wanted to make purchase order. My supplier charges fix 2% as packing & forwarding on Total amount of material and then they charge me tax. For example, Material 1 = 100 Rs Material 2
    • How to create a boxplot chart in Zoho Analytics?

      Hi, I'm looking forward to making a boxplot in Zoho Analytics, either with all my data or with a time segmentation. No documentation or YouTube video explaining that was found. I guess this is a feature gap. How feasible would it be to add this to Analytics?
    • What are the create bill API line item requiered fields

      While the following documentation says that the line items array is requiered it doesn't say what if any files are requiered in the array. Does anyone know? API documentation: https://www.zoho.com/inventory/api/v1/bills/#create-a-bill I'm trying to add
    • Budget function?

      Has there been any progress on the development of a budget function in Zoho Books / Invoice? It's impossible to grow/run a business without some kind of budgeting. If I've missed something, apologies, but there seems little point in using Zoho Books without a budgeting function. Otherwise, I'm very impressed with the Zoho apps and the support. Keep up the great work.
    • Connecting Zoho Inventory to ShipStation

      we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uri
    • Zoho Booking - TIN vs ATIN & ITIN

      Zoho Booking Vendors allows for TAX ID values of SSN, EIN, ATIN an ITIN. There is no option for TIN. What is the method to properly add TIN to the list of taxable values for companies? For reference: Social Security Numbers (SSN) Individual Taxpayer Identification
    • Where is the settings option in zoho writer?

      hi, my zoho writer on windows has menu fonts too large. where do i find the settings to change this option? my screen resolution is correct and other apps/softwares in windows have no issues. regards
    • Using IMAP configuration for shared email inboxes

      Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure
    • When Does WorkDrive integrate with Books?

      When Does WorkDrive integrate with Books?
    • POP mailbox limits

      If I am accessing a remote POP mail server using Zoho Mail is there a mailbox quota for the account or is it all related to my mail account storage limits?
    • Warranty Service and Repair in Zoho FSM

      Hi There, We are a retail store that sells products and also performs installations and repairs. Our field technicians handle this work. Some repairs are covered by manufacturers, who reimburse us for both parts and labour. In these cases, we perform
    • Zoho Sheet for Desktop

      Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?
    • WhatsApp phone number migration

      Hi @Gowri V and @Pheranda Nongpiur, Thanks for implementing the promised enhancements to the integration between Zoho CRM and WhatsApp. The previous discussion has been locked, so I'm opening this new one. I am copying below a specific
    • WebDAV support

      I need WebDAV support so that I can upload/download (and modify) documents from my local file system. Is anything planned in his direction?
    • SPF: HELO does not publish an SPF Record

      I am using Zoho mail. Completed all of the required prerequisites from the dashboard to avoid any issues with mail delivery. But when checking on mail-tester.com getting the following error. Can anyone help me solve this?
    • How do I create an update to the Cost Price from landed costs?

      Hi fellow Zoho Inventory battlers, I am new to Zoho inventory and was completely baffled to find that the cost price of products does not update when a new purchase order is received. The cost price is just made up numbers I start with when the product
    • Price Managment

      I have been in discussions with Zoho for some time and not getting what I need. Maybe someone can help explain the logic behind this for me as I fail to understand. When creating an item, you input a sales rate and purchase rate. These rates are just
    • Regarding the integration of Apollo.io with Zoho crm.

      I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on Google
    • Actual vs Minimum

      Hi all, I am sure I am not the only one having this need. We are implementing billing on a 30-minute increment, with a minimum of 30 minutes per ticket. My question is, is there a way to create a formula or function to track both the minimum bill vs the
    • Generate leads from instagram

      hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to lead
    • Kaizen #234 - Automating Deal Handoff with Zia Assistant API, Workflow, Deluge, and Widget in Zoho CRM

      Hello all! Welcome back to a fresh Kaizen week. In this post, we will explore how to automate the deal handoff process in Zoho CRM using Zia Assistant API + Workflow + Deluge + Widgets. Here’s how the final output looks when a deal is reassigned 1. Deal
    • How do you print a refund check to customer?

      Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.
    • Next Page