Upcoming updates - July 2019

Upcoming updates - July 2019

Hello App Creators,

We’re here with another set of updates.

During Jul-2019, the Zoho Creator team will be rolling out the following feature updates:
  • subform.insert() and subform.clear()
  • Zia-powered smart data import during form creation
  • Ability to control rendering of HTML content in Formula field
  • Lookup data from Radio and Drop down fields
  • Setting background images for panels
Here are the links to the recent posts in this series: Apr-2019 updatesMay-June updates. Refer to our changelog for the complete list.

- - - - - - - - - - -

subform.insert()  and  subform.clear()

Yes! It’s here!

We’ll be introducing two Deluge tasks — subform.insert() and subform.clear() — that’ll enable you to dynamically add and manage data in your subforms. You'll be able to address the following scenarios:
  • Insert data into subform as part of the add record Deluge task
  • Dynamically insert rows in the subform when your user's adding or editing data
  • Delete data from subforms
To achieve these, we've introduced the Collection data type, which can hold a list of values or a map. Let's take a look at these scenarios with syntax.

Inserting data into subform when you're adding a record in the main form

The add record Deluge task will now support adding rows in subforms. Syntax:
  1. row1 = <mainForm_linkName>.<subForm_linkName>();
  2. row1.<textField_linkName> = "value1";
  3. row1.<multiSelectField_linkName> = {"value2", "value3"};
  4. row2 = <mainForm_linkName>.<subForm_linkName>();
  5. row2.<textField_linkName> = "value4";
  6. row2.<multiSelectField_linkName> = {"value5", "value6"};
  7. rows = collection();
  8. rows.insert(row1, row2);
  9. rec_id = insert into <mainForm_linkName>
  10. [
  11.     <mainForm_textField_linkName> = "value";
  12.     <subForm_linkName> = rows;
  13. ];

Dynamically insert rows in subform when your user's adding or editing data
  1. row1 = <mainForm_linkName>.<subForm_linkName>();
  2. row1.<textField_linkName> = "value1";
  3. row1.<multiSelectField_linkName> = {"value2", "value3"};
  4. row2 = <mainForm_linkName>.<subForm_linkName>();
  5. row2.<textField_linkName> = "value4";
  6. row2.<multiSelectField_linkName> = {"value5", "value6"};
  7. rows = collection();
  8. rows.insert(row1, row2);
  9. input.<subForm_linkName>.insert(rows);

Delete data from subforms

This is where the clear() task will come in handy. Syntax:
  1. input.<subForm_linkName>.clear();
It'll behave differently based on the type of subform:
  • When you operate the clear() task on a blank/inline subform, it'll delete all the rows in that subform
  • When you operate the clear() task on a subform that itself is a form, it'll just delete the relationship between the main form's record and related subform records. Records in the subform will remain intact.
- - - - - - - - - - -

Zia-powered smart data import during form creation

Applicable to: Zoho Creator 5

Remember the Zia-powered smart data import capabilities that were recently introduced w.r.t. app creation? They’ll now available during form creation as well.

Additionally, the following abilities will be introduced:
  • Edit a cell’s value by double-clicking it
  • Edit identical cells in a column by right-clicking 
  • Enable the No duplicate values property for a column 
  • Enable the Mandatory property for a column
  • Establish relationship with data in existing forms via lookup field
- - - - - - - - -

Ability to control rendering of HTML content in Formula field

We're introducing the Show value in reports as field property for the Formula field. It can be set with the value Plain text or Rich text.

Having the formula field display data as plain text may benefit the performance of displaying its data in reports. How? — Late last year we upgraded our security framework w.r.t. processing HTML and CSS content. This ensures that only valid/allowed tags and attributes are rendered in your apps. Therefore, choosing to display the formula field's data as plain text will let the system skip consulting this white list. Even if HTML tags are present, they'll be treated and displayed as characters.

Note:
  • Existing formula fields will be set to show their data as Rich text.
  • Formula fields that you add after this update will be set to show Plain text. You’ll have to set it to Rich text to have that formula field render HTML tags in reports.
- - - - - - - - -

Lookup data from Radio and Drop down fields

In other words, you’ll be able to include radio and drop down fields as the lookup's Display fields.

- - - - - - - - -

Setting background images for panels

Applicable to: Zoho Creator 5

You’ll be able to upload an image and set it as the background for a panel or a cell in a panel. The panel or cell’s content will appear over (or “in front of”) the image.

- - - - - - - - -

Let us know what you think about these updates.

