Field Not Updating in FSM Script - Service and Parts module.

Field Not Updating in FSM Script - Service and Parts module.

Dear Team,

I am reaching out regarding a script I have implemented in Zoho FSM to automate the calculation of the End of Service date based on the End of Sale date in the Service and Parts module.

Overview of the script:

  • Fetches the End_of_Sale__C and End_of_Service__C fields from the Service and Parts record.

  • Checks if the End_of_Sale__C date is valid.

  • Calculates a new End_of_Service__C date by adding 5 years to the End of Sale date.

  • Updates the End_of_Service__C field only if it is empty or different from the calculated date.

Despite executing successfully, the script does not update the End_of_Service__C field as expected. I would greatly appreciate guidance on why the update might not be taking effect and any recommendations to ensure the field updates correctly.

Script:

// Fetch fields from input
var_End_of_Sale = service_and_part.get("End_of_Sale__C");

// Check if End_of_Sale date is valid
if (var_End_of_Sale != null && var_End_of_Sale.isDate())
{
    // Calculate End of Service = End of Sale + 5 years
    var_New_End_of_Service = var_End_of_Sale.addYear(5);
    var_New_End_of_Service_Str = var_New_End_of_Service.toString("yyyy-MM-dd");

    var_Update_Map = Map();
    var_Update_Map.put("End_of_Service__C", var_New_End_of_Service_Str); 

    var_Record_Id = service_and_part.get("id");
    var_Update_Response = zoho.fsm.updateRecord("Service_And_Parts", var_Record_Id.toLong(), var_Update_Map);
}

Thank you for your assistance.

