Upcoming Updates - February-March 2022

Upcoming Updates - February-March 2022

Hi all,

Greetings from the Zoho Creator team!

A new year is here and we're looking forward to bringing in new features, improving performance, and delivering on all the exciting updates we previously announced.

In this update, we'll go over the:
  • 30 new ready-to-use functions including randomNumber, encoding, and AI
  • Try-Catch, Break, and Continue statements
  • Sorting ability in subform fields
  • Advanced search option in lookup fields
  • Security check for unpublished components
  • Code sign mobile apps in AAB format
  • Enhanced report exporting on mobile
  • Field permissions in pivot reports
  • Invalid parameter validation
  • Enhancements and changes in Deluge
30 new ready-to-use functions including randomNumber, encoding, and AI

One powerful aspect of Deluge is its minimalistic approach to the number of statements required per execution. Some of the features we have in the pipeline are going to help further optimize your Deluge coding experience. We have also supported additional ready-to-use built-in functions and tasks.

randomNumber & other new built-in functions

To the long list of our available built-in functions, we'll be adding the following new functions:

i. Common

Function

Description

Generates a random number from the specified range.


ii. Text functions



Converts hexadecimal to text value.


Converts text to hexadecimal value.


Returns all the characters which precede the first occurrence of the search text in the input text. The search text is not case-sensitive.


Returns all the characters which follow the first occurrence of the search text in the input text. The search text is not case-sensitive.


Replaces all occurrences of the search text with the replacement text. The search text is not case-sensitive.


Replaces the first occurrence of the search text with the replacement text. The search text is not case-sensitive.


Returns a text with the input text repeated for the specified number of times.


Returns the input text with its characters in reverse order.


Checks if all characters in the input text are ASCII.


Removes all the extra white spaces (if any) inserted after the input text.


Removes all the extra white spaces (if any) inserted before the input text.



iii. Number functions



Returns the number equivalent to the hyperbolic tangent of the input angle.


Returns the hyperbolic arccosine or inverse hyperbolic cosine of the input number.


Returns the hyperbolic arcsine or inverse hyperbolic sine of the input number.


Returns the hyperbolic cosine of the input angle.


Returns the angle of the input number.


Returns the number equivalent to the hyperbolic tangent of the input angle.


Returns the angle between the positive x-axis and the ray from (0,0) to the input point (x,y).


Returns the degree equivalent to the input angle in radians.


Returns the radian equivalent to the input angle in degrees.


Extracts the sign of the given input values.



iv. Date-time functions



Returns the number of months between the given input date-time values.


Returns the number of years between the given input date-time values.


Returns the next immediate date that falls on the specified input day.


Returns the previous week's date that falls on the specified input day.


Returns the date-time values after subtracting the specified number of business days from it.


Encoding functions

We've expanded Deluge's set of encoding functions by supporting the following new functions:
  • htmlEncode: Transform all special HTML characters in the input text into HTML entities.
  • htmlDecode: Render all the HTML entities in the input string.

Artificial intelligence functions

Deluge's ready-to-use AI feature will include a couple more tasks:
  • zoho.ai.detectObject: Detects objects (example: person, laptop, car, traffic lights, etc) and their position in the input image.
  • zoho.ai.extractKeywords: Extracts keywords or tags from the input text.

Try-Catch, break, and continue statements

Deluge will be empowered with flexible error management and improved loop handling features. We're excited to add the following capabilities in Deluge:

Try-Catch: Exception handlers that can test Deluge scripts for run-time errors, and perform required actions if any errors are found.
Break: Terminates the execution of the current loop when encountered.
Continue: Terminates the execution of the current iteration of loop when encountered.

Sorting subform fields

Currently, the fields in subforms are sorted based on the added time. Soon, the subform field will include the capability to sort the fields listed within the subform. This feature will be made available in the field properties of the form. The admin will be able to navigate to the form builder, select the subform field, and specify the sorting preference.



This sorting capability is aimed at requirements that need the fields in the subform to be sorted in a specific order.

For instance, a Customer form might require its subform to list the recent orders of a customer. Here, the admin can sort the subform by navigating to the form builder, selecting the date field of the subform, and specifying the sorting preference as descending. Let's say a customer record is added with the orders of that particular customer in the subform.The sorted orders of that customer will be available while trying to edit the customer's record and also while viewing the record in report.

