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
Mass (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 itHow to Bulk-Update Sales Orders in CRM
Hi - I need to bulk update existing sales orders with dates from our ERP of when the sales orders were created. I made a date field on the Sales Order module where I want to insert that data. I can't Mass Update because I am not updating the fields toZoho ToDo in Cliq
Our organization utilizes Zoho ToDo in the Zoho Mail Desktop app. Is there a way for these to show up in Cliq Desktop app as well?【Zoho CRM】サンドボックス機能のアップデート：カスタムビューが利用可能になりました。
ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 今回は「Zoho CRM アップデート情報」の中から、サンドボックス機能のアップデートをご紹介します。 目次 1. カスタムビューとは 2. 今回の機能アップデートについて 1. カスタムビューとは カスタムビューは、ユーザーが設定した条件に基づいてデータをフィルタリング・整理し、 重要な情報へ効率的にアクセスできるようにする機能です。 「過去15日間の見込み客」や「受注間近の商談」、「特定の優先度レベルが設定された案件」など 条件を指定してわずか数クリックで設定できます。Changing an agents email address
How do you change an agent's email address? I keep getting a red circle even though I am an admin. And on one of my agents he has two email addresses? How is that possible?Zoho CRM - Potentials Tab
Hi! When I create a Deal (Potentials tab) the header looks like this: After a refresh on the page it looks like this: What should I do so that it is displayed like in the second pic without refresh? Also I have a user that as of recently, cannot see thisIs there a way to automatically add Secondary Contacts (CCs) when creating a new ticket for specific customers?
Some of our customers want multiple contacts to receive all notifications from our support team. Is there a way to automatically add secondary contacts to a ticket when our support team opens a new ticket and associates it with an account? This wouldUnable to create embed code for resource of workdrive using API
Hello Team, I am trying to create embed code for a resource using workdrive api in powershell, however facing some issues with injecting data in body. Followed Doc: https://workdrive.zoho.com/apidocs/v1/filefoldersharing/shareeveryone Please help, belowFeature Request - Insert URL Links in Folders
I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to createnot able to convert pdf to jpg and other forms and vice versa.
i want to change my pdf to jpg, word, etc and some times jpg to pdf. i don't know how to do in this.Enable / show scroll bar when Mega Menu is opened
Hey there I am using the mega menu add-on and experience a "flicker" whenever the mega menu opens. The reason is, that the scrollbar, which has a width of a few pixels, stops showing when the mega menu opens. As the scrollbar disappears the whole pageShared Mailboxes Disappeared
Zoho Mail users in our company haven't been able to see their Shared Mailboxes for the past few hours. I've checked with App and Web Access, but they can't access them. When I send emails to their addresses, I get no error messages. They're still visibleReports: Custom Search Function Fields
Hi Zoho, Hope you'll add this into your roadmap. Issue: For the past 2yrs our global team been complaining and was brought to our attention recently that it's a time consuming process looking/scrolling down. Use-case: This form is a service report withZoho Inventory - Composite Items - Assembly - Single Line Item Quantity of One
Hi Zoho Inventory Team, Please consider relaxing the system rules which prevent an assembly items from consisting of a single line item and outputting a quantity of 1. A client I'm currently working with sells cosmetics and offers testers of their productsHow can I transfer data from Production to Development environment?
Hi, I am using Creator V6 and would like to bring all the data in production to the Development and Testing environments? Is there an easy way of doing that or I have to export and import each table?Add "Reset MFA" Option for Zoho Creator Client Portal Users
Hello Zoho Creator Team, We hope you are doing well. We would like to request an important enhancement related to Multi-Factor Authentication (MFA) for client portal users in Zoho Creator. Currently, Creator allows us to enforce MFA for portal users,New portal SAML authentication error: User not found
Dears, Has anyone else been experiencing this lately? I am creating a new portal authenticated by SAML (Entra ID). I followed the same process as I did with other portals, but any new portal created after this always encounters this error. I’ve been reportingDevis et facture multi page
Bonjour, je suis sur Zoho invoice et je rencontre un problème sur mes devis et factures lorsqu'ils dépassent 1 page. je me retrouve souvent avec des lignes coupées ou le sous total page 1 et le total page 2. j'aimerai savoir s'il existe une possibilitéRotate an Image in Workdrive Image Editor
I don't know if I'm just missing something, but my team needs a way to rotate images in Workdrive and save them at that new orientation. For example one of our ground crew members will take photos of job sites vertically (9:16) on his phone and uploadHelp with Filtering Records, HTML Pages, and Automatic File Uploads in Zoho Creator
Hi Zoho Creator Community, I’m building a Zoho Creator application and need guidance on a few features I’ve been struggling with. I want to implement them safely and efficiently, and I’d appreciate any examples, tips, or best practices. I want users toHow to Send Email from within a custom module (with or without an email template)
It is possible to send an email from the Deals module. However, I can't find a way to send an email from any of our custom modules. I have tried adding an email field to the modules (even though we don't really want one or need it there). That doesn'tConvert invoice from zoho to xml with all details
How to convert an Invoice to XML format with all detailsFeature Suggestion for Zoho Websites – Inspired by Squarespace Systems
Dear Zoho Team, I’m a Zoho user and also a Squarespace Platinum Circle member, and I recently noticed the launch of Zoho Websites in India. I wanted to share some ideas for features that could enhance the platform for professional users and agencies.Custom View - Sort by Custom Field
I created a custom field for our Engineering team to know which tickets to work first by numbering them. I created a custom view to general data which includes the Engineering Priority. However, I cannot sort the Engineering Priority column ascendingZoho Indeed Intergation not pulling candidate details
We have recently integrated zoho with indeed. Prior to this our candidates came into the candidates tab via the zoho.resumes email address from indeed and it pulled through the candidates mobile number, and majority of the time a postcode. However sinceCustom View of tickets created today
How can I create a custom view that list all my ticked created in the current date? Currently, if I select the "Created Time" criteria, the "Current Time" option does not work as today. Actually, I don't know how it works this "Current Time".Lifecycle Reports
From data to decisions: A deep dive into ticketing system reports A lifecycle report captures and visualises the sequential states that a ticket undergoes across its lifespan. For instance, when a customer submits a support ticket for a faulty product,Zoho Forms - Print Button on Forms
Hi Forms team, I'm replicating a form for a client which is currently based on JotForm. I noticed that at the end of the form there is a button to print the completed form. I thought this would be something worth sharing and a nice to have in Zoho Forms.Putting Watermark on Zoho Sheet
Can this be done?Validation function not preventing candidates under 18 or over 30 from submitting the web form
Hello everyone, I’m trying to create a validation rule for the Candidate Webform in Zoho Recruit. I added a custom field called “Date of Birth”, and I want to make sure that candidates cannot submit the form unless their age is between 18 and 30 years.Next Page