Upcoming updates - Mar 2019 - part 1
Hello App Creators,
In the coming days of March, 2019, the Zoho Creator team will be rolling out the following feature updates:
- Zia-powered smart data import
- Auto-refresh of related elements in pages
- Ability to drill down data points in pivot charts
-
Application of field-level permissions when viewing related data
-
Domain restriction
- - - - - -
Zia-powered smart data import
Applicable to : Zoho Creator 5
This improvement will bring you:
- Data cleansing capabilities powered by Zia — Zoho's AI assistant for business
- Support for importing subform, name, and address data
- An import interface that enables a spreadsheet app-like experience
Note: These improvements will be available during app creation and not when you create a form by importing a file.
Zia-powered data cleansing capabilities
Before you upload your file and create an app, it's a best practice to tweak the data in it so that it fits the model of tables in a relational database. To assist here, the new Zia-powered import interface will enable you to:
- Filter the data in a sheet. Only the filtered data will be imported into the application.
- Find & Replace data
- Perform data-cleansing operations in the sheets, which are grouped under the Refine Data option:
- Fix inconsistent spellings
- Fix missing values
- Split the data in a column into two by defining their delimiter
- Merge columns
- Explore the frequency distribution of values in a column
Importing subform data
Before you upload your file, you'll have to ensure that the main or parent form data and subform data are in separate sheets.
In the import interface, checking a sheet's Make it as subform checkbox is how you'll define that it contains subform data. Upon doing so, you'll have to:
- Select the sheet that contains its parent data. This'll become the parent or main form after the import operation. Let's call this the "parent sheet".
- Select the column in the "parent sheet" that identifies each row uniquely.
- Select the column that's the parent row identifier in the current sheet (which you're marking as subform)
Importing name and address data
You'll be able to map the Name or Address field to a column via its Field type option.
Name/address data can be present in a single column or span multiple columns. When it spans multiple columns, you'll be able to map the name subfields (Prefix, First Name, Last Name, Suffix) and address subfields (Address Line 1, Address Line 2, etc.) to the respective columns in the sheet.
Spreadsheet app-like import interface
Currently upon importing, the sheets in your file are displayed as collapsible sections that show you a preview of the data in them. They'll now be displayed as tabs — like sheets in a spreadsheet. In addition to the existing abilities of renaming and selecting/deselecting sheets, you'll be able to:
- View the data in all the rows in the sheets
- Sort the data in your sheets. (This sorting won't be applied in the app you create. It's only to let you view the data in the required order.)
- Delete rows
- Undo and redo actions
- - - - - -
Auto-refresh of related elements in pages
Applicable to : Zoho Creator 5
A common usage of pages is to build Dashboards that display key performance indices (KPIs). A common requirement in business and productivity apps is for the dashboards to show the latest data. This was so far being achieved via workflows by reloading the page after a record was created, updated, and deleted.
We've stepped up in this regard — page elements corresponding to an embedded form will automatically be refreshed when your users create, update, and delete records in that form. Things to note:
- The elements that will be refreshed are panels, charts, reports (except pivot reports)
- The create, update, and delete operations must happen from the same window. Opening the form (from the page) in a pop-up or new window will not auto-refresh the related elements in that page.
- - - - - -
Ability to drill down data points in pivot charts
The ability to drill down data points in pivot charts enables users to visualize the underlying data points as a new chart. We'll be adding this ability to the View underlying data property of pivot charts:
- This property will be renamed as View underlying data and drill down
- Upon checking this, your users will additionally see the Drill Down option, clicking which will enable them to visualize the underlying data points as a new chart
- - - - - -
Application of field-level permissions when viewing related data
Currently field-level permissions aren't strictly enforced when users view related data — data fetched via lookup and subform. After this is fixed:
- In the quick view of a report, users will be able to view only those related fields that they have permission for
- In the detail view of a report, users will be able to view a related data block only when they have permission to view data in the corresponding form. Also, they'll be able to view only those fields of the related form that they have permission for.
- - - - - -
Domain restriction
Applicable to : All
Enterprise-grade applications, especially those that handle and store sensitive data, face a variety of threats. It therefore becomes essential to ensure that an email address from an external domain does not even get added as a User or Developer in such applications.
Welcome Domain Restriction. This feature will ensure the above said. Things to note:
- Domain restriction will be available at the app level
- You'll be able to enable this only when your Zoho account is based on your own domain
- - - - - -
We hope you found this post informative. Let us know what you think about these updates by commenting below.
Best,
Lakshman | Zoho Creator
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
Lakshman G
BenoitGD
Lucian
Damien Cregan
Steve Shepherd - 100rails
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
SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET
TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHOAI in Zoho Workplace: A Sneak Peek into What’s Coming!
Hello everyone, We’re super excited to share something we’ve been working on and we want you to be part of it! You may have seen our announcement blog post introducing a major evolution in how AI works within Zoho Workplace. Want to be among the firstDisplay Client Name in Zoho Creator Client Portal Dashboard
Hello Zoho Creator Team, We hope you are doing well. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for providing a personalized portal experience. However, there is currentlyMeet Canvas' Grid component: Your easiest way to build responsive record templates
Visual design can be exciting—until you're knee-deep in the details. Whether it's aligning text boxes to prevent overlaps, fixing negative space, or simply making sure the right data stands out, just ironing out inconsistencies takes a lot of moving parts.Best way to share/download presentation files in Zoho without losing formatting?
Hello Zoho Community, I often work with PPT/PDF files in Zoho Docs and share them with colleagues. While PDFs usually give a direct download option, I’ve noticed that PPT/PPTX files sometimes only open in the viewer without a clear download link. Is thereWorkflow Failure - Notifications
Good afternoon, I have just experienced an error whereby a Workflow failed, for a reason currently unknown. The problem is that one of my users had to flag this manually (thankfully he's very thorough) and this otherwise would have flown under the radar.Introducing Bin Locations In Zoho Inventory
Hello users, We are excited to let you know that your wait for the Bin Locations feature has now come to an end! Yes, you heard us right! We are here to introduce the much-awaited Bin Locations now in Zoho Inventory. But before we dive into the featureError "Invalid client task found corresponding properties" only when triggered from workflow ?
Hi All, I am facing an error message I never encountered previously: Error in executing On Add - On Load script Error in executing thisapp.get_all_projects_api_call function. Line:(2) Error in executing thisapp.getAccessTokenFromRefreshToken function.How to interpret Campaign report statistics - definitions/explanation
I am trying to make sure I understand the Campaign report correctly Do you have a list of definitions for: Delivered - it has reached the recipient's inbox Campaign reach - is this the number that have opened the campaign email? Unique Opens Clicks/OpenFeature request - pin or flag note
Hi, It would be great if you could either pin or flag one or more notes so that they remain visible when there are a bunch of notes and some get hidden in the list. Sometimes you are looking for a particular name that gets lost in a bunch of less importantSchedule a Call by Date and Time when a specific lead status is selected
Hi Wanting to create a workflow where a call can be scheduled by date & time when a specific lead status is selected. Can only currently set the date by Due Date - Trigger Date - Plus 'x' day(s) ThanksZoho CRM's Copy Customization functionality now works across DCs, for customized accounts, and more
Availability This feature is available in Standard, Professional, Enterprise, and Ultimate editions. These changes have been rolled out to all users in all DCs. For more information, please refer to these help documents: Overview | Instructions HelloHow can I bold text on Zoho Forms submit buttons?
In the old theme builder, I could bold the text on a form's submit button. With the new theme builder, I can only change the text of the header or fields in the form, and not the button itself.5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (10/31)
ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの中野です。 10月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら（無料）：https://us02web.zoom.us/meeting/register/BGYTysOnSqa9LA9eY2IKww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的としたHiding Pre-defined Views
You can enhance Zoho with custom views - but you cannot hide the pre-defined views. Most users focus on 4 or 5 views. Right now for EVERY user EVERY time they want to move to one of their 4 or 5 views - they have to scroll down past a long list of pre-defined views - we don't use ANY of the pre-defined views. Adding the feature to allow a predefined view to be hidden completely or only visible to certain users would be a big improvement in usability for Zoho CRM. This feature is already availableRich-text fields in Zoho CRM
Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile[Integration Edition] Deluge Learning Series – Third-Party Integrations with Deluge | October 2025
We’re excited to continue this three-month edition of the Deluge Learning Series: Session 1 – Integrating Zoho Apps with Deluge Using Built-In Integration Tasks Session 2 – Integrating Zoho Apps with Deluge Using invokeURL and invokeAPI Session 3 – Third-PartyFeature Request: Tag, Search, and Report on Individual Private Comments
Zoho Desk Team, First, I want to say that we are extensive users of Zoho Desk and it is a core part of our support operations. We rely heavily on the private comments feature for internal communication, knowledge sharing, and maintaining a clear historyZoho CRM Community Digest - August 2025 | Part 2
Hello Everyone! Here's a quick round-up of handy tips, clever workarounds, and product updates from late August. Product Updates: Meeting Enhancements in Zoho CRM! Track whether a meeting is online, in-office, or at the client’s location using the newAssistance Needed: Ticket Status Not Updating and Sorting by Last Customer Reply in Zoho Desk
Hello, I’m facing two issues in Zoho Desk that I’d like your guidance on: Ticket Status Not Updating: When a customer replies to a ticket, the status does not change to Reopened. Instead, it remains in Waiting on Customer, even after the customer’s responseRound robin
Hi, I'm trying to set up a round robin to automatically distribute tickets between agents in my team but only those tickets that are not otherwise distributed by other workflows or direct assignments. Is that possible and if so which criteria should ITime Entry Notifications
Hi All - I have support staff who place notes of their work in the time entry section of Zoho Desk. Is there a specific workflow or setting I need to enable to have the ticket holder updated via email when an entry is saved?Change text in help desk
Hi, Please let me know how can i change the this text, see screenshot.Customer happiness customisation
Hi, I was wondering if it's possible to somehow customise to whom and when customer happiness request is sent? Can you enable it only for selected tickets for example based on workflow or any other criteria (customer name, tag or anything else)? AlsoSign in process is beyond stupid. I'd rather plug my phone into USB and copy files than sign in to this POS.
792 clicks and fields to fill in just to get into a 3rd rate app is too stupid for me.No Zoho Support Response in Months
I want to say that I love Zoho FSM, Books, and CRM, but the support is scary bad. About 2-3 months ago, I emailed Zoho FSM support with two specific issues I needed help with, and I have still not received one single response. I also submitted a supportHas anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?
Hi all, I’ve been experimenting with building my own AI support assistant and wanted to see if anyone here has tackled something similar within Zoho. Right now, I’ve set up a Retrieval-Augmented Generation (RAG) pipeline outside of Zoho using FAISS. ItNull
If a result is null how do I make it so that a custom error pops up instead of the default error? Can someone write an example as if I were using the script builder?Format a "return" message
Good day, Is there a way to format the message of the "return" function in CRM deluge script?Change Last Name to not required in Leads
I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions forHaving Trouble Opening The Candidate Portal
Recently am having trouble opening the Candidate Portal. It keeps loading but cannot display any widgets. Tried Safari, Chrome and Edge. Non of them work. Please solve the problem ASAP.Tip of the Week - Spot Risky Sales with Conditional Formatting
In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to applyHow do I duplicate / copy a campaign
I am evaluation Zoho Campaigns and sent an email to one of my personal email accounts from Zoho Campaigns. It went into my junk file in Hotmail. I want to duplicate that same (1-page) campaign and send it to another of my personal accounts to try toFor a Bill, can "Pay via Check" - Can we also "Pay via Check" when documenting refund for payment?
We really like when we have a Bill in Zoho Books that we can record payment by selecting "Pay via Check" and that will cut the check for us from Zoho Books. However, when we have to write checks as a result of invoice overpayment, we can not select "PayCreator Change History: Ways to improve
Hi Everyone, Recently been working in developing this change history(an idea from Zoho Forms) - unlike forms that you can this with a click but using Creator, we can use "old" keyword. The concept I come up with is to put the result in a table however,Currency selector (based on variable) usage in comparsion
Hi, I've developed a currency selector based on the following topic, and it's working well in pivot tables and charts: https://help.zoho.com/portal/en/community/topic/how-can-i-allow-my-users-to-choose-a-currency-for-the-dashboard I also have a comparisonSuitability of Zoho One (Single User License) for Multi-State GST Compliance & Cost Analysis
Hello Zoho Team, I am an e-commerce business owner selling on platforms like Amazon, Flipkart, and Meesho, and I'm currently using their fulfillment warehouses. I have two GSTIN registrations and am planning to register for an additional 2-3 to expandadd employees and customiz
I want a Zoho software to track employees record. I logged in a demo so now I tried adding employee, first thing when I click on add employee it takes me to a page where it says add user maximum 10 users, my first doubt why users I don't want employeesInactive User Auto Response
We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similarZoho People Attendance Module - Split Shifts
Hello, Our business employs a number of college students who often split their workdays between work hours and class schedules, resulting in split shifts. For example: Employee 1 works 9am to 11:30am and then leaves for class, returning to work at 3pmNext Page