Upcoming updates - Mar 2019 - part 1

Upcoming updates - Mar 2019 - part 1

Hello App Creators, 

Continuing with our recent post on Feb-2019's updates, we're here with a few more updates for you.

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

In addition to our changelog, we'll leave a comment below as each of these updates are rolled out.

- - - - - -

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:
  1. 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".
  2. Select the column in the "parent sheet" that identifies each row uniquely.
  3. 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

Applicable to : Zoho Creator 5 and  accounts using  New UI

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

Applicable to : Zoho Creator 5 and accounts using  New UI

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



      Zoho Campaigns Resources

            Zoho Developer Community

                Bootcamp
                Community
                Pricing
                Webinars
                What's New
                Integrations
                Contact Support
                Contact Sales

                  Zoho Survey Resources
                    Features
                    Survey Templates
                    Integrations
                    Community
                    iOS Mobile Surveys
                    Pricing
                    Android Mobile Surveys
                    Insurvey Blogs
                    Insight Blogs
                    Tips & Tricks






                                  Latest Feature Updates


                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day




                                          Zoho Marketing Automation
                                            Zoho SalesIQ Resources

                                                  • Sticky Posts

                                                  • 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

                                                  • Introducing Zoho Creator's v2 APIs

                                                    Hello App Creators, Welcome to Zoho Creator's v2 APIs! This post will serve as the central point for migrating implementations of Creator's current APIs (v1) to v2. Improvements that v2 brings OAuth-based authentication, which is more secure than the


                                                  Manage your brands on social media
                                                  Access Zoho Social

                                                    Zoho Pagesense Resources


                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep 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 Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • ChatGPT only summarize in English

                                                                                                    Hello i' v enabled chatgpt in salesIQ, it works great inside conversation (revise, Rephrase etc) add tags works well with another language than English. But when I want to summarize it render only in English, despite sales IQ is set to another language.

                                                                                                  • BIN Locations

                                                                                                    Hi, I’m new to Zoho inventory and unless Im missing something, I cannot find BIN locations anywhere in ‘items’? please tell me it’s there somewhere?!? Thanks

                                                                                                  • Send Whatsapp with API including custom placeholders

                                                                                                    Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

                                                                                                  • BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

                                                                                                    As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?

                                                                                                  • Create a custom button to modify custom fields in zoho Inventory

                                                                                                    I am needing a script for two buttons, 1. Button will add todays date to a custom field named cf_sent_to_sov 2. Button will mark a checkbox or unmark a checkbox field named cf_parts_ordered I have been trying to figure out deluge but have not got anywhere

                                                                                                  • Canadian payroll

                                                                                                    Hello ZOHO, is any updates on when payroll for Canada will be available?

                                                                                                  • Default reminders on Emails

                                                                                                    I have seen that it is possible to set, for each email, a reminder when the email remains unresponded for some time. This is very useful, so useful that I would like to set it for all my emails, by default. Because an unanswered email usually requires

                                                                                                  • in zoho assist I would like to temporarliy go into view only mode

                                                                                                    During a zoho assist remote support / remote control session, I would like an option to turn off control, and go into view only mode. Then later, turn back on control, all within the same session. (Many other remote login apps have this feature.) For

                                                                                                  • QR code image is not exported in PDFs

                                                                                                    The new QR code field works fine when I include it in a report template and I choose the print option: https://creatorapp.zoho.com/<username>/<app_link_name>/record-print/<report_link_name>/<record_ID>/ But when I try to save the document to a .pdf file

                                                                                                  • Zoho notes list issue

                                                                                                    Hi team, Suddenly my extension is not working and I could not find the extension in my marketplace list anymore. Extension version deprecated This version of the extension is no longer in use. Please update the extension and try again.

                                                                                                  • Assignment Rule: Immediate Ticket Assignment to Agents Upon Shift Start

                                                                                                    Dear Zoho Desk Team, I hope this message finds you well. Currently, when the option to assign tickets to offline agents is turned off, agents who come online during their shift have to wait for about 30 minutes before any tickets from the queue are assigned

                                                                                                  • Change email template depending on answer from form

                                                                                                    Is it possible to set up the following in Zoho Desk: When a user submits a ticket via the Zoho Help Center's form, they can select an answer from a dropdown field. In this example, the dropdown options are 'Option A' and 'Option B.' If a user selects

                                                                                                  • Kaizen #171: FAQs on COQL API

                                                                                                    Hello all!! Welcome back to another post in the Kaizen series! In this post, we will address some of the most frequently asked questions about Zoho CRM's COQL API from the Zoho CRM Developer Community Forum. COQL API Query API lets you query for records

                                                                                                  • Issue with Date Placeholder Formatting in Ticket ID Customization

                                                                                                    Hello Support Team, I'm experiencing an issue with the date placeholder formatting in Zoho Desk's Ticket ID customization. Specifically, when using the `{{DD}}` placeholder for the day in the prefix or suffix, the output displays the day as a single digit

                                                                                                  • Time Field

                                                                                                    Good Day, I have a question, when I save a draft and reload it. Why does the time field format keeps goes from hh:mm to hh:mm:ss? Is there a way I can force it to load to hh:mm only? I have tried example = totime(input.TimeField, "hh:mm") in the -created

                                                                                                  • Feature Req - See imap emails in Timeline tab of a deal

                                                                                                    In many other CRMs such as pipedrive and hubspot, when you are looking at the timeline of a deal you can also see snippets of emails that have been sent or received and then click to view the full message. This gives users a fast way to catch up on EVERYTHING

                                                                                                  • HOW TO: Searching a thread (email body/text) with a custom function, allowing filtering and specific actions

                                                                                                    We are still trialing out Zoho at this time, but have found a major expected feature to be missing - the ability to search within the text of an email for automation/workflows. NOTE: You need to create a connection for zohodesk under settings -> Developer

                                                                                                  • Partnership Proposal for Supporting Number Porting Services in Singapore

                                                                                                    Dear Zoho Representative’s, I hope this message finds you well. My name is Honelito Gilos, and I represent Borderless Hub Pte Ltd (Singapore). We are a Telco here in Singapore specialising in providing seamless number porting services, and I’m reaching

                                                                                                  • Tip #2: Prefill forms automatically with existing Zoho CRM data

                                                                                                    How to automatically prefill a form with existing Zoho CRM data? Prefilled forms can be useful when you want your prospects to view and confirm their data, and in a wide range of other situations. In Zoho Forms, we prefill the fields with the values from Zoho CRM using the Zoho CRM field. What is a Zoho CRM field? A Zoho CRM field acts as a two-way communication channel, by sending data to Zoho CRM from forms and fetching information from CRM into Forms. The field will look up data from your CRM

                                                                                                  • Transform Your Customer Support with AI-Powered Chatbots in Zoho SalesIQ

                                                                                                    Ever wondered how some companies seem to have superhuman customer support? Let's uncover their secret! In the digital age, customer expectations are skyrocketing. Did you know that according to McKinsey, 75% of consumers expect a response within five

                                                                                                  • Quickbooks conversion and Internet sales

                                                                                                    Hello, we are considering converting from Quickbooks enterprise to Zoho Books and using MonotorZ for our mrp needs. Today we import Internet sales under a single customer with multiple ship to addresses. We want to maintain the detail in CRM for marketing

                                                                                                  • KPI widget with percentage

                                                                                                    I'm trying to create a KPM widget that displays current performance as a percentage - something like the picture below. I've tried following the instructions at https://www.zoho.com/analytics/help/dashboard/kpi-widgets.html#chart but nothing ends up being

                                                                                                  • How to add two columns in Zoho forms

                                                                                                    I would like to have two columns in Zoho forms. How can i enable two columns?

                                                                                                  • Creation of Path and subpath

                                                                                                    In order to improve the structure of the website for better organization, I would like to consider that when publishing a page, it can be within a section and sub-section. For example, if I have an events option in the menu, I can put past events and

                                                                                                  • When creating Sales Order / Estimate via API, the line item Tax Code does not get pulled in.

                                                                                                    I'm creating Sales Orders via API from CRM but it does not pull in the "Tax Code" I've read within the forums that this should be done automatically but it's not happening. Not sure if it's a bug or by design? Anybody else know? Should we be adding the

                                                                                                  • Chart showing schedule

                                                                                                    I want to be able to create a chart for everyday to check and which of which driver is available on the timeframe. Here's my table Name City Day Start Time End Time Driver1 Medicine Hat Monday 11:45 AM 4:45 PM Driver 2 Medicine Hat Tuesday 11:00 AM 7:00

                                                                                                  • Quais são os maiores desafios que você enfrenta ao implementar o Zoho CRM?

                                                                                                    Olá, pessoal da comunidade Zoho Brasil! Sou parceiro autorizado da Zoho e, ao longo do tempo, tenho notado que cada implementação de CRM traz desafios únicos, dependendo do segmento de negócio, das metas da empresa e até da familiaridade da equipe com

                                                                                                  • 2025 Just Got More Exciting for Developers!

                                                                                                    Hello, Greetings to the Zoho Books Community! As we step into the New Year, we're thrilled to roll out something truly special for our Zoho Finance enthusiasts – the "Zoho Finance Developer" Community! This is your exclusive space to connect with fellow

                                                                                                  • Error in executing On user input script

                                                                                                    I'm having problems with this  this script : ; Tipo_list=List(); Tipo_rec = Tabla_factores[Periodo == input.Periodo_anos.toLong()]; Tipo_list.addAll(Tipo_rec.Clase_credito.getall()); for each Clase_credito in Tipo_list { Tipo_credito:ui.add(Clase_credito) } Error in executing On User Input script of Periodo en años. Error. Error in executing Fetch Record task. Unable to fetch Tabla_factores and update variable Tipo_rec. Error in evaluating the criteria : Error. Error evaluating NUMERIC expression

                                                                                                  • sync data from outside of zoho plateform

                                                                                                    hii team , i am creating a platform using zoho platform, i want to sync the data from out side of the platform like people-soft, but i am not able to sync the data , if it is possible , then suggest me how can i do it , i want to sync data from other

                                                                                                  • How to add a Data Updated As Of: dynamically in text?

                                                                                                    I need to add a "Data Updated As Of" in the dashboard to show when was the last date the data was updated. I tried to create a widget but it does not look really good, see below. Is there a way I can do this through the text widget and update it automatically

                                                                                                  • Automate search in customer list and easilly initiate email

                                                                                                    Hello and happy new year ! I have a customer list with name, telephone, emails and some criterias like location, type of customer, etc. I want to search that form to extract part of it, for example all customers that have a location of "Québec city" and

                                                                                                  • "Select All" item in the context menu

                                                                                                    In the Client on Android, there is a “Select all” item in the note’s context menu. There is no such item in the PC client. Can it be added in future versions of the client?

                                                                                                  • Syncing Leave Calendar With Shared Google Calendar Does Not Remove Canceled Leaves

                                                                                                    Our organization has each employee sync their Leaves calendar with a shared Google calendar, but am I right that if an employee cancels a Leave in Zoho that it will not be removed automatically from the shared Google calendar through the same sync m

                                                                                                  • Is it possible to display formulas in cells instead of calculated results?

                                                                                                    I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this in

                                                                                                  • Creator Simplified #11: Create a custom button to download files

                                                                                                    Hey there! This time, let's see how to create custom buttons to download the files uploaded in the file upload field. Sample use-case A training app has a module that provides the materials for all the available courses. Students can click on the corresponding

                                                                                                  • Zoho vault uses only password to unlock not a TouchID

                                                                                                    TouchID works when normally openning app but when called from keyboard while browsing or trying to log to another app it shows only password option to unlock. This behaviour is only on iPad Mini witch latest 18.2OS

                                                                                                  • Batch Tracking Enhancements In Zoho Inventory

                                                                                                    Hello users, We’re excited to announce that we’ve taken batch tracking to a whole new level in Zoho Inventory! We’ve made it more accessible and easier to use than ever. Here’s a quick look at the improvements: 1) A New Way To Create or Modify Batches

                                                                                                  • Zoho Desk Mobile App Year-End Roundup - 2024

                                                                                                    Hello Everyone, Greetings! As you gear up for the festive season, we are excited to share a quick journey into all that is released in 2024! Availability of each feature in iOS and Android released in 2024 are as follows: For more information on the above

                                                                                                  • Task Completion vs Estimated Time

                                                                                                    I need to represent the Estimated Date vs Actual Completion Date for multiple Tasks. How Can I Do this in Zoho Analytics.

                                                                                                  • Next Page