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

                                                                                                          • 136.143.188.51 blocked by spamcop

                                                                                                            Zoho mailserver seems to be blocked by spamcop. Cant send mail to my customer. Not sure what to do.
                                                                                                          • 🚀 WorkDrive 5.0: Evolving from a file sharing app to an intelligent content management platform: Phase 2

                                                                                                            Hello everyone, WorkDrive's primary focus has always been to provide an intelligent and secure content management platform, simplify collaboration, and be the central repository of files for all Zoho apps. In our previous announcement, we unveiled the
                                                                                                          • Sync desktop folders instantly with WorkDrive TrueSync (Beta)

                                                                                                            Keeping your important files backed up and accessible has never been easier! With WorkDrive desktop app (TrueSync), you can now automatically sync specific desktop folders to WorkDrive Web, ensuring seamless, real-time updates across devices. Important:
                                                                                                          • i keep see there is a connetion issue connecting 3rd party api on zoho when using zia

                                                                                                            hi there , i have set up open ai api to zoho zia (copied and pasted to zoho zia) but I keep getting notificaiton "there is a connetion issue connecting 3rd party api on zoho" when using zia on top when click zia and try to type in word there
                                                                                                          • Deleting Fields in CRM Deletes Views in Analytics

                                                                                                            Hey friends! I'm having some issues when we modify some fields within ZohoCRM. There are times where we need to sunset a field and eventually completely remove it. In these instances, it seems like a lot of views are removed in Analytics. This ranges
                                                                                                          • Booking outside of scheduled availability

                                                                                                            Is there a way for staff (such as the secretary) to book appointments outside of the scheduled availability? Right now to do this special hours must be set each time. There should be a quicker way. Am I missing something?
                                                                                                          • Zoho Desk Android and iOS app update: Access multilingual templates on the IM module

                                                                                                            Hello everyone! We have introduced multilingual templates on the IM module of the Zoho Desk mobile app allowing you to send IM template messages in translated versions. iOS: Android: Please update the app to the latest version directly from the App Store/
                                                                                                          • Can't login IMAP suddenly

                                                                                                            Since this evening I'm getting the error: You are yet to enable IMAP for your account. Please contact your administrator... IMAP always been enabled in my account and was workign fine for the past 7 years. Already tried turning IMAP off and on again.
                                                                                                          • Does Zoho offer a full WhatsApp Marketing Platform (like WATI / GallaBox)?

                                                                                                            lm exploring WhatsApp marketing and I’d like to understand what options are available within the Zoho ecosystem. Currently, I see: Zoho SalesIQ has a broadcast option, but it seems very limited — for example, it doesn’t support uploading contacts via
                                                                                                          • Custom buttons

                                                                                                            Getting Error "You can only create 10 custom buttons per module" ! I already have more than 10 for 1 module before trying to create another. Is this a new restriction brought about by the all knowing what's best for businesses Zoho guru ? It would be
                                                                                                          • The Social Wall: October 2025

                                                                                                            Hello everyone, As we head toward the end of the year, we’re bringing you a few updates to help give your social media efforts a strong finish. This month, we’re rolling out new enhancements across both the web and mobile app. Post Preview Have you ever
                                                                                                          • Client Script | Update - Support for List Page (Canvas) and Notes

                                                                                                            Hello everyone! We are glad to announce two exciting updates in Client Script. Client Script support for List Page (Canvas) Client Script support for Notes These open the door to more dynamic and interactive customizations! 1. Client Script support for
                                                                                                          • Pincode Based Pricing

                                                                                                            We want to give extra discount to customers within city limits because our shipping and packing costs are less. My proposal is assign list of pincodes to price list and assign the price list to customers whenever they sign up with pincodes. Also show
                                                                                                          • feature question: lookup field in Projects task layout

                                                                                                            Hello, Below we have interface to configure a custom task layout, however, we need a lookup field to let pickup data from other apps, such as Zoho CRM Products module, is that possible or already in your roadmap? or a workaround to achieve it? Thanks in advance.
                                                                                                          • Can we do Image swatches for color variants?

                                                                                                            We want to do something like the attached screenshot on our new zoho store. We need image swatches instead of normal text selection. We want to user to select an image as color option. Is this doable? I don't see any option on zoho backend. Please h
                                                                                                          • What's New in Zoho Analytics - October 2025

                                                                                                            Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
                                                                                                          • Zoho Analytics & SQL Server - Live connect

                                                                                                            Below are the steps I did Created a fresh database and table in my own virtual server Created a new data source connection with live connect I was able to select the tables and created the data source successfully I am getting the error when I try to
                                                                                                          • Explore the Redesigned Quotes Module in Zoho Billing

                                                                                                            Dear users, We’re excited to introduce a refreshed look for the Quotes details page in Zoho Billing! This update brings you a more efficient user interface experience without changing your existing workflow. We've enhanced layouts with organized tabs,
                                                                                                          • Latest updates in Zoho Meeting | Create departments, Share PDF files

                                                                                                            Hello all,   You can now create departments to group team members within your organization. This will make it easier for you to organize department-level meetings and invite members. In webinars, use the Share material feature to share PDF files directly
                                                                                                          • Unify All Zoho Video Meeting Experiences into One Standardized Platform

                                                                                                            Hi Zoho Team, We would like to share an important user experience concern regarding the current state of video meeting functionality across the Zoho ecosystem. The Problem Within Zoho, there are multiple ways to initiate or schedule a video meeting: Zoho
                                                                                                          • [Free Webinar] Product Updates: Quick Catch-Up Session - Part I - Creator Tech Connect

                                                                                                            Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions designed for developers, administrators, and app builders.
                                                                                                          • Project expenses in Zoho Books

                                                                                                            Just the way timesheet is used to calculate labour cost for a particular project, how do i record other expenses against a project such as materials and consumables used for the project? So that under report, I can view the total amount expended on each
                                                                                                          • Blueprint status change

                                                                                                            I want to change the Blueprint status of a workflow. The status is completed automatically when I added the record through API call. But I want to make it active, I don't see any options for this. Even if I draw transition from any stage , it is not visible
                                                                                                          • What is going on with GMail extension.

                                                                                                            Suddenly, it is popping up and saying "Please wait while we work our magic... 10%" and it sits there. Yesterday I waited for an entire hour call and it never got further. Today, it's not resolved. Is there a fix I can do? I've tried all the typical
                                                                                                          • Marketing Tip #6: Cross-sell with related products

                                                                                                            Don’t let customers stop at just one product. Suggesting related or complementary items improves the shopping experience and increases order value. Try this today: Use the Item Recommendations feature in Zoho Commerce and add two to three suggested items
                                                                                                          • i cannot use <b></b> to bold the message in Creator C6!!!!???What?

                                                                                                            Dear experts and friends, Now Creator 6 blocking us from using <b></b> Anyone facing this issue? I faced it on Creator C6 Previously, it used to work. Now failed to work. Faint~ Seek guidance from everyone on how to bold the message. The super simple
                                                                                                          • Zoho Writer - Option to Export as .zdoc format

                                                                                                            I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become
                                                                                                          • [Announcement] Enhanced Merge APIs of Zoho Writer for automating document generation using Zoho Apps data

                                                                                                            Hi users, With the record_id parameter in Zoho Writer's Merge APIs, fields related to the given record id is automatically fetched from the Zoho app. You don't have to spend time manually mapping the records and fields in the Deluge code. Here is a sample
                                                                                                          • Pin multiple columns and adjust column widths in CRM subforms

                                                                                                            Hello all, Subforms act as secondary forms or tables in which you can associate multiple line items to a primary record and thereby ensure more structured and comprehensive data organization. We've made some recent enhancements to subforms. Here's what's
                                                                                                          • [Webinar] Automate sales and presales workflows with Writer

                                                                                                            Sales involves sharing a wide range of documents with customers across the presales, sales, and post-sales stages: NDAs, quotes, invoices, sales orders, and delivery paperwork. Generating and managing these documents manually slows down the overall sales
                                                                                                          • Automate insurance document workflows with Zoho Writer

                                                                                                            Insurance companies have to deal with creating and managing complex documents and forms, such as policy applications, explanation of benefits documents, brochures, renewals, and claim forms. Handling all of this manually is hugely time and effort intensive,
                                                                                                          • Latest updates in Zoho Meeting | New End of session notification to remind everyone about the session end time

                                                                                                            Hello everyone, We’re excited to share a new feature for Zoho Meeting ; End of session notification. With this new setting, you can choose to remind all participants or only the host about the scheduled end time of a meeting. You can also choose when
                                                                                                          • [Webinar] Zoho Writer for SCM and logistics

                                                                                                            Creating, sharing, and distributing complex documents are constant challenges in the SCM and logistics industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on Jul 10, 2025 for a Zoho Writer webinar designed
                                                                                                          • [Webinar] Zoho Writer for the manufacturing industry

                                                                                                            Creating, sharing, and distributing complex documents are constant challenges in the manufacturing services industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on May 8, 2025, for a Zoho Writer webinar
                                                                                                          • Add Comprehensive Accessibility Features to Zoho Writer

                                                                                                            Hello Zoho Writer Team, We hope you are doing well. We would like to submit a feature request to enhance Zoho Writer with a full set of accessibility tools, similar to the accessibility options already available in the Zoho Desk agent interface. 🚧 Current
                                                                                                          • [Webinar] Simplifying document workflows in financial services with Zoho Writer

                                                                                                            Creating, sharing, and distributing complex documents are constant challenges in the financial services industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on April 10, 2025, for a Zoho Writer webinar
                                                                                                          • [Zoho Writer Webinar] Learn how to simplify your HR operations: Part 2

                                                                                                            Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for July 2024: Learn how Zoho Writer can simplify your HR operations: Part 2. This webinar will focus on how Zoho Writer can help HR teams streamline and automate their entire hiring
                                                                                                          • [Zoho Writer Webinar] Learn how to simplify your day-to-day HR operations

                                                                                                            Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for June 2024: Learn how Zoho Writer can simplify your day-to-day HR operations. This webinar will focus on how to automate your entire hiring process and generate various types of
                                                                                                          • Branding of native system emails

                                                                                                            Make system emails adjustable in terms of branding. We want our system to be completely white label, because it is not a CRM anymore, it's way more than that. We are following the strategy of "CRM for everyone" to use the CRM in all departments, not only
                                                                                                          • Support “Never End” Option for Recurring Meetings in Zoho Meeting

                                                                                                            Hello Zoho Meeting Team, Hope you are doing well. We would like to request support for creating recurring meetings with no end date in Zoho Meeting. Currently, when scheduling a recurring meeting, Zoho Meeting requires us to select a specific end date.
                                                                                                          • Next Page