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
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Neethinila R
Damien Cregan
736035016@zohoclosedAccount.com
Manu Quiroga / frontera.digital
Paweł
Sticky Posts
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 continueZoho 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 newUpcoming 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. AIntroducing Zoho Creator's v2 APIs
Hello App Creators, Welcome to Zoho Creator's v2 APIs! This post will serve as the central point for migrating implementations of Creator's current APIs (v1) to v2. Improvements that v2 brings OAuth-based authentication, which is more secure than the
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Mail Merge - unable to send more than 50 email
Hi, I've subscribed to the pay email service because of the Mail Merge feature. However, I've found that this feature only allow to send up to 50 emails. I've to attach a screenshot for your reference. This limitation is not mentioned anywhere in service.Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience
Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that youUK payroll entries
Hey guys, Nett payroll payments are imported direct into the bank, using an external payroll system (will be glad for Zoho to have a UK payroll app) At present I have monthly recurring bills for HMRC which are auto entered & paid when due. This seemsClosing Accounting Periods - Invoice/Posting dates
Hi, I have seen in another thread but I'm unsure on how the 'transaction locking' works with regards to new and old transactions. When producing monthly accounts if I close December 24 accounts on 8th Jan 25 will transaction locking prevent me from postingInvoice status on write-off is "Paid" - how do I change this to "Written off"
HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a wayReverse Charge Services (Non-EU) Showing Correctly in 84/85 and 67, But Missing in Box 46 - Germany
Hi, I'm located in Germany and I’ve set up my expenses for non-EU services (e.g., OpenAI, DeepSeek) under the reverse charge mechanism (§ 13b UStG) in Zoho Books, and I noticed some discrepancies in the VAT Summary Report. What’s Correct: Reverse ChargeZoho Live Chat/Support
What is going on with Zoho support lately? I've tried to use the live chat feature 4 different times and it refuses to connect to any (despite waiting over 30 minutes one of the tries). I finally gave up and emailed my question nearly a week ago and stillCan we have a module to records Certificate No and TDS rates for Lower TDS Certificates by the vendors ?
Can we have a module to records Certificate No and TDS rates for Lower TDS Certificates by the vendors ?Tip #38- Track Organizational Changes: A Guide to Using Action Log Viewer- 'Insider Insights'
Hello Zoho Assist Community! Ever needed to trace who did what and when within your remote support operations? Let’s say your support team is growing, and you want to monitor key activities like settings updates, user invites, module changes, or permissionTip of the Week #67– Avoid confusion – Mark duplicate threads.
When customers send the same message to multiple email addresses, such as support@ and sales@, your team may end up seeing the same message in different inboxes. This creates confusion, risks double replies, and clutters your workspace. Use the Mark asTax in Quote
Each row item in a quote has a tax value. At the total numbers at the bottom, there is also a Tax entry. If you select tax in both of the (line item, and the total), the tax doubles. My assumption is that the Tax total should be totalling the tax fromFinal Reminder: Discontinuation of Older ASAP Widgets and Mobile SDK Support
We launched the new ASAP Help Widget last year, introducing a unified and enhanced experience. Since then, older configurations have been placed in read-only mode, with all major updates and improvements built exclusively on the new version. As part ofZoho Subscriptions -- Zoho Commerce integration
Is there integration between Zoho Subscriptions and Zoho Commerce? I would like to create subscription plans in Zoho Subscritpions and list them for on my Zoho Commerce store.Website show Blank white screen
Customer called me to tell me my website is currently down upon review it shows a white screen however I can access everything via editor. JITCADCAM.comHow manufacturing analytics can transform your enterprise with Zoho Projects Plus
Did you know that every single car is made up of 30,000 to 40,000 individual parts? All of these are manufactured meticulously in various facilities before being assembled into one. The global manufacturing industry spans a wide range from deliveringProjects custom colors replaced by default orange
Since yesterday, projects uploaded to Zoho, to which I had assigned a custom color, have lost the customization and reverted to the default color (orange). Has anyone else had the same problem? If so, how did you resolve it?Customize your SalesIQ live chat with Custom CSS and blend it with your website design
Hi everyone. Hope you all are having a great day! SalesIQ offers various inbuilt customization choices for your chat widget and window like changes in colour, theme, font etc. Although these choices are many, sometimes they may not match with the designFrom Email Address When Replaying to Missed Chats
One of the most common things we do is follow up on every missed chat. Missed chats are like money in the bank, people just waiting for your response and to start a relationship with our companies. However, SalesIQ only lets you respond from 1 email address from your entire account?! We have happily paid for 4 subscriptions, but our users cannot reply from their own email address? How are we supposed to build customer relationships? The fix to this issue is so simple, just load in the logged inhow to treat a same person as customer and vendor in zoho
hi team, in my company, few persons acting as creditors as well as debtors (which means sometimes we pay them... some times we paid by them). in that case i would like to maintain a same ledger for that person.in zoho books it is treating creditor andNarrative 6 - The impact of rebranding
Behind the scenes of a successful ticketing system - BTS Series Narrative 6 - The impact of rebranding Every organization has invested in branding to set itself apart, and that should be reflected in the help desk. Zoho Desk enables organizations to applycustom color palette for picklist in Sheet
Migrating over from Google Sheets and missing the ability to customize the individual item colors of my picklist/dropdown menus. Is this something that is possible? A search showed me creating a custom color palette in Analytics is possible but I am notWhat's New - July 2025 | Zoho Backstage
Start smart, end strong. From knowing who’s coming to celebrating who showed up, July’s updates help you run events that feel organized from the first invite to the final thank you. Planning an event used to be like writing a choose-your-own-adventureImage Upload Field API get encrypted ID and sequence number
Hello is there a way to extract the encrypted id and sequence number from image upload fields through the Zoho CRM API? I created a custom script with javascript within Zoho CRM, but I want to extract the encrypted id and sequence number for all my imagesAttention: Changes to 10DLC TCR pricing and new authentication requirements
Hi everyone, Starting August 1, 2025, The Campaign Registry (TCR) is introducing new pricing changes and a mandatory brand verification process called Authentication+ 2.0, which will affect how you register and manage your 10DLC messaging services. TheseBetter Time Tracking
We need better time tracking customization for IT MSPs. We also need reporting that is built in, rather than having to try and fumble with creating custom reports. We also need to be able to mark whether a ticket has been billed or not, I don't thinkScheduled Tickets Need Updated
There is a very clunky manual way to create reoccurring scheduled tickets. This should be created to be easy for the administrator to create. We create several (10 to 12) reoccurring tickets per account for biweekly and monthly auditing purposes.. TheTeam Feeds Improvements
Team Feeds needs to show a feed of every action within the department. Currently it seems that the feed will only show a ticket that I've personally commented on or interacted with/followed. A feed should be that, a feed. As a manager I would like toBetter Security, Better User Experience | Help Center Update | June'25
As part of our commitment to enhancing user experience and security, we are happy to announce updates to our authentication mechanism. This update introduces several key enhancements designed to improve the password recovery process and streamline theUpload Logo to Account Page
It would be nice to set a logo for an AccountView Agent Collision on Ticket List Page
It would be nice from the ticket listing page (views) to see what agents are working on what tickets rather than having to click into each ticket throughout the day to see what agents are working on what tickets. This functionality would also be desiredRestrict user from viewing the detail standard view
Is there any way to restrict a user(it can be user-field-based) from viewing the detail standard view? Basically, I have created a canvas detailed view so that on some conditions I can hide some data from the users but the standard view client scriptUpload Picture to Contact
It would be nice to upload a profile picture to a contact.Ticket Status Colors
Can i change the colors of Ticket Status in the admin panel? Or even change the background of the entire cell of a Critical ticket? This way its easy for my agents to see a urgent ticket when it comes in. Right now everything is black text. Here RightAllowing Pictures for Client Contacts
Do you have any plans to allow us to add pictures of our client contacts? There is a silhouette of a person there now, but no way that I can see where I can actually add a picture of the individual.Paid Support Plans with Automated Billing
We (like many others, I'm sure) are designing or have paid support plans. Our design involves a given number of support hours in each plan. Here are my questions: 1) Are there any plans to add time-based plans in the Zoho Desk Support Plans feature? TheAgent name Alias
I am seeing that Full name of my staffs are written on every ticket response which is not good for some reasons. It is possible to user like this: Manny P. (First Name with Last Name's First Letter) or Manny (First Name) This is want we want to showUnable to add attachments to tickets through Desk API
I able to use the Desk API to generate tickets. However when I try to use the tickets/{ticketId}/attachments endpoint, I always get an Unauthorized error. My app has Desk.Tickets.ALL included in its scope so this should not be an issueWhat's wrong with this COQL?
What's wrong with this COQL? Code returns "invalid operator found". SELECT id, Name, Stage, Account, Created_Time, Tag FROM Production_Orders WHERE (Account = '4356038000072566002' AND Stage NOT LIKE '%customer%') ORDER BY Created_Time DESC LIMIT 200[Feature Request] Add support for internationalized top-level domains mail hosting
This is an important request to add support for internationalized domains mail hosting to https://www.zoho.com/mail/ In this case, that is only limited to domain name/mail address however currently it's already possible for us send mails etc using belowAdd Enable/Disable to Field Rules and other Rules
Hi, Sometimes I have rules setup for fields, and until I want to enable them for use, I can set the fields to Hidden but rules still show them, today you have to delete rules and then recreate them again, would be nice to have a toggle for Enabled/DisabledNext Page