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







                            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

                                                            • 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
                                                            • Upcoming Updates - August 2022

                                                              Hi all, Greetings from the Zoho Creator team! Today we've got news for you on some exciting updates. And rest assured— there’s more to come! In this post, we'll be going over the upcoming features and improvements for this month as mentioned below. A


                                                            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

                                                                                                              • How to import data from PDF into Zoho Sheet

                                                                                                                I am looking to import Consolidated Account Statement (https://www.camsonline.com/Investors/Statements/Consolidated-Account-Statement) into zoho sheet. Any help is appreciated. The pdf is received as attachment in the email, this document is password
                                                                                                              • Zoho Projects Android app: Integration with Microsoft Intune

                                                                                                                Hello everyone! We’re excited to announce that Zoho Projects now integrates with Microsoft Intune, enabling enhanced security and enterprise app management. We have now added support for Microsoft Intune Mobile Application Management (MAM) policies through
                                                                                                              • Cant't update custom field when custom field is external lookup in Zoho Books

                                                                                                                Hello I use that : po = zoho.books.updateRecord("purchaseorders",XXXX,purchaseorder_id,updateCustomFieldseMap,"el_books_connection"); c_f_Map2 = Map(); c_f_Map2.put("label","EL ORDER ID"); c_f_Map2.put("value",el_order_id); c_f_List.add(c_f_Map2); updateCustomFieldseMap
                                                                                                              • Wrapping up 2025 on a high note: CRM Release Highlights of the year

                                                                                                                Dear Customers, 2025 was an eventful year for us at Zoho CRM. We’ve had releases of all sizes and impact, and we are excited to look back, break it down, and rediscover them with you! Before we rewind—we’d like to take a minute and sincerely thank you
                                                                                                              • About Zoneminder (CCTV) and Zoho People

                                                                                                                Hi team I would like to implement a CCTV service for our branches, with the aim of passively detecting both the entry and exit of personnel enrolled in Zoho Peeple, but my question is: It is possible to integrate Zoho People with Zoneminder, I understand
                                                                                                              • 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,
                                                                                                              • Create CRM Deal from Books Quote and Auto Update Deal Stage

                                                                                                                I want to set up an automation where, whenever a Quote is created in Zoho Books, a Deal is automatically created in Zoho CRM with the Quote amount, customer details, and some custom fields from Zoho Books. Additionally, when the Sales Order is converted
                                                                                                              • How to show branch instead of org name on invoice template?

                                                                                                                Not sure why invoices are showing the org name not the branch name? I can insert the branch name using the ${ORGANIZATION.BRANCHNAME} placeholder, but then it isn't bold text anymore. Any other ideas?
                                                                                                              • Admin asked me for Backend Details when I wanted to verify my ZeptoMail Account

                                                                                                                Please provide the backend details where you will be adding the SMTP/API information of ZeptoMail Who knows what this means?
                                                                                                              • Unable to remove the “Automatically Assigned” territory from existing records

                                                                                                                Hello Zoho Community Team, We are currently using Territory Management in Zoho CRM and have encountered an issue with automatically assigned territories on Account records. Once any account is created the territory is assigned automatically, the Automatically
                                                                                                              • Kaizen #223 - File Manager in CRM Widget Using ZRC Methods

                                                                                                                Hello, CRM Wizards! Here is what we are improving this week with Kaizen. we will explore the new ZRC (Zoho Request Client) introduced in Widget SDK v1.5, and learn how to use it to build a Related List Widget that integrates with Zoho WorkDrive. It helps
                                                                                                              • Set connection link name from variable in invokeurl

                                                                                                                Hi, guys. How to set in parameter "connection" a variable, instead of a string. connectionLinkName = manager.get('connectionLinkName').toString(); response = invokeurl [ url :"https://www.googleapis.com/calendar/v3/freeBusy" type :POST parameters:requestParams.toString()
                                                                                                              • Possible to connect Zoho CRM's Sandbox with Zoho Creator's Sandbox?

                                                                                                                We are making some big changes on our CRM so we are testing it out in CRM's Sandbox. We also have a Zoho Creator app that we need to test. Is it possible to connect Zoho CRM's Sandbox to Zoho Creator's Sandbox so that I can perform those tests?
                                                                                                              • I Need Help Verifying Ownership of My Zoho Help Desk on Google Search Console

                                                                                                                I added my Zoho desk portal to Google Search Console, but since i do not have access to the html code of my theme, i could not verify ownership of my portal on Google search console. I want you to help me place the html code given to me from Google search
                                                                                                              • Timeline Tracker

                                                                                                                Hi Team, I am currently using Zoho Creator – Blueprint Workflows, and I would like to know if there is a way to track a timeline of the approval process within a Blueprint. Specifically, I am looking for details such as: Who submitted the record Who clicked
                                                                                                              • Primary / Other Billing Contacts

                                                                                                                If you add an additional contact to a Zoho Billing Customer record, and then mark this new contact as the primary contact, will both the new primary and old primary still receive notifications? Can you stop notifications from going to the additional contacts
                                                                                                              • Missing Import Options

                                                                                                                Hello, do I miss something or is there no space import option inside of this application? In ClickUp, you can import from every common application. We don't want to go through every page and export them one by one. That wastes time. We want to centralize
                                                                                                              • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

                                                                                                                Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files
                                                                                                              • Is it possible to enforce a single default task for all users in a Zoho Projects ?

                                                                                                                In Zoho Projects, the Tasks module provides multiple views, including List, Gantt, and Kanban. Additionally, users can create and switch to their own custom views. During project review meetings, this flexibility creates confusion because different users
                                                                                                              • [Free Webinar] Zoho Creator webinars - Learning Table and Creator Tech Connect Series in 2026

                                                                                                                Hello everyone, Wishing you all a wonderful new year! May 2026 and the years ahead bring more opportunities, growth, and learning your way 🙂 We’re excited to kick off the 2026 edition of the Learning Table Series and Creator Tech Connect Series ! Learning
                                                                                                              • Reply and react to comments

                                                                                                                Hi everyone! We're excited to bring to you a couple of new features that'll make your sprint process simpler. A cloud application brings with it an array of social media features that can be efficiently used in your organizational setup. As an agile scrum
                                                                                                              • Restrict Users access to login into CRM?

                                                                                                                I’m wanting my employees to be able to utilize the Zoho CRM Lookup field within Zoho Forms. For them to use lookup field in Zoho Forms it is my understanding that they need to be licensed for Forms and the CRM. However, I don’t want them to be able to
                                                                                                              • Module Customisation - Lookup function not available

                                                                                                                Good evening, Within my business, I can have multiple customers, who have multiple mobile assets. When I set these assets up, I enter information such as vehicle registration, Vehicle identification number (VIN), Unit number, YOM, in addition to others.
                                                                                                              • zoho click, and nord VPN

                                                                                                                Unfortunately, we've been having problems with Zoho Click, where essentially the line cuts off after about a minute's worth of conversation every time we are on VPN. Is there a way we can change this within the settings so it does not cut the line off
                                                                                                              • Zoho Calender

                                                                                                                a) does the clanender in zoho project allow you to see the name of the event in the celnder view, it currently says either "Task (1) or "Milestoen (1)" b) Alternatively does the calender in Zoho project integrate with zoho calender?
                                                                                                              • Matching ZOHO Payments in Banking

                                                                                                                Our company has recently integrated ZOHO Payments into our system. This seemed really convenient at first because our customers could pay their account balance by clicking on a link imbedded in the emailed invoice. Unfortunately, we can't figure out how
                                                                                                              • Team Gamification

                                                                                                                Would love to motivate, engage and encourage our team with our social media posts. Would like to include Gamification features of Social Media in Zoho Social or Marketing Automation. And also bring in Social Advocacy tools/tracking/management to these,
                                                                                                              • Power up your Kiosk Studio with Real-Time Data Capture, Client Scripts & More!

                                                                                                                Hello Everyone, We’re thrilled to announce a powerful set of enhancements to Kiosk Studio in Zoho CRM. These new updates give you more flexibility, faster record handling, and real-time data capture, making your Kiosk flows smarter and more efficient
                                                                                                              • New Enhancements to Zoho CRM and Zoho Creator Integration

                                                                                                                Hello Everyone, We’ve rolled out enhancements to the Zoho Creator and Zoho CRM integration to align with recent updates made to the Zoho Creator platform. With enhancements to both the UI and functionality, This update also tightens access control by
                                                                                                              • Work Type - Limitation

                                                                                                                Hello, I'm setting up work types and have noticed, a limitation on the parts area to 10 lines. Can this be increased to 20 or greater? In addition to this, when I attempt to add the work type to a work order, the correct labour hours doesn't flow through.
                                                                                                              • Emails sent through Bigin are not posting in IMAP Sent folder

                                                                                                                I have set up my email to work from within Bigin using IMAP.  I am using IMAP so I can sync my email across multiple devices - phone / laptop / desktop / iPad / etc.  I want all my emails to populate my email client (outlook & iphone email) whether or
                                                                                                              • Turning the page for Zoho SalesIQ: 2025 to 2026

                                                                                                                As we wrap up 2025, we would like to take a moment to reflect on what we set out to achieve this year, what we’ve delivered, and where we’re headed next. What we focused on in 2025 This year was all about strengthening the core of engagement and AI, making
                                                                                                              • Stage-probability mapping feature in custom module

                                                                                                                Hi, I'm building a custom module for manage projects. I would like to implement the stage-probability feature that Potentials has. Is this possible?
                                                                                                              • Temporary Outage in Zoho Cliq Affecting US Users – July 23, 2025

                                                                                                                We experienced a service disruption in Zoho Cliq that impacted core functionality for users in the US region. The issue occurred between Jul 23, 2025, 06:54:00 PM IST and 07:13:13 PM IST, lasting approximately 19 minutes. To restore service stability,
                                                                                                              • Why Sharing Rules do Not support relative date comparison???

                                                                                                                I am creating a Sharing Rule and simply want to share where "Last Day of Coverage" (Date field) is Greater than TODAY (Starting Tomorrow). However, sharing rules don't have the option to compare a date field to a relative date (like today), only to Static
                                                                                                              • Zoho Cliq not working on airplanes

                                                                                                                Hi, My team and I have been having this constant issue of cliq not working when connected to an airplane's wifi. Is there a reason for this? We have tried on different Airlines and it doesn't work on any of them. We need assistance here since we are constantly
                                                                                                              • Problem with Workdrive folders

                                                                                                                I'm having a problem a problem accessing files in a Zoho work drive folder when using the Zoho writer app. The problem folder appears grayed out in the Zoho work drive window in both the online and writer application. However I can open the folder in
                                                                                                              • 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. 
                                                                                                              • Create an Eye-Catching Announcement Widget for Your Help Center

                                                                                                                Hello Everyone! In this week’s edition, let’s explore how to keep your customers updated with exciting news in the Help Center. See how ZylkerMobile wowed their customers by bringing updates right to their portal. ZylkerMobile, the renowned brand for
                                                                                                              • Send Whatsapp with API including custom placeholders

                                                                                                                Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number
                                                                                                              • Next Page