Auto-Generate & Update Asset Serial Numbers using a custom function (Assets Module)

Auto-Generate & Update Asset Serial Numbers using a custom function (Assets Module)

Hello Team,

I’ve been working on a script to automate one of our processes in Zoho FSM, and the core functionality has been successfully implemented. However, I’m encountering an issue related to serial number allocation, which is not working as expected.

Below is a detailed explanation of how the script functions, along with an example of the issue I’m facing.

Script Functionality

The script handles two scenarios based on the asset type:

  1. If the Asset Type is "Product":

    • It updates the Asset Name field (API Name: Name) and the Description field (API Name: Description).

    • The format used for the asset name is: SKU (from Services and Parts module (API Name: SKU)) + Serial Number (API Name: GIAI) + Product Name (from Services and Parts module (API Name: Name)).

    • The description field is updated with the name (API Name: Name) from the Assets and Parts module.

  2. If the Asset Type is "ProCare Contract":

    • It performs the same field updates as mentioned above.

    • However, in this case, the serial number is generated automatically for the specific asset type through the workflow.

    • The functionality is working, but the serial number allocation is incorrect. This is the main issue I'm facing.

Issue – Incorrect Serial Number Allocation

Although the logic is mostly working, the serial numbers are not being assigned in a sequential or consistent manner.

Expected Behavior:

For example:

  • Asset A → Created Time: 2025-04-20 19:39 → Serial Number: 0001

  • Asset B → Created Time: 2025-04-20 19:40 → Serial Number: 0002

  • Asset C → Created Time: 2025-04-20 19:41 → Serial Number: 0003

Actual Behavior Observed:

  • Asset A → Created Time: 2025-04-20 19:39 → Serial Number: 0003

  • Asset B → Created Time: 2025-04-20 19:40 → Serial Number: 0002

  • Asset C → Created Time: 2025-04-20 19:41 → Serial Number: 0001

As you can see, the serial numbers are not aligning with the asset creation timestamps.

I’ve attached the script I developed for reference. I would greatly appreciate it if someone could help me resolve this issue.

For your reference, I’m currently using the Zoho FSM Professional subscription.