Note: Sorting cannot be done based on the following: Encrypted fields, URL, Audio,Video, multi-selection fields, integration fields, and user field.

Advanced search option in lookup fields

The advanced search option will equip you with an enhanced search mechanism to drill down to records or field values when you have a large volume of data. This feature is available only for lookup fields with the display type set as dropdown or multi select.

Search queries must return the most accurate and useful results possible, Anything beyond 5,000 is not likely to be the result that the user is looking for. So we have limited the search results to 5,000.This also eliminates the need to scroll down endlessly.



To ensure the user makes the most of this option to locate the record or value, user should try to use the parameters provided in the advanced search as efficiently as possible. This allows user to skip scrolling, while narrowing down the search. All that needs to be done is select the correct search operator and enter the appropriate keywords to fetch the relevant records more easily.




The advanced search will be enabled when the admin enables it in the field properties or when there are more than 500,000 records. Similarly, if a user field or date-time field is used as a display field, Advanced Field Search will automatically be enabled.

We're also introducing a restriction on the number of fields that can be included in display fields in lookup. A maximum of four display fields can only be added. If you have a requirement to add more than that, you can use the formula field as a workaround to combine more than four display values and then lookup the formula field




Security check for unpublished sub-components

It's advisable to share all subcomponents that belong to a published component with your users. Let's assume you have a iframe or widget inserted in a Page and if an unpublished form is used within the iframe or widget, said form will be restricted. This restriction is imposed as a security measure to ensure cross domain security policy. To avoid these kinds of anomalies, please ensure all sub-components present inside a published component are also published.

This restriction will be imposed from March 1st, 2022.

Code sign mobile apps in AAB format

Android App Bundle, or AAB, is a new publishing format added for the Zoho Creator's mobile app Codesign process. It includes all your app’s compiled code and resources, and defers APK generation and signing to Google Play.

Google Play will use your app bundle to generate and serve optimized APKs for each device configuration, so only the code and resources that are needed for a specific device are downloaded to run your app. Going forward, there will be no necessity to build, sign, and manage multiple APKs to optimize support for different devices, and users will get smaller, more-optimized downloads. Learn more

Enhanced report export in mobile and tablet

The enhancements in report export settings that were previously introduced for the web are now being extended to mobile and tablet. You can export the records in your report in your preferred file format and then download them. The exported file can then be used outside of your Zoho Creator application. In the new export settings, you'll be able to provide a file name, select the file format, select the columns to be included in the file, and make the file password-protected. Learn more 



Field permissions in pivot report

Previously, the field permissions feature was not applicable to pivot reports. As a step towards security enhancement, we are now rolling out the capability to control field permissions of View Underlying Data, Drill Down, and Export Underlying Data options in pivot. So the fields that are listed in the above options will be according to the field permissions set up in the permissions set under Users and permissions.

However, the permissions will not be applied when the fields are added as the axes of the charts or as the row/column of the table, because the construction of the chart or table will be impacted.

Invalid parameter validation

We are rolling out a minor change in handling API requests that have invalid or unsupported parameters. Currently, if there are API requests with invalid parameters, our API servers will ignore them and provide the appropriate responses to those requests.

As a step towards data security, we are implementing a change wherein API calls with invalid parameters will be rejected. An error response with the reason for the error will be provided. This validation is scheduled to go live this week or coming week. To avoid such validation errors, we recommend that you remove unsupported parameters before the stipulated date.

Enhancements and changes in Deluge

With the intention of also improving and evolving our existing Deluge features, we've planned a few updates. Ultimately, our aim is to boost Deluge's overall performance, so we've also prepared to lay out a few regulations that will streamline the way Deluge is used. We humbly ask your support in carrying out this plan.

Modified time of main form will be updated when subform rows are updated using Deluge

When rows are inserted into a subform, cleared from a subform, or particular fields of a subform are updated using Deluge, the modified time of the corresponding main form's record will be updated.

Map's key order will be retained in toXml() function's conversion

When using toXml function, the xml string will be generated in the input map's order. In the current behavior, it is generated irrespective of the order of the input map.

