Zoho Creator mastery isn’t just about building apps—it’s about knowing when and why to use specific features. In this session recap, we cover best practices for UI/UX, dynamic filtering, exporting data, and custom scheduling, using examples like hospital management systems.
1. Improving Forms for Better User Experience
The Problem: Bloated Forms
Large forms—like a patient intake form—can easily hit 50–60 fields. That creates poor user experience for patients or nurses entering data.
Solutions:
Lookups: Split forms into smaller ones (e.g., Patient Info + Insurance Info) and link them with lookup fields. This keeps data cleaner and analytics easier.
Multi-Part Forms (Show/Hide Sections): Use radio/dropdown fields to display sections conditionally. It feels like a step-by-step form while still storing data in one place.
Key Takeaway:
Use lookups for relational data and show/hide sections for user-friendly, single-form experiences.
2. Handling Multiple Files Efficiently
The Problem:
Uploading multiple files (X-rays, MRIs, lab reports) isn’t practical with five separate file fields.
Solutions:
Sub forms: Let users add as many file rows as needed, each with descriptions.
Lookups for Many-to-One: Store files as separate records linked back to patients, making them easier to reuse in other forms, workflows, or analytics.
Key Takeaway:
Sub forms = keep everything together.
Lookups = reuse data across the app.
3. Adding Dynamic UI with Notes & HTML
Sometimes native form fields aren’t enough.
Note Fields: Accept Deluge + HTML/CSS, letting you display dynamic content like patient photos or info boxes.
HTML Snippets on Pages: Embed reports/forms in a snippet, then apply custom CSS for advanced UI, such as multi-part forms or styled dashboards.
Key Takeaway:
Note fields + HTML snippets = endless UI flexibility without external tools.
4. Smarter Filtering with Functions and Page Variables
The Problem:
Default filters are limited (e.g., show only records assigned to current user). But what if you want nurses to see all patients in their department?
Solutions:
Functions in Filters: Write Deluge functions to fetch related data (e.g., department via logged-in user) and use that for filtering.
Page Variables: Run one backend function on load, then share its result across multiple dashboard components—fewer API calls, more efficiency.
Key Takeaway:
Don’t duplicate logic. Centralize it with functions and page variables for reusable, scalable filters.
5. Exporting Data as Professional PDFs
Options:
Record Templates: Export multiple records with consistent layouts.
Canvas: Drag-and-drop PDF builder for single-record detail views.
Zoho Writer Merge: Build professional documents (e.g., patient brochures), merge fields from Creator, and auto-store or email PDFs.
Page Exports: Export dashboards directly as PDFs.
Key Takeaway:
Start with Record Templates/Canvas for quick needs. Use Writer for automation and branding.
6. Custom Scheduling Beyond Dates
The Problem:
Default schedules trigger only on fixed dates. What if patients need different intervals (e.g., bi-annual vs. every two weeks)?
Solution:
Create a Schedule Form linked to your main form.
Run workflows that auto-generate new schedules (e.g., add 30 days for each checkup) until marked complete.
Key Takeaway:
Think beyond “one date field.” Use linked forms + workflows for flexible, recurring scheduling.