Thank you!




        • Recent Topics

        • Kaizen #263: Using Zoho CRM Skill to Build Widgets

          Hello everyone! Welcome back to another exciting Kaizen post. In the previous Kaizen posts, we introduced the zoho-crm skill.md and explored how it can help with Zoho CRM APIs, Client Scripts, complex COQL queries, and Skill to build Queries. In this

        • Extracting/automating sign link

          Is there a way to copy the sign link to a specific recipient? And also, is it possible to automate the sending of the link to myself or external automation tools? In more details: It can sometimes happen that the recipient email is spelled wrong/unavailable

        • Zoho notebook No login

          Hello Team, I recently downloaded and installed the latest version of zoho notebook for windows. But I am not able to login without providing any sso or email address. Did you removed the no login feature for this app? This is just a windows app. can

        • Search is completely broken for PC

          I go to note, try to search for "mtga" and it shows 702 results (it's a big note), highlights all letters "m" and I can't find anything. Same for "gathering" - it thinkgs I think only for "g". Looking for "zoho" shows as if I searched only for "z". Using

        • Generate a link for Zoho Sign we can copy and use in a separate email

          Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to

        • Behind a great customer experience is a team

          Hi everyone, October is here, and the first week marks the Customer service week. Each year, we thank our customer service professionals. Service professionals are all around us, even in our own workplaces: They handle essential administrative work like

        • What's New - August and September 2026 | Zoho Backstage

          Hello everyone, August and September bring a fresh wave of intelligence to Zoho Backstage. AI takes the spotlight with tools that help you create content, support attendees, and manage how AI fits into your events. Alongside AI, we’ve refined email communication,

        • Images Not Displaying Properly in Zoho Desk

          Hi, We are experiencing an issue with image rendering in Zoho Desk, affecting both incoming and outgoing emails. Images embedded in email conversations are not displaying properly. Instead, we see broken image icons or empty placeholders where the images

        • Announcing the new SKILL.md for Zoho CRM and the updated OAS repository!

          We are introducing a new zoho-crm skill to make working with Zoho CRM Developer tools (like APIs, functions, widgets, client scripts, queries etc) easier and faster, with the help of AI in your preferred AI harness like Claude Code, Codex, Cursor, VSCode

        • Zoho Projects - Has something changed regarding to linking Projects and Deals via the API?

          I am trying to link Zoho Projects to Deals in CRM using the API, but each time, the Deal Contact is added as a Client user and receives an email invite asking them to join the organisation. These are internal projects and the customer should not have

        • How long does it take to review campaigns?

          Hello Zoho, i scheduled my campaigns yesterday afternoon and it has been under review for over how many hours and those campaigns were supposed to be out yesterday so new ones can go out today. Is there something i'm doing wrong?

        • Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

          Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"

        • Zoho Community Digest - September 2026 | Part 4

          Hi everyone, and welcome back! The final week of September brought a revamped Books integration in Zoho CRM and Zoho Key Service for LLM access without API keys, Zoho Creator's audit trail becoming a full enterprise-grade auditing system, and Zoho One

        • Automate weekly reports from Channels | Zoho Cliq AI use case #01

          Scrolling endlessly through numerous threads in a Cliq channel and manually counting how many have been closed, how long people took to reply, and who actually participated can be tedious. After 20 minutes, you might have a number that no one can verify.

        • Zoho Tables is now part of Zoho One!

          Hey everyone! We've got some exciting news to share. Zoho Tables is now included in your Zoho One subscription at no extra cost. If you're already on Zoho One, head to your app list, add Zoho Tables, and get started right away. You don't need a separate

        • [Webinar] Zoho CommunitySpaces MCP

          New to MCP, or just exploring what's possible? Join us for a webinar on Zoho MCP and your community. We'll show you how Zoho CommunitySpaces and Zoho MCP work together, what your AI co-host can do inside your community, and how to get started. Register

        • How can I show an uploaded image larger/full size in a Zoho Forms response PDF?

          Hi,  I noticed that in a response PDF for Forms, the uploaded image is shown in a tiny box as seen in my screenshot. Is there any way I can make that appear larger in the response PDF? thanks.

        • Live connection to DS files in Zoho Creator / ChatGPT

          As an idea, we are using ChatGPT to build with Zoho Creator (outside of Zia), which is works brilliantly to assist write deluge, provide test suggesitons etc. Currently we are uploading the DS files which are very point in time, it would be great to have

        • Meet PageHealth by Zoho PageSense: a free way to find out what's holding your page back

          We all know the feeling. You've spent days tweaking headlines, moving buttons, and rewriting copy, and you're still not sure why visitors aren't sticking around. Revamping your website is hard, and figuring out what's actually getting in the way is even

        • Task Module quick create settings

          Hello, requesting the Task module receive a quick create customization settings. We have added custom fields and have to select "More fields" at the bottom of the pop-up to access the custom fields.

        • Your employees changed departments. Did your IT systems notice?

          An employee joins your Marketing team. HR adds their details to the organization's user directory. The IT admin, in turn, creates their Zoho One account, assigns the required applications, adds them to groups and provides access based on the organization's

        • AI Calling

          Hi, does anyone have experience or any thoughts on AI Calling. Getting AI to make calls on behalf of your company. We are looking into it, but are finding it difficult to get info and providers that can assist.

        • Email Forwarding to Zoho Desk Failing After Migration from Gmail to Outlook (Microsoft)

          We recently migrated from Gmail to Microsoft Outlook. Since the migration date, emails sent by our customers are no longer being received by Zoho Desk. I tried setting up the email forwarding rules in Outlook similar to what we had in Gmail, but it still

        • Record positive and negative bank transactions in the same expense account

          Hello, I hosted a promotional event and paid a vendor $600 for food catering (bento boxes). Twenty people attended the event, and each person paid $30 for a bento box, resulting in 20 separate $30 transactions deposited into the bank. I coded the $600

        • CRM Address Field - States with Countries in brackets

          Hi, Could you please remove the country in brackets from the Global State List, or at least allow us to edit these entries? It looks like the brackets were added during the initial data population, perhaps by someone building the list in a spreadsheet

        • Different Report sharing filters within same Dashboard

          I have a question about sharing filters for a dashboard which contains separate reports built from the same query. Below are the pieces of the puzzle: - “Sales Query”: line-level query containing sales for a team of 5 sales reps; there’s no need for the

        • Make Your Workflows Smarter with Zia Agents

          Hello, Enterprise Support Community, Workflow rules can now go beyond predefined actions. Zia Agents can now be invoked directly from workflow rules in Zoho CRM, allowing you to bring contextual, AI powered actions into your automated processes. Choose

        • How can I add a Custom Field (or Customer_name) to a picklist?

          Our workflow is Shopify-->SO -->Picklist-->Package-->Shipment. We would like to have the Picklist template to include a custom field "Customer_Notes" (we have created this field already). This way we get alerted when a customer has notes on their account.

        • DYK 14: Create Tasks with AI

          Did you know AI can suggest tasks within your Zoho Projects portal? Breaking a project into clear, actionable work items takes time and manual effort. Especially when the same team handles both planning and execution. AI task suggestions in Zoho Projects

        • #11 Nithya's First Overseas Client

          Nithya designs for clients in three countries and has never met any of them. Her first overseas invoice took a full evening. The second took four minutes. The difference was not a clever tax trick. She stopped treating every international customer as

        • Other languages in Schedulers (Zoho Books)

          Hello everyone, currently we have create functions in other languages, like nodejs etc but on schedulers we can use only deluge.. Are other languages on schedulers roll out? Kind regards, Sakis Oikonomou

        • New in Office Integrator: Extract data from images into your spreadsheet

          Hi users, We are pleased to introduce the Data from Picture feature in Zoho Office Integrator's spreadsheet editor. It intelligently detects and organizes text and numbers from any image into structured cells using OCR. With this feature, users can turn

        • Edit PDFs using Zoho PDF Editor

          Hello users, In a previous article, we covered the organizing capabilities of Zoho PDF Editor. Here, we'll provide a quick recap of its editing features, including a few new additions. A few highlights of Zoho PDF Editor's editing capabilities: Add and

        • Partner with HDFC And Sbi Bank.

          Hdfc and sbi both are very popular bank if zoho books become partner with this banks then many of the zoho books users will benefit premium features of partnered banks.

        • Multiple subscription plan line items in Zoho Billing quotes

          I run an IT company and sell a lot of licences. A client might have multiple subscription plans including software licences in different categories. A client might have Microsoft licences, antivirus licences, web hosting and maintenance package services.

        • Mail Merge templates in Sandbox

          Rolled out for all DCs Hello everyone, You can now create and test Mail Merge templates directly in Sandbox, making it easier to validate document generation without affecting your live organization. Why this matters Mail Merge templates are often used

        • Dashboard Table of “My New Work Orders” Changes View

          Hi FSM Team, We noticed an inconsistency with the Dashboard Table of “My New Work Orders.” Initially, the table is configured to use the “My New Work Orders” view. When we go to the Home page, the table displays a different set of records. When we return

        • Tips & Tricks #6 | Zoho Vault: Audita actividad, Gestiona accesos, Comparte credenciales & mucho más.

          ¿Sabías que Zoho Vault puede hacer mucho más por la seguridad de tu equipo? Las contraseñas forman parte del día a día de cualquier persona y organización. Aplicaciones, herramientas internas, cuentas de clientes, servicios externos, plataformas de marketing,

        • Inquiry Regarding Customer Hierarchy & Sub-Customer Creation via Zoho API

          Dear Zoho Support Team, Our mutual client has requested support for implementing the Customer Hierarchy (Parent/Sub-Customer structure) within our existing workflow. At the moment, all invoices are being created in Zoho under the main (parent) customer

        • Which Zoho CRM tasks would you want an AI assistant to handle?

          I’ve started delegating my Zoho CRM work to AI – and many tasks now take me half the time. It has been so useful that we’re now working to make it available to everyone. Instead of clicking through records and tabs, I simply describe what needs to be

        • Next Page