Best regards,
Chethiya

    Nederlandse Hulpbronnen


      • Recent Topics

      • Global Subforms

        Hey 👋🏼 We have a few subforms to calculate detailed offers for customers of car dealerships. These subforms are used in different modules and we need to create snapshots of them in different cases for documentation reasons. For example, an approved

      • Add Subform Field based on Record Field

        Hi All, I am struggling with finding a solution that can populate a subform field based on an existing field on the record. Use case is I have added Current Exchange Rate on a quote as a custom field, I then have a subform with Quoted items that include

      • Where are scheduled emails stored?

        After you schedule an email to go out through the CRM, how do you go about changing that scheduled email? Or even where can I see the list of emails scheduled to go out? They are not listed in my Zoho Mail account in Outbox which has been the only answer

      • Sheets are unbearably slow

        I'm doing some extremely simple sheets. Like 2 sheets each with 200 lines and 10 columns and a simple vlookup. ABSOLUTLY can not wait 20 secs to flip between sheets. What's up? anyone else having this trouble? Been this way for about 4 days now. Both

      • Rich text support for Notes

        Hi! Is there an opportunity to add Rich text field to Zoho CRM? We need a field that can save the HTML-formatted text in it. It's crucial for our business. Moderation Updates: The votes for supporting Rich Text for multi-line fields is captured in the

      • Colour Coded Flags in Tasks Module List View

        I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due

      • Notes formatting

        I see that I can format this idea proposal with bold, underlines , colors, and dot points even multi-level dot points However, I cannot do the same for notes in leads, contacts, potentials, etc. in CRM. This makes notes very difficult to read. PLEASE

      • Linking records from different modules

        Hello, Is there a way to link customer call records from the 'Calls' module to specific account and contact records? I've realized that our customer meeting reports are linked to both the contact and the Account records, in related list fields but the

      • Quickly send emails and sync conversations with custom email addresses in CRM

        Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all

      • Business_hour (by minute)

        Hi Zoho Team business_hours formula can only give the difference of time or day between two dates. (In the time calculation, it can only calculate the exact time. For example, it can give the difference between 16:30 and 16:55 as 0.) I want to calculate

      • At transaction level Discounts for Zoho books UAE version

        Dear Team, Please add transaction level Discounts for Zoho books UAE version. I have been requesting Zoho team past 3 years, Transaction level Discounts is a mandatory option required for our business needs. Zoho books Indian version has the option then

      • Where do Review Questions appear on the Performance Assessment?

        Hi, I want to create a Performance Assessment including only compentencies with a multiple-choice format, and a final open-text question after the competencies asking for justification of the previous objective questions. Can Review questions work for

      • Exit details not linked on employee profile

        Dear Team, The exit details that were filled in are not appearing in the employee's profile, and it seems the data is missing entirely. Please advise on how to proceed. Regards, Preetika

      • Client Script: Any plans to add support for multi-select field with onChange

        Client Script is fantastic and the documentation lists multiselect form fields as unsupported. Just wondering if there are any plans to make this a supported field. https://www.zoho.com/crm/developer/docs/client-script/client-script-events.html 2. Field

      • Versioning of Quotes and Invoices

        Would be nice if Zoho Invoice would offer the feature of saving all versions of a quote or invoice during the process - so if quotes or invoices get changed over time - a version of the old ones exist and can be reviewed and reactivated if necessary ... ;)

      • Banking - User Roles - Access To Single Bank Account

        Hi, We have different locations with each location having a specific bank account for Expenses/Etc... Can you please confirm on whether it's possible to give a user (non accountant), specific access to only a single bank account as opposed to all accounts

      • Does Zoho US Payroll now support employees in multiple states?

        Does Zoho US now support having employees in multiple US states? I looked at the site and can't find and of the restrictions on multiple states anywhere.

      • Help! Unable to send message

        Help! Unable to send message I have this email sales<at>teadvancehydraulics<dot>com, but I couldn't send outgoing email. (Reason:554 5.1.8 Email Outgoing Blocked.) Can you please help?

      • CRM Mail merge issues

        How do you configure the page on mail merge, from ZCRM??. I have written a template and structured the filters. the print preview is on one page.  I merge the document.  The merge reformats and then the document formatting moves higher and higher until by page 5 you have two half letters!!!  Very frustrating. Does anyone know if I need to insert a page break or how to correct /format this so it doesn't happen?? Help.  L

      • New notecards not syncing across devices

        Hello. I just noticed this problem happen recently. A new note being created on one device is not appearing on a different device, even though they're supposed to be synced with each other through setting it up on your account. I don't know if there's

      • Power of Automation :: Auto update a custom field based on Parallel transition under Blueprint

        Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate

      • Push error with Zoho Books and Zoho CRM

        I have successfully linked Books and CRM but I have some push errors with the following message: "The customer associated to this record is not linked to module chosen in the current contact sync configuration." I am unable to work this out, could you help please.

      • Sales Tax Rates

        Why is the Tax Customization feature limited to 2 decimal points? This issue has been mentioned several times over the last few years but it has not been changed. From a programming stand point, this should be relatively easy. Third decimal point capabilities

      • Feature Request: Ability to copy notecards to Windows desktop

        Hello, Please consider adding the ability to copy notecards to Windows desktop. Thanks!

      • Add RSS Feed Feature to Zoho Desk Communities and Knowledge Base

        It would be very useful to be able to get updates on content which is relevant to me from Zoho Desk Communities through RSS and also push my own Zoho Desk Community content to other platforms through RSS.

      • Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed?

        Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed? If not, can anyone share a work-around that could help me get an RSS feed for individual category forums?

      • Add customer to account based on domain name.

        I generate reports based on a the account field, i.e. companyX. In GoToAssist, my last provider, there was an option to automatically assign new ticket creators to a company (or account) based on their domain name. So for example, if a new employee creates

      • Zoho One Apps is not populating once clicked

        Hi Support, The Apps Menu button (corner right next to my profile) is not loading. It keeps flashing but nothing is showing up. When I type quick in the search bar to locate quickbooks, it continues to flash with no apps shown. Thanks

      • Tablet Pencil + Fillable Form

        Hi There, I just started using Zoho Writer Forms for our team on iOS. I noticed that some functions support 'scribble' or tablet pens and some do not. Is there a function I am missing where any text field can support 'scribble' or handwriting/printing

      • CRM API v2 AdWords GCLID Parameter

        Hi, I'm using AdWords Integration with Zoho CRM using a third party webform and can't manage to insert the "gclid" parameter via Zoho CRM API Leads endpoint (version 2). I already checked the following articles: 1. https://www.zoho.com/crm/help/google-adwords/configure.html#Third_Party 2. https://www.zoho.com/crm/help/api-diff/ Form submission works fine. On server side the gclid is correctly included in API request. The Lead is created successfully. All fields (system and custom) are populated correctly

      • Zoho Writer can be slow to load sometimes

        Hello! I've noticed that whenever I restart my web browser (Firefox 2) and try to open Zoho Writer, it always shows the login screen first, even if I have an URL direct to the writing interface itself. I don't recall it doing this in an older version, so why does it happen now? Also, sometimes when starting Zoho Writer, it gets stuck: I see the word "Loading..." come up and the page half-extends but never fully loads. I have to refresh the page totally in order to get it to work properly, but doing

      • Mass email processes

        Hello, I'm looking to send about 7k emails out. I have them in CSV format with most being people I have previously communicated with. My questions are: * What is the process for using Zoho to send this group of emails out utilizing Microsoft 365 ? I'm

      • Zoho WorkDrive 5.0 : d’un outil vers une solution intelligente de gestion de documents

        Dans un monde de plus en plus orienté vers les données, les entreprises doivent non seulement gérer une masse croissante de données non structurées, mais aussi en extraire des informations stratégiques. L’intelligence de contenu répond à ce besoin en

      • Weekly Tips: Avoid any email mishaps using Zoho Mail's Email Recall

        Let's say you have just sent an important email to a recipient with an important attachment. Moments after hitting send, you realize the attachment is outdated and missing some critical updates. Sending another corrected version of the email without addressing

      • Messaging

        Whenever i send a mail to someone, it come with the my name of the company, instead of the name of my company.

      • Can't receive emails. MX Records are good apparently.

        Hello, For the past couple of days I have been able to send but unable to receive email through Zoho Webmail. I went into Admin Console and it says: MX Records are configured correctly and Your Domains MX Records are pointed to Zoho. Could you please

      • How can I customize my sales pipeline in Zoho.com CRM ?

        Hi to all intelligent community members I’m Namrata Hinduja Geneva, Switzerland, new member in Zoho.com and in this community. Please resolve my query - How can I customize my sales pipeline in Zoho.com CRM to track the progress of deals more effectively?

      • Error when adding phone number

        Hi Team, I'm getting an error when trying to authenticate using my phone, please see image attached. thanks, Jose

      • Zoho Projects iOS app update: Revamp of toast message and an option to view the whiteboard images

        Hello everyone! In the most recent Zoho Projects app update, we have brought in support for the following features: 1. Toast message revamp: We have enhanced the toast message banners to a bolder interface. You will now be updated on the progress of uploads

      • Send a new invoice data from Books to local certified solution via API json due local compliance

        Greetings, I hope you are doing well and staying safe. Due to local compliance regulations, I am required to issue invoices exclusively using locally certified software, which Zoho Books is not. However, we would like to continue using Zoho Books, so

      • Next Page