My Works

 When working with business applications, it’s often necessary to generate unique identifiers for records such as requests, invoices, or assets. While Zoho Creator provides a default auto-number field, it doesn’t always allow the flexibility businesses need—such as custom prefixes, ranges, or increments. Inspired by the Number Series functionality in Microsoft Dynamics 365 Business Central , I developed a custom auto-numbering system in Zoho Creator that gives full control over serial number generation. Why Custom Number Series? Different organizations have different requirements for numbering their records. For example: A Prefix to represent the type of record (e.g., REQ_ for requests). A Starting Number to decide where the series begins (e.g., start at 1000). An Increment to skip numbers in a defined pattern (e.g., +1, +5, etc.). An Ending Number to enforce a limit (e.g., stop at 9999). This flexibility makes it easier to manage records, avoid duplicatio...

Attendance tracking is a core part of running any business — but let’s be honest — most attendance systems are either too rigid or too plain . I wanted something different: ✅ A modern-looking interface ✅ Real-time updates to Zoho Creator ✅ Visual feedback with charts ✅ Simple controls to mark employees Present or Absent ✅ Smart logic to prevent repeated updates within 9 hours So, I built a custom Zoho Creator Widget that does exactly that. In this post, I’ll take you through the entire step-by-step process — from fetching data to updating records — so you can implement it in your own Creator apps. 1. Tools & Libraries Used Before we dive in, here’s what powers the widget: Zoho Creator Widget SDK v1 – to interact with Creator data ( getAllRecords , updateRecord ) Chart.js – to visualize attendance with a pie chart HTML, CSS & JavaScript – for structure, styling, and logic <script src="https://cdn.jsdelivr.net/npm/chart.js"></scr...