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

                                                                                                          • ENTER key triggering Submit

                                                                                                            Is it possible to stopped the ENTER key from the mandatory triggering of the Submit button on Creator form? I want forms submitted "ONLY" when the Submit button is pressed. 
                                                                                                          • Is it possible to assign Client user to external task ON PROJECTS' TEMPLATES?

                                                                                                            Is it possible to assign Client user to external task ON TEMPLATES PROJECTS?
                                                                                                          • Draft & Schedule Emails Directly in Bigin

                                                                                                            Greetings, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to email in Bigin. We'll go over each one in detail, but here's a quick overview: Previously, you couldn't draft or schedule emails in Bigin, but
                                                                                                          • Cliq does not sync messages after Sleep on Mac

                                                                                                            I'm using the mac app of Cliq. When I open my mac after it was in sleep mode, Cliq does not sync the messages that I received. I always have to reload using cmd + R, which is not what I want when using a chat application.
                                                                                                          • Link to images

                                                                                                            I have added images in pages. I would like to link those images with linked in URL so that they open in new window. There is an option of image -> link but I am not able to use the same to open URL in new window. Please check the attached image. Can you
                                                                                                          • Canvas View - Print

                                                                                                            What is the best way to accomplish a print to PDF of the canvas view?
                                                                                                          • Respond faster and smarter with Zia in your IM Inbox

                                                                                                            You’re in the middle of a busy chat queue. New messages keep popping up. One customer sounds upset. Another is asking a long list of questions. You need context. You need speed. You need help. That’s exactly when Zia Insghts jumps into action. It shows
                                                                                                          • Meeting impossible to use when sharing screen

                                                                                                            he Meeting tool in Brazil is practically unusable when sharing anything, whether it’s a presentation or simple navigation. When accessed via Cliq, the situation gets even worse: even basic calls fail to work properly, constantly freezing. And as you are
                                                                                                          • Let's Talk Recruit: Meet Zia, your all-in-one AI assistant (Part-2)

                                                                                                            Welcome back to Let’s Talk Recruit series. In Part 1, we introduced Zia and how AI is reshaping the way recruiters work. This time, we’re taking a closer look at how far Zia has come and how each update continues to simplify your everyday tasks. When
                                                                                                          • WARNING : Smart list automatically unsubscribes your contacts.

                                                                                                            I created a smart list of my team members based on the criterion that their email domain was @_____. The list refreshed as expected — but it ended up unsubscribing almost all members of my team. I contacted support, but it took two months to get a reply,
                                                                                                          • Export Purchase orders as Excel

                                                                                                            Is it possible to export purchase orders as excel rather than PDF? Our suppliers don't want orders made in PDF, they need it to be excel
                                                                                                          • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (10/31)

                                                                                                            ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの中野です。 10月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら(無料):https://us02web.zoom.us/meeting/register/BGYTysOnSqa9LA9eY2IKww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは? Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした
                                                                                                          • Subforms in Stateless Forms

                                                                                                            Stateless Forms are very useful, but we can't build complex data entry pages without Subforms. Can this be implemented? This would make Stateless Forms truly powerful.
                                                                                                          • Custom Function not getting package details when triggered from Workflow Rules.

                                                                                                            I have a custom function for Packages that submits a form in our Creator app that we use to generate custom shipping labels (internal staff complete deliveries so we cannot generate shipping labels straight from Inventory). When the function is executed
                                                                                                          • Billing Preferences per Account

                                                                                                            Hello, We are trying to setup Billing Preferences in Zoho Desk to set up a different pricing per account. We charge different pricing per hour per customer/account. Account A = 100 per hour Account B = 125 per hour In the Billing Preferences in Time Entry
                                                                                                          • Time entry preview for custom time entry templates.

                                                                                                            Our company needed time entries in a specific format to document our client interactions. Since we are using a custom time entry layout, we have lost the "preview" on the time entry tab. Using the default time entry layout, you get a small preview of
                                                                                                          • Able to change project on timelog entries

                                                                                                            Ability to move the timesheet entry from one project to another. When a user adds a wrong entry a manager can change/update the timesheet entry to the correct project.
                                                                                                          • Knowledge base: The nitty-gritty of SEO tags

                                                                                                            A well-optimized knowledge base with great SEO can benefit your company by allowing customers to find help articles and support resources using search engines. This enables customers to quickly and efficiently find the information they need without direct
                                                                                                          • Full Text Customization & Translation in SalesIQ Chat Widget Settings

                                                                                                            Dear Zoho SalesIQ Team, Greetings, We would like to request an important enhancement to the chat widget customization options in Zoho SalesIQ. Current Limitation: At the moment, only some of the text shown in the chat widget is editable or translatable
                                                                                                          • Introducing swipe actions in the Zoho CRM Android app

                                                                                                            Hello everyone, How much time do you spend each day on your list view? Probably quite a lot. Since it's such an important part of your work, wouldn't it be easier if you could take action directly from your list view instead of opening each record one
                                                                                                          • Content Security Policy

                                                                                                            Is there a place in ZOHO CRM to add a Content Security Policy to allow for a call to a google.com map, from inside our current app? Or, how do I resolve the issue below?? jquery.js:1 Refused to load the script 'https://maps.google.com/maps/api/js?v=3.41&libraries=places&sensor=true&key=AIzaSyAyQzKeKSbLci4LwZhn9oXvtCkbUo1Ae4g&callback=map_loader'
                                                                                                          • Option to select location?

                                                                                                            As a business coach, I meet with clients at various public locations. I have two or three pre-determined locations that I meet at. I would like the client to choose the location when booking an appointment. Is there a way to do that with a single service, or is the best way to accomplish this by creating one service for each location offered?
                                                                                                          • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

                                                                                                            Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers
                                                                                                          • Provide a standard structure to your content using article templates

                                                                                                            Hello everyone, When multiple writers work on different documents, maintaining a standard structure can be challenging as each of the writer follows a different writing style. However, when the structure, tone, and format of every document is different,
                                                                                                          • How to update custom multi-user field in Zoho Projects?

                                                                                                            I'm trying to update custom multi-user fields in Zoho Projects via a Deluge function in CRM. The code I have so far is below. It works for updating standard project fields and single-line custom fields, but it does not work to update multi-user fields.
                                                                                                          • Accessibility Spotlight Series - 1

                                                                                                            Every user interacts with products differently, what feels intuitive to one may be challenging for another. Addressing this, accessibility is built into Zoho Project's design philosophy. This helps users navigate and perform actions with ease irrespective
                                                                                                          • Projects Tasks Not Showing Dependencies

                                                                                                            I'm clicking on tasks and the popup to add dependencies isn't showing. I can't disconnect the nodes either. For some reason when I slide a task backwards it says it cannot go before a predecessor, even though there is not predecessor. Double clicking
                                                                                                          • Deprecation of C4 endpoint URLs

                                                                                                            Note: This post is only for users who are still using the C4 endpoints. Hello everyone, At Zoho Creator, we're committed to continuously enhancing the security, performance, and capabilities of our platform. As part of this ongoing effort, we'll be deprecating
                                                                                                          • Introducing AWS authentication for connections in Deluge

                                                                                                            Hello everyone, We're incredibly excited to announce the all-new AWS authentication for connections in Deluge! This highly anticipated feature simplifies connecting to Amazon Web Services, opening up a world of possibilities and allowing you to seamlessly
                                                                                                          • Timeline Tracking Support for records updates via module import and bulk write api

                                                                                                            Note: This update is currently available in Early Access and will soon be rolled out across all data centers (DCs) and for all editions of Zoho CRM. The update will be available to all users within your organization, regardless of their profiles or roles.
                                                                                                          • Customize User Invites with Invitation Templates

                                                                                                            Invitation Templates help streamline the invitation process by allowing users to create customized email formats instead of sending a one-size-fits-all email. Different invitation templates can be created for portal users and client users to align with
                                                                                                          • ListObjects is recognized by VBA

                                                                                                            Sub addNewRow() Dim ws As Worksheet ' Set your worksheet name Set ws = ThisWorkbook.Sheets("Invoice") ' Set your table name (change "Table1" to your actual table name) ws.ListObjects("InvItems").ListRows.Add End Sub I am getting Unknown function: Li
                                                                                                          • KPI Widget dashboard select periods

                                                                                                            I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects
                                                                                                          • Need a way to secure Prefill URLs in Zoho Forms (hide or encrypt prefilled values)

                                                                                                            Hi everyone, I often use Zoho Forms with prefilled URLs to simplify the user experience — for example: https://forms.zohopublic.com/.../form?Name=David&Amount=300 However, the problem is that all prefilled values are visible and editable in the link.
                                                                                                          • Can’t send emails from Zoho CRM after adding a new user — verification codes not received

                                                                                                            Hi everyone, We recently added a new user to our Zoho CRM account and purchased an additional license. Since then, we haven’t been able to send any emails from Zoho CRM. Our Zoho Mail accounts are working perfectly, we can send and receive emails directly
                                                                                                          • CRM for email in Outlook: how to ignore addresses?

                                                                                                            We’re using the "Zoho CRM for email" add-in for Outlook. When opening an email, the add-in displays all email addresses from the message and allows me to add them to the CRM or shows if they’re already contacts. However, sometimes people listed in To
                                                                                                          • Scheduling Calls in CommandCenter / Blueprints

                                                                                                            I would love it if you could add a function to schedule a call in the lead's record for a future date. I know you can add a Task by going to Instant Actions > Task and completing the form: These tasks go into the lead's record under Open Actions. But
                                                                                                          • Quickly send emails and sync conversations with custom email addresses in CRM

                                                                                                            Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all
                                                                                                          • Zoho製品と生成AIツールの活用について

                                                                                                            いつもありがとうございます。 弊社では、Zoho Oneを契約し、CRMを軸として、見込み客の管理から商談、その後の受注や請求の管理、サポート業務(Desk)、業務データのレポーティング(Analytics)などを行っております。 Zohoサービス自体には、Ziaというツールが搭載されているかと存じますが、それ以外の外部の生成AIツールと連携した活用などもできるのでしょうか?具体的には、CopilotなどがZohoに登録されているデータや情報を見て、対話型で必要なデータを提示してくれたり、商談や蓄積されたメモなどを分析してユーザが知見を得られるような活用ができないか、と考えております。
                                                                                                          • Work with Contacts who use multiple Emails / Manage obsolete Email addresses without loosing Emails in Context

                                                                                                            Hello List Work with Contacts who use multiple Emails Only after 1 week in using Zoho CRM productively we have contacts which randomly use 2 different email addresses. From the concept I've understood that Zoho CRM offers two email fields which are recognized
                                                                                                          • Next Page