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 updates, May-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:
- row1 = <mainForm_linkName>.<subForm_linkName>();
- row1.<textField_linkName> = "value1";
- row1.<multiSelectField_linkName> = {"value2", "value3"};
- row2 = <mainForm_linkName>.<subForm_linkName>();
- row2.<textField_linkName> = "value4";
- row2.<multiSelectField_linkName> = {"value5", "value6"};
- rows = collection();
- rows.insert(row1, row2);
- rec_id = insert into <mainForm_linkName>
- [
- <mainForm_textField_linkName> = "value";
- <subForm_linkName> = rows;
- ];
Dynamically insert rows in subform when your user's adding or editing data
- row1 = <mainForm_linkName>.<subForm_linkName>();
- row1.<textField_linkName> = "value1";
- row1.<multiSelectField_linkName> = {"value2", "value3"};
- row2 = <mainForm_linkName>.<subForm_linkName>();
- row2.<textField_linkName> = "value4";
- row2.<multiSelectField_linkName> = {"value5", "value6"};
- rows = collection();
- rows.insert(row1, row2);
- input.<subForm_linkName>.insert(rows);
Delete data from subforms
This is where the clear() task will come in handy. Syntax:
- 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
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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
Lakshman G
Damien
Philippe Boutin-Therrien
Fede
Business Scales
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 capabilitiesZoho 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. A
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
Composite items inside of composite items; bill of materials needed
Hi Zoho and Everyone, I am evaluating whether Zoho Inventory will work for my small business. I grow and harvest herbs and spices but also get from wholesalers. I use all these items to make herbal teas, but also sell them as individual items on my Shopify store and Etsy. I discovered the composite item bundling and am wondering if I could get some assistance since there is no bill of materials: Our herbal company's best selling tea is a sleepytime tea. Sleepytime Tea can be purchased in three weightsAutomation Series: Sync Task Status with Zoho Desk Tickets
In Zoho Projects, you can automatically close and reopen an associated Zoho Desk ticket when the status of a task is changed. This syncs the current state of the task with the support ticket without manual updates. For instance, a support team handlingAuto-Generate Line Numbers in Item Table Using HTML & CSS Counters (Zoho Books & Zoho Inventory Custom Templates)
<div> <style> /* Start counter from 0 inside tbody */ tbody#lineitem { counter-reset: rowNumber; } /* Increment counter for each row */ tbody#lineitem tr { counter-increment: rowNumber; } /* Show counter value in first column */ tbody#lineitem tr td:first-child::beforeDoes zoho inventory need Enterprise or Premium subsrciption to make Widgets.
We have Zoho One Enterprise and yet we can't create widgets on inventory.Zoho CAMPAIGNS working hours
Hi I use Campaigns Automation workflows to automate follow-ups to my Leads. I discovered this weekend that emails are being sent out on Sundays. How do I limit my Campaigns outgoing emails to business working hours? This is very important! Thanks, DDepositing funds to account
Hello, I have been using Quickbooks for many years but am considering moving to Zoho Books so I am currently running through various workflows and am working on the Invoicing aspect. In QB, the process is to create an invoice, receive payment and thenCreate Receipt of a Donation (not a sale)
We are a non-profit organization that receives general donations. How do I create a receipt of payment for the donor and categorize the payment as a Gift? I tried the method of creating an invoice; however that automatically created a "Sales" transactionFunction #2: Create a Deal in Zoho CRM when an Estimate is created in Zoho Books
For those who use Zoho CRM integrated with Zoho Books, here's a nifty function that helps you optimize your sales process by adding a Deal in Zoho CRM whenever an estimate is created in Zoho Books. Custom Function: To create the custom function, go toNew Custom View -Sorting the Custom fields
While creating a New Custom View in invoice , Customers, Bills ,expense etc , the sorting of custom fields are not available , a query function "order by / sort by " may also be included in Define new criteria module which will be more beneficial toGrouping Undeposited Funds to Move to other accounts
In the bank option it would be nice to check what transactions in undeposited funds I want to move to other accounts. Then while checking this it can accumulate totals and created whats essentially a deposit slip. Once the transaction is moved it shouldSync your CRM Tasks with Zoho Projects
Zoho Projects integration with Zoho CRM helps you manage your tasks more efficiently. You can create all project related activities right inside your CRM using this integration. Create new portal or associate an existing portal, add projects to the portal,Zoho CRM strips whitespace in text fields
When editing field text with multiple spaces: CRM - both UI and API trim / compress the whitespace to a single space when saving: Is this known / expected / documented behaviour?Custom Button makes scroll bar go down in report
I have a report with a Custom button called Completed. A colleague mentionned to me that when he pressed this custom button it scrolled down the page which is annoying since he want to stay at the same space on the repoort. There is no reload linked toQuickbooks Integrations Stopped Working
All of our Quickbooks integrations have stopped working. I am checking in to see if: a) this is a known issue b) if anyone else is having this issue. As usual, Zoho support is unavailable.Uplifted homepage experience
Editions: All editions. Availability update: 17th February 2026: All editions in the CA and SA DC | JP DC (Free, Standard and Professional editions) 23 February 2026: JP (All Editions) | AU, CN (Free, Standard, Professional editions) 27 February 2026:WeTravel + Zoho CRM Integration - Has Anyone Built a Connector or Extension?
Hi all, I'm exploring options for integrating Zoho CRM with WeTravel (booking & payment platform for tour operators). Zapier seems to be the common method but seems limited. I'm wondering if anyone in the community has developed a more comprehensive solution,Option in pipeline deal to select which hotel or branch or store if client has more than one local store
Hi, I would like to know if there is an option in the deal pipeline to select which hotel, branch, or store a deal is related to—if the company has more than one location. For example, I have a client that owns several hotels under the same company, andUndo article like/dislike
It seems to be not possible to undo your like/dislike for an article. Would be great if you can. Kind regards, HelenNested notebooks
Dear Sir/Madam, I would like to know if it is possible to nest notebooks. It would be very helpful when there are too many, as it would improve organization. Thank you for your response. Best regards.Tax 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 fromDynamically Fetching Lookup Field Display Value
I have an audit trail form, Audit_Changes, that tracks old vs new values across different forms. For lookup fields, the old/new value is the ID, but I also need the display value. What's a best practice for dynamically fetching the display value of theStop Scrolling, Start Asking: Meet Zia for Your Files
Hey everyone 👋 The era of 'scrolling and searching' is officially over. Whether it's a dense legal contract or a long meeting recording, searching for specific details is a massive time-sink. We think you should be able to interact with your files, notHow do I open MSG files in Microsoft Word?
If you want to open MSG files in Microsoft Word is not natively supported, as MSG is an email file format created by Microsoft Outlook. However, there are professional approaches to access MSG content in Word. First, open the MSG file in Outlook and copyUnable to charge GST on shipping/packing & Forwarding charges in INDIA
Currently, tax rates only apply to items. It does not apply tax to any shipping or packing & forwarding charges that may be on the order as well. However, these charges are taxable under GST in India. Please add the ability to apply tax to these charges.How to add packing & forwarding charge in purchase order & quotation???
Hello Zoho Team I have just started using Zoho for my company and I wanted to make purchase order. My supplier charges fix 2% as packing & forwarding on Total amount of material and then they charge me tax. For example, Material 1 = 100 Rs Material 2How to create a boxplot chart in Zoho Analytics?
Hi, I'm looking forward to making a boxplot in Zoho Analytics, either with all my data or with a time segmentation. No documentation or YouTube video explaining that was found. I guess this is a feature gap. How feasible would it be to add this to Analytics?What are the create bill API line item requiered fields
While the following documentation says that the line items array is requiered it doesn't say what if any files are requiered in the array. Does anyone know? API documentation: https://www.zoho.com/inventory/api/v1/bills/#create-a-bill I'm trying to addBudget function?
Has there been any progress on the development of a budget function in Zoho Books / Invoice? It's impossible to grow/run a business without some kind of budgeting. If I've missed something, apologies, but there seems little point in using Zoho Books without a budgeting function. Otherwise, I'm very impressed with the Zoho apps and the support. Keep up the great work.Where is the settings option in zoho writer?
hi, my zoho writer on windows has menu fonts too large. where do i find the settings to change this option? my screen resolution is correct and other apps/softwares in windows have no issues. regardsUsing IMAP configuration for shared email inboxes
Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configureWhen Does WorkDrive integrate with Books?
When Does WorkDrive integrate with Books?POP mailbox limits
If I am accessing a remote POP mail server using Zoho Mail is there a mailbox quota for the account or is it all related to my mail account storage limits?Warranty Service and Repair in Zoho FSM
Hi There, We are a retail store that sells products and also performs installations and repairs. Our field technicians handle this work. Some repairs are covered by manufacturers, who reimburse us for both parts and labour. In these cases, we performSPF: HELO does not publish an SPF Record
I am using Zoho mail. Completed all of the required prerequisites from the dashboard to avoid any issues with mail delivery. But when checking on mail-tester.com getting the following error. Can anyone help me solve this?Regarding the integration of Apollo.io with Zoho crm.
I have been seeing for the last 3 months that your Apollo.io beta version is available in Zoho Flow, and this application has not gone live yet. We requested this 2 months ago, but you guys said that 'we are working on it,' and when we search on GoogleActual vs Minimum
Hi all, I am sure I am not the only one having this need. We are implementing billing on a 30-minute increment, with a minimum of 30 minutes per ticket. My question is, is there a way to create a formula or function to track both the minimum bill vs theGenerate leads from instagram
hello i have question. If connect instagram using zoho social, it is possible to get lead from instagram? example if someone send me direct message or comment on my post and then they generate to leadKaizen #234 - Automating Deal Handoff with Zia Assistant API, Workflow, Deluge, and Widget in Zoho CRM
Hello all! Welcome back to a fresh Kaizen week. In this post, we will explore how to automate the deal handoff process in Zoho CRM using Zia Assistant API + Workflow + Deluge + Widgets. Here’s how the final output looks when a deal is reassigned 1. DealHow do you print a refund check to customer?
Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.Ability to assign Invoice Ownership through Deluge in FSM
Hi, As part of our process, when a service appointment is completed, we automated the creation of the invoice based on a specific business logic using Deluge. When we do that, the "Owner" of the invoice in Zoho FSM is defaulted to the SuperAdmin. ThisNext Page