Best,
Lakshman | 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

                                                                                                          • Markdown for Desk?

                                                                                                            Hi, my company wants to use markdown for formatting text in Desk (in all modules there, especially Tickets and Helpcenter). Zoho already offers use of markdown in several products (see https://help.zoho.com/portal/en/kb/backstage/microsite-guide/formatting-with-markdown/articles/formatting-with-markdo)
                                                                                                          • Change Currency symbol

                                                                                                            I would like to change the way our currency displays when printed on quotes, invoices and purchase orders. Currently, we have Australian Dollars AUD as our Home Currency. The only two symbol choices available for this currency are "AU $" or "AUD". I would
                                                                                                          • Calendar not working

                                                                                                            Are we the only ones. On any browser we cannot click on any of our calendar appointments and get them to open. They just make the browser loop. WE have reached out and have been told they are working on it. The office staff are really stuck. The point
                                                                                                          • Tip of the week #16 - Search and filter threads based on criteria

                                                                                                            Zoho TeamInbox lets you search and filter threads with any information that you have about the thread. You just have to input the criteria and Zoho TeamInbox will list all the threads that match the condition.   Firstly, there is a global search you can
                                                                                                          • WhatsApp Message Template Quick Reply Buttons

                                                                                                            Hello, I created my first Message Template to overcome the 24-hr messaging window and it was approved by WhatsApp/Meta. When I go to Meta, I also see that template brought from Zoho Desk, and used it via Zoho Desk IM. However, I notice that when in Meta's
                                                                                                          • Account in Quick View Filter

                                                                                                            I have a report that I often run against a specific Account. Every time, I have to go into the edit menu and change the Advanced Filter. I would prefer to use the Quick View Filter, but it does not allow me to use the one and only field that makes any
                                                                                                          • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                            The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Latest update
                                                                                                          • Collapsible Sections & Section Navigation Needed

                                                                                                            The flexibility of Zoho CRM has expanded greatly in the last few years, to the point that a leads module is now permissible to contain up to 350 fields. We don't use that many, but we are using 168 fields which are broken apart into 18 different sections.
                                                                                                          • Set Display for Numbers/Currency/etc with Client Script/Customization in Canvas List Page

                                                                                                            Is it possible to set a display mask for a number/currency field using Client Script or customization? I have custom fields that I would like to keep the decimal places for calculation purposes, but do not need them displayed to the user. So 101.3568
                                                                                                          • 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
                                                                                                          • Time Entries in Analytics

                                                                                                            I am trying to import a zoho sheet into zoho analytics. In my sheets one of the columns has "time Entries" in this "format HH:MM am/pm" example 11:00 PM. After import, i noticed that analytics converted the time to "00 Jan 1900 23:00:00".. how do i maintain
                                                                                                          • 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?
                                                                                                          • Automatic Matching from Bank Statements / Feeds

                                                                                                            Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
                                                                                                          • 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.
                                                                                                          • Zia Profile Summary now supports six languages and responds faster

                                                                                                            After numerous customer requests, we’ve expanded Zia Profile Summary to do more than just summarize resumes quickly. It can now summarize them in six different languages and deliver results even faster. What’s New 1. Extended language support Zia can
                                                                                                          • Nimble enhancements to WhatsApp for Business integration in Zoho CRM: Enjoy context and clarity in business messaging

                                                                                                            Dear Customers, We hope you're well! WhatsApp for business is a renowned business messaging platform that takes your business closer to your customers; it gives your business the power of personalized outreach. Using the WhatsApp for Business integration
                                                                                                          • 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 Product Restriction

                                                                                                            we have different types of products. 1) Very bulky items like plywood. 2) Too delicate items like glass These type of products we want to sell to local customers. Other products we want to supply all over India. There should be an option to restrict products
                                                                                                          • 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.
                                                                                                          • Error AS101 when adding new email alias

                                                                                                            Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
                                                                                                          • Download a writer template as .docx instead of .pdf.

                                                                                                            I have been trying to implement a feature to download a writer template as a .docx and got it working partly but it isn't good. Earlier I checked our code and I saw openurl("https://crm.zoho.com/crm/org121314/specific/Template.do?action=print&step=pdfPreview&id="
                                                                                                          • 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,
                                                                                                          • Feature Request: Reviews

                                                                                                            Any chance we could get a "Reviews" element to put on sites? It should be extremely simple to do. Basically just take the comments box and add an option for a star rating. At the very least, it would be nice to have more customization options for the comment box so the text could be changed from "Comments" to "Reviews". I've looked at a bunch of embeddable review widgets but nothing meets my needs so this would be a great feature to have added to the site builder.
                                                                                                          • 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
                                                                                                          • Next Page