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
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 3pmZoho One subscription
we have got Zoho CRM for 3 users and we paid for the app , and we have still 9 months to go , but if we join Zoho one , does it mean the payment for that subscription would be a waste? Please help. Thanks.How Zoho CRM Can Enhance Your Faucets Accessories Business Operations?
In today's competitive market, having a reliable CRM system is crucial for managing customer relationships and streamlining business operations. For businesses in the faucets accessories niche, Zoho CRM offers powerful tools to help manage everythingDashboard
I’m currently working on a project using the Zoho IoT Cloud with an ESP32 and MQTT. I’ve successfully connected the ESP32 to Wi-Fi and MQTT, and the data from the ESP32 is displayed in the telemetry section of the cloud. However, when I try to createCan i connect 2 instagram accounts to 1 brand?
Can i connect 2 instagram accounts to 1 brand? Or Do i need to create 2 brands for that? also under what subscription package will this apply?Zoho Forms - Improved Sub-Forms
Hi Forms team, I'm helping a client move from JotForms to Zoho Forms and I've found another opportunity for improvement. In the below screenshot, JotForm left and Zoho Forms right. The Zoho Forms Sub-Form is quite a poor visually. There is no way to makeWhat's New in Zoho Billing | Q3 2025
Hello everyone, We are excited to share the latest set of updates and enhancements made to Zoho Billing in Q3 2025. From the latest GST updates to multi-level discounting, Zia-powered report summaries, and customizable web forms, these updates are designedHow to Delete Personal Account Linked with My Mobile Number in past or by someone else
How to Delete Account Created with My Mobile Number in past or by someone else This is creating issues in making or sync with my credentials mobile and email address..WhatsApp Business Calling API
Dear Zoho SalesIQ Team, I would like to request a feature that allows users to call WhatsApp numbers directly via Zoho SalesIQ. This integration would enable sending and receiving calls to and from WhatsApp numbers over the internet, without the needDoes Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?
Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?Marketer's Space - Going beyond basics: Smarter ecommerce marketing with Zoho Campaigns
Hello Marketers, Welcome back to this week's Marketer's Space. In the last post, we discussed the basics of email marketing and how to get started with email marketing in ecommerce. In this part, we'll dive much deeper into some other advanced featuresConnecting two modules - phone number
Hi, I’d like some guidance on setting up an automation in Zoho CRM that links records between the Leads module and a custom module called Customer_Records whenever the phone numbers match. Here’s what I’m trying to achieve: When a new Lead is createdZoho Marketing Automation 2.0 - Landing Page function not working
Dear Zoho Team, I am working on implementing Zoho Marketing Automation 2.0, and am now looking into the section "Lead Generation". If I open the "Landing Pages" section, I immediately get an Error code: Error: internal error occurred. Can you help meUnable to use Sign "You have entereed some invalid characters"
Unable to use Sign "You have entered some invalid characters" I do not see any invalid characters. The text in "Leave a Note" is plain text which I entered directly into the field. See attached screenshotElevate your CX delivery using CommandCenter 2.0: Simplified builder; seamless orchestration
Most businesses want to create memorable customer experiences—but they often find it hard to keep them smooth, especially as they grow. To achieve a state of flow across their processes, teams often stitch together a series of automations using WorkflowMessages not displayed from personal LinkedIn profile
Hello. I connected both our company profile and my personal profile to Zoho social. I do see all messages from our company page but none from my private page. not even the profile is being added on top to to switch between company or private profile,"Performed changes in the query is not allowed due to following reason" when adding columns or reordering data
I'm trying to make changes to a query but every time i try to save it i get this error message. I'm not touching the data it's flagging. All I've tried to do is reorder a couple of fields and add a new one. Why won't it let me do this? It's a core queryOnboard new users easily with native screen recording in Zoho Projects Plus
Communication involving both visual and audio elements tends to capture more interest among the audience. Whenever we onboard new employees to the organization, the task of engaging them in the induction sessions, and keeping the spark going in theirRequest to Add Support for PDF Templates and More Flexibility in Email Editor
Hi Zoho Campaigns Team, I hope you're doing well. I wanted to share some feedback and request a few improvements in the Email Template feature of Zoho Campaigns. Right now, we can create email templates using the HTML editor, which is helpful. But we’reCan you stop Custom View Cadences from un-enrolling leads?
I'm testing Cadences for lead nurture. I have set un-enroll properties to trigger on email bounce/unsubscribe, and do NOT have a view criteria un-enroll trigger. However, help documents say that emails are automatically un-enrolled from a Cadence whenZoho Desk Android and iOS app update: Agent detail overview
Hello everyone! We’ve introduced agent detail overview on the Zoho Desk Android and iOS app update. With this feature, you can get a complete view of agent’s tickets, response times, logged hours (for both tickets and activities), customer happiness ratingsBlog Widget: Show recent blog posts on my homepage
Hey there I am using the Zoho Sites Blog feature. On my homepage, on the bottom I'd like to have a featured content section where I show some of my blog posts (selected, most recent, filtered by category and so on...). It would be nice to have a blogYouTube Live #2: Agreement Intelligence with Zoho Sign's eSign AI assistant
Hi there, We're back again with our YouTube live series and this time, we'll take you through our holistic agreement intelligence powered signature workflows. Struggling to draft an agreement? Need help double-checking clauses and going through complicatedHow to iterate through excel data using zoho rpa
I wanted to iterate or loop through excel data ( datatable). How can i do thatZoho Commerce
Hi, I have zoho one and use Zoho Books. I am very interested in Zoho Commerce , especially with how all is integrated but have a question. I do not want my store to show prices for customers that are not log in. Is there a way to hide the prices if notMass (Pull back) (Close WOs) (Close APs)
Hi develop team. Just idea because Zoho FSM is great but its too manual. we have a lot of task to do every day and the system needs to have more features to automatic our tasks. I need to close several WOs, APs and Pull Back per day. Please we need massCustomising Zohidesk portal default widgets
Hello, I'm wondering how could I customise the default widgets such as "popular topics", "popular articles" using CSS or to make the tiles at the bottom match the ones that I made in the picture attached. I have made some custom widgets and edited themIf there’s a batch at the end, the ‘mark as inactive’ function doesn’t work.
when my batch has a date to batch end and I "mark as inactive" he batch does not obey the status and reactivates the batch.Seamless multilingual messaging and tone control in Zia IM Composer
Hello everyone! Managing customer conversations across multiple languages can be time-consuming. Using Zia in the Instant Messaging (IM) Composer helps you overcome this by providing tools to translate content, adjust your tone, and refine your messagesAdvanced Deluge help needed with custom function and COQL limits
I have a scheduled function that takes a snapshot of specific metrics and saves them to a custom module. However I'm struggling with the limits of COQL. I attach my full code, but an example of the issues I'm having is that it's erroring with a 'LimitTip of the Week - Conditional Formatting Chart
Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend. Zoho Analytics allows you toZoho Learn - AI Translate
Hi Learn team, I had a situation today where I was providing training to a client team and I had written articles into their Zoho Learn to support their learning. I realised that one of the team members was a non-native English speaker and they were strugglingPayroll In Canada
Hi, When can we expect to have payroll in Canada with booksPower of Automation :: Auto-Sync Custom Date Field Between Related Tasks via Blueprint Transition
Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automateIntroducing auto-upgrade in Zoho LandingPage
Hi everyone, We’re excited to share an upcoming update to help you get the most out of your landing pages — the auto-upgrade option, launching on October 22, 2025. Your landing pages are designed to bring in leads, and we want to make sure you never missWorkdrive comment links stopped working.
I have marked a PDF file with 95 comments, they have worked for a while. When i clicked on them they brought me to the correct page and showed me the outline that i had drew on the plans. The comments included the page number of the outline, but now itNext Page