Multiselect fields in criteria and sort operations

Note: The following changes will be applicable to all customers.
i. <multi_choice_field>.<multi_choice_field> cannot be used in all filter criteria (report criteria, report filter criteria, conditional filter criteria, conditional formatting criteria, lookup filter criteria, all page builder criteria) and Deluge's fetch record task criteria.

Multi-choice fields are Multiselect, Checkbox, Subform, Multiselect Lookup and Multiselect Users fields.

ii. The values returned by the fetch records task cannot be sorted based on multi-choice fields and composite fields.

File size
i. Uploading files stored in file attachment fields to invokeURL or integration tasks will continue with the current ceiling of 50 MB, whereas downloading the content using invokeURL or extracting file content using <field_link_name>.content is capped at 5MB.
File attachment fields are File Upload, Image, Audio, and Video.

Note: This change is applicable only to new users and unaffected existing users (to be rolled out in a phased manner). Therefore, existing users who already consume file size more than the new limit will not be affected.
ii. The content function (<field_link_name>.content) cannot be applied on Audio and Video fields.

Regex evaluation

Evaluating regex is usually a performance-intensive operation. Therefore, we've been frequently encountering issues related to regex evaluation using Deluge tasks, such as matches, replaceAll, and replaceFirst. To avoid any more issues in this regard, the number of iterations done in the regex matching process is capped at 100,000.

That's all for now!

Thanks,
Zoho Creator Team


    Access your files securely from anywhere


            All-in-one knowledge management and training platform for your employees and customers.






                                  Zoho Developer Community




                                                        • Desk Community Learning Series


                                                        • Digest


                                                        • Functions


                                                        • Meetups


                                                        • Kbase


                                                        • Resources


                                                        • Glossary


                                                        • Desk Marketplace


                                                        • MVP Corner


                                                        • Word of the Day


                                                        • Ask the Experts



                                                                  • Sticky Posts

                                                                  • Zoho Creator + LLMs using Zoho MCP: Bring contextual AI into your apps

                                                                    Hello everyone, We're excited to share that Zoho Creator can now be integrated with leading AI models(like Claude) using Zoho MCP. As you know, Zoho Creator has been a pioneering low-code platform with a razor-sharp focus on making it easy to build business
                                                                  • Introducing Zoho Creator's 2025 Release Projection 2

                                                                    Hello Creators! I'm Prakash, from the Creator product management team, and today I'm delighted to unveil our next set of features as part of Release Projection 2 for 2025. With thoughtful analysis and planning, we've curated powerful new capabilities
                                                                  • Zoho Creator - 2023 Release Projection 1

                                                                    Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue
                                                                  • Zoho Creator User Group meetups in a city near you! - Oct - Nov, 2023

                                                                    Greetings from the Zoho Creator team! We're hosting a series of Zoho Creator meetups in various cities across the globe, and we'd love to meet you there! Our meetups are a great opportunity to network with industry peers, exchange ideas and best practices,
                                                                  • Zoho Creator - 2023 Release Projection 2

                                                                    Hello everyone! Time truly flies when you're having an incredible journey, and today we mark the completion of an eventful and action-packed six months. It feels like just yesterday when we embarked on this adventure together with the launch of our new


                                                                  Manage your brands on social media



                                                                        Zoho TeamInbox Resources



                                                                            Zoho CRM Plus Resources

                                                                              Zoho Books Resources


                                                                                Zoho Subscriptions Resources

                                                                                  Zoho Projects Resources


                                                                                    Zoho Sprints Resources


                                                                                      Qntrl Resources


                                                                                        Zoho Creator Resources



                                                                                            Zoho CRM Resources

                                                                                            • CRM Community Learning Series

                                                                                              CRM Community Learning Series


                                                                                            • Kaizen

                                                                                              Kaizen

                                                                                            • Functions

                                                                                              Functions

                                                                                            • Meetups

                                                                                              Meetups

                                                                                            • Kbase

                                                                                              Kbase

                                                                                            • Resources

                                                                                              Resources

                                                                                            • Digest

                                                                                              Digest

                                                                                            • CRM Marketplace

                                                                                              CRM Marketplace

                                                                                            • MVP Corner

                                                                                              MVP Corner









                                                                                                Design. Discuss. Deliver.

                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                Get Started Now


                                                                                                  Zoho Show Resources

                                                                                                    Zoho Writer

                                                                                                    Get Started. Write Away!

                                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                                      Zoho CRM コンテンツ




                                                                                                        Nederlandse Hulpbronnen


                                                                                                            ご検討中の方





                                                                                                                      • Recent Topics

                                                                                                                      • ZML Error/Bug

                                                                                                                        Hi, I would like to request for your help regarding this kind of behavior. Requested_Start_Time & End_Time - date-time fields https://......#Page:PH_Calendar_Page?reqDate=08-04-2026 https://......#Page:PH_Calendar_Page?reqDate=07-31-2026 https://....#Page:PH_Calendar_Page?reqDate=08-03-2026
                                                                                                                      • Item with name in different languate

                                                                                                                        Hello, is there a way to have an item with its name in different languages? For example: I sell an item in different markets and I'd like to have a Proposal and the Invoice with the Item Name in a specific language. Rino Bertolotto Zoho Specialist, STESA srl
                                                                                                                      • Email notification for followers

                                                                                                                        Is there a way to enable email notification for followers of a support ticket? ie: Ticket #123 is owned by Agent#1, Agent#2 adds themselves as a follower. Whenever ticket #123 receives an email from the customer, Agent#1 receives an email. Agent#2 would
                                                                                                                      • Migration of emails from Yandex to Zoho

                                                                                                                        I am trying to migrate an yandex mail account to zoho mail account. I am confused with all the related articles/informations in the net. Could someone please outline the process to do it, just thinking about me as a novice with limited knowledge or experience. A couple of questions from the knowledge gained. 1. I believe we have to delete the yandex current MX from the website records and add Zoho MX. What happens to the emails as we remove the mail exchange record. Yandex stops updating emails and
                                                                                                                      • Auto-fill from logged-in user's profile for Name Fields in Subforms

                                                                                                                        Hi, The Name field is great, but I see you can't tick the Initial Value option of "Auto-fill from logged-in user's profile" when it is on a Subform, why not? Thanks Dan
                                                                                                                      • Calling a function within another function

                                                                                                                        Hello there, I have just found out that you can simply call up functions in other functions, regardless of the department. You can't create functions with the same name twice, even though you are in a different department. If you try it, you don't get
                                                                                                                      • 【続々公開】Zoholics Japan 2026 セッション情報を更新しました!

                                                                                                                        ユーザーの皆さま、こんにちは! Zoholics Japan 2026のセッション情報を続々と公開しています! 今年は3つのトラックで、Zohoの最新情報やAI活用、製品アップデート、 活用事例など、多彩なセッションをお届けします。 現在公開中のセッション(一部) ・Zoho CRM 製品アップデート ・Zoho CRM Plus 製品アップデート ・Zoho Community セッション ・Zoho Desk セッション ・中堅・成長企業の人事DX ~AI時代に何から始めるべきか?~ ・Zoho
                                                                                                                      • Zoho CRM Community Digest - July 2026 | Part 1

                                                                                                                        Hello everyone, July is here! The first two weeks brought six CRM updates ranging from privacy-ready webforms to a significantly more powerful Layout Rules engine, two community wins worth a look (a dashboard workaround for spotting leads with no activities,
                                                                                                                      • New Ways to Personalize, Organize, and Share Your Notes

                                                                                                                        We're excited to introduce a new set of enhancements in Zoho Notebook that make your note-taking experience cleaner, more flexible, and easier to share. With this update, you can create notes that automatically adapt to your device theme, browse your
                                                                                                                      • Zoho Commerce B2B

                                                                                                                        Hello, I have signed up for a Zoho Commerce B2B product demo but it's not clear to me how the B2B experience would look for my customers, in a couple of ways. 1) Some of my customers are on terms and some pay upfront with credit card. How do I hide/show
                                                                                                                      • Introducing spam detection for webforms: An additional layer of protection to keep your Zoho CRM clean and secure

                                                                                                                        Greetings all, One of the most highly anticipated feature launches—Spam Detection in webforms—has finally arrived! Webforms are a vital tool for record generation, but they're also vulnerable to submissions from unauthenticated or malicious sources, which
                                                                                                                      • Rich-text fields in Zoho CRM

                                                                                                                        Moderation Update: During the initial release of Rich Text fields, it was supported only in the Enterprise and Ultimate editions. We have gradually extended Rich Text fields to all the paid editions of Zoho CRM. Hello everyone, We're thrilled to announce
                                                                                                                      • Add Large Lists to Choice-Based Field Rules

                                                                                                                        Hi, The new Large List is good, but you can't then use the Choice-Based Field Rules with it to limit the Group Choices or Choices? Thanks Dan
                                                                                                                      • Email-Data Synchronization with Zoho Analytics

                                                                                                                        Hello, Enterprise Support Community! We're excited to announce the availability of Email Data Synchronization with Zoho Analytics! This highly requested enhancement allows you to sync email data from Zoho CRM into Zoho Analytics, making it easier to analyze
                                                                                                                      • Zoho - shopify sales order - invoicing

                                                                                                                        we have integrated zoho with shopify. so now , when an order comes through shopify-it raises a sales order in zoho. And at this time- the inventory goes down in shopify, according to the sale. Then we manually convert the sales order to an invoice, and
                                                                                                                      • Enable Replenishments Option not Available

                                                                                                                        I'm looking to turn on the replenishment option in Zoho Inventory and I'm not finding settings for it in Zoho Books or Zoho Inventory. This is the tutorial I was following from Zoho. Is there a step I'm missing to have Replenishments be available in Zoho
                                                                                                                      • Kiosk Page Refresh

                                                                                                                        We have a Kiosk running from a button in contacts to update values and also add related lists, which works great, but when the kiosk is finished the page does not refresh to show the changes. Is there a way to force the contact to refresh/update when
                                                                                                                      • [Solution] Analyze, Act and Automate with Drill Actions

                                                                                                                        Insights create value only when they lead to action. Traditional dashboards excel at helping you understand what is happening, but acting on those insights often requires manual intervention leaving the dashboard, opening another application, finding
                                                                                                                      • Building extensions #6: Handling modal boxes to enhance user experience

                                                                                                                        In our previous post, we explored creating custom graphical user interfaces using widgets. In this post, we'll learn about enhancing user experience through modal boxes. What is a modal box, and where is it used? A modal box is essentially a widget interface
                                                                                                                      • Improve User Onboarding in Zoho Projects with Zoho DAP

                                                                                                                        Rolling out new processes or onboarding new users in the tool comes with a familiar challenge: the employees need guidance at the moment they are doing the work. Traditional training sessions and knowledge sharing often require users to leave the application.
                                                                                                                      • Zoho Social API for generating draft posts from a third-party app ?

                                                                                                                        Hello everyone, I hope you are all well. I have a question regarding Zoho Social. I am developing an application that generates social media posts, and I would like to be able to incorporate a feature that allows saving these posts as drafts in Zoho Social.
                                                                                                                      • Your CRO data is now on your AI Assistant: PageSense is live on Zoho MCP

                                                                                                                        Hello Everyone, We are excited to announce Zoho PageSense is now live on Zoho MCP servers. Here is what that means for you. Every answer about your website lives behind tons of data across different modules. Which test is winning. Where visitors bail.
                                                                                                                      • Feature Enhancement Request – Bulk Download of Signed Documents in Zoho Sign

                                                                                                                        Hi Team, We would like to request a Bulk Download feature for signed documents in Zoho Sign. Currently, Zoho Sign allows users to send documents in bulk using an Excel sheet, but there is no option to download the completed signed documents in bulk. Users
                                                                                                                      • delete a user on Zoho Desk

                                                                                                                        Kindly I Need help to delete a user on Zoho Desk but I deactivated but not deactivated with licenses so what can I Do?
                                                                                                                      • Unable to open Attendance Regularization request, reason?

                                                                                                                        Unable to open Attendance Regularization request.
                                                                                                                      • What's New in Zoho Inventory | June 2026

                                                                                                                        Hello users, June 2026 introduces a range of exciting enhancements to Zoho Inventory. With the full rollout of the Zoho Inventory Windows application, the launch of Terminal Payments, and new tracking combinations in Advanced Inventory Tracking, you can
                                                                                                                      • Tax/Vat Number Field As Standard - Customer & Vendor

                                                                                                                        Hello, when are you'll going to have the customer & vendor tax/vat number as a standard field under the relevant profile pages? I find it strange that after 6 years of using Zoho Inventory that I still have to use a custom field for a tax/vat number,
                                                                                                                      • Zoho CRM - Feature Request - Conditional Lead Conversion

                                                                                                                        Hi CRM team, My feature request is to allow admins to create some conversion logic in the Lead Conversion settings. It is a common case where we want to convert a Lead to a Commercial or Residential Deal layout. Layout rules are not ideal because the
                                                                                                                      • Zoho CRM Approval Process based on Field Update

                                                                                                                        Hello, In current structure, Zoho CRM send records to approval based on record creation and edit.  I think, it should be to set approval process trigger based on any field update in record. When the user update any field, the record can assign to approval
                                                                                                                      • Free webinar: Automate signature workflows with Zoho Sign and Zoho WorkDrive

                                                                                                                        Hi there! Are you still storing and managing physical paperwork before and after signing? This traditional method is bulky, costly, and impractical at scale. Attend our free webinar to learn how you can connect Zoho Sign, our digital signature app, with
                                                                                                                      • Global Sets for Multi-Select pick lists

                                                                                                                        When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.
                                                                                                                      • Introducing the Zoho Projects Learning Space

                                                                                                                        Every product has its learning curve, and sometimes having a guided path makes the learning experience smoother. With that goal, we introduce a dedicated learning space for Zoho Projects, a platform where you can explore lessons, learn at your own pace,
                                                                                                                      • Leave request problem on mobile phones

                                                                                                                        Hello, When any employee attempts to submit a leave request on an Android or iOS phone, the error shown in the attachment appears. How can we solve this problem?
                                                                                                                      • [Webinar] Digitizing forms and form-based workflows

                                                                                                                        Live webinar on August 13, 2026 | Time: 2 PM IST | 2 PM EDT Hi, Struggling with paper forms, manual data entry, disconnected approvals, and form data that never reaches the apps that need it? Join our live webinar to learn how Zoho Writer's fillable templates
                                                                                                                      • Multi-currency and Products

                                                                                                                        One of the main reasons I have gone down the Zoho route is because I need multi-currency support. However, I find that products can only be priced in the home currency, We sell to the US and UK. However, we maintain different price lists for each. There
                                                                                                                      • Price Book in foreign currency

                                                                                                                        We have many customers who buy in foreign currency (USD), where our base currency is our local currency (AUD). It would be normal (it is in Zoho Books, Zoho Inventory etc.) to assign a currency to a price book, but I cannot find this option in Zoho CRM
                                                                                                                      • Assign Price Book to Accounts (again!)

                                                                                                                        I can see this topic has been bumping about for over 10 years and unfortunately Zoho hasn't seen the need (or use case) in CRM to be able to assign an account to a price book to automate quoting (amongst other things). Strange given they DO assign price
                                                                                                                      • Remove "Subject" as a required field on quotations

                                                                                                                        Not sure why, but Zoho has made 'Subject' a system defined required field. I'm not entirely sure why subject would be required as a key field (i.e. you cannot deactivate it or change it from required). It doesn't make much sense on many product quotations,
                                                                                                                      • Approve records efficiently: Useful enhancements to My Jobs module and Approval process in Zoho CRM

                                                                                                                        Dear Customers, As you might know, approval process is a process automation tool that allows you to automate approvals in your organization and My Jobs is where you approve requests from a single point of view. Here's how you'd go about it: You’d add
                                                                                                                      • Text/SMS With Zoho Desk

                                                                                                                        Hi Guys- Considering using SMS to get faster responses from customers that we are helping.  Have a bunch of questions; 1) Which provider is better ClickaTell or Screen Magic.  Screen Magic seems easier to setup, but appears to be 2x as expensive for United States.  I cannot find the sender id for Clickatell to even complete the configuration. 2) Can customer's reply to text messages?  If so are responses linked back to the zoho ticket?  If not, how are you handling this, a simple "DO NOT REPLY" as
                                                                                                                      • Next Page