Upcoming updates - April 2019

Upcoming updates - April 2019

Hello App Creators,

During April, 2019, the Zoho Creator team will be rolling out the following feature updates:
  • Updates w.r.t. Address and Location
  • Panel builder and Gauges in Pages
  • Kanban Report customizations
  • Ability to search and sort records using the subfields of Name and Address fields
  • Currency field formatting
In addition to our changelog , we'll leave a comment below as these items are rolled out.

- - - - - - -

Updates w.r.t. Address and Location

Applicable to : Zoho Creator 5
Note : This item alone will be rolled out during the first week of May, 2019.

We're revamping certain aspects of the platform's location related capabilities to better cater to the requirements of apps for location-based services. Here are the changes we'll be introducing:
  • Re-adjusting the Address field
  • Deprecating Address Line 1 and Address Line 2 subfields from the Added Location and Modified Location system fields
  • Introducing display options for location data in reports

Re-adjusting the Address field

Currently, the address field's usage suffers from the following:
  • Geo coordinates are not captured for addresses that users type in the field.
  • Geo coordinates that are returned by our map service, lack the required accuracy.
To tackle these, we’re adding the following properties to the address field:
  • Capture geo coordinates - This will use the physical address typed by your user and immediately fetch its geo coordinates using the map service. This property will be auto-enabled for all address fields. Geo coordinates of existing addresses, if not already captured, will be captured when users edit those records.
  • Adjust location on map - This will display the address's geo coordinates and allow users to adjust its location in a map. Adjusting the location will not affect the physical address data that the user entered — it will only update the data in the latitude and longitude subfields.
Consequent to these properties, the existing  Search and autocomplete  and  Use map to select address  field properties will be deprecated. 

Here's how the combination of Capture geo coordinates and Adjust location on map will look on a web browser:




Deprecating Address Line 1 and Address Line 2 subfields from the Added Location and Modified Location system fields

Tackling the lack of required accuracy w.r.t. reverse geocoding address data, we're deprecating the Address Line 1 and Address Line 2 subfields from the Added Location and Modified Location system fields .

This change will not affect the existing data and workflows that refer to said subfields. However, Address Line 1 and Address Line 2 data (in the location fields) will not be captured after this update.

Introducing display options for location data in reports

In the report layout, the Display Option property will be introduced for the address, added location, and modified location fields. This'll enable you to define if the data in these fields is to be displayed as a Physical address or as Geo coordinates

When you choose to display geo coordinates, you'll get to select the format using which the coordinates are to be displayed: either the Decimal Notation or the Degree-Minute-Second DMS Notation .



- - - - - - -

Panel builder and Gauges in Pages

Applicable to : Zoho Creator 5

Dashboards enable businesses to monitor their Key Performance Indicators (KPIs) and the progress towards their goals. Enabling you to quickly build powerful dashboards in your custom apps has been, and is, one of our goals with Pages. And so, we're extending your page-building arsenal with the Panel builder and Gauge .

Panel builder

It's a point-and-click interface for customizing panels. This'll enable you to add and customize multiple elements within the panels. Here's a video showing its offerings:


Gauge

Gauges visually indicate the progress towards goals/KPIs. A gauge in a page will display an aggregate value that's derived from the data in a form. For example, the following gauge displays the sales made in the current month and indicates the progress towards the month's sales target:



- - - - - - -

Kanban Report customizations

Applicable to : Zoho Creator 5

We're introducing the following improvements w.r.t. customizing kanban reports. These will be available in the kanban report's builder:
  • Ability to hide the EMPTY column, or show it with a custom label
  • Ability to hide or show the Deleted Value Column : Imagine a kanban report based on a dropdown field, and that you delete one of its choices that's selected in records. Once a choice is deleted, the corresponding column in the kanban report is also deleted. To ensure that such records remain visible in the report, we're introducing the Deleted Value Column. This column will also show the records that contain "other" values that users enter in the dropdown field.
  • Ability to filter the columns that the kanban report is to display. This can be done as follows:
    • When the kanban report is based on a lookup field, you'll be able to use the lookup's filter criteria
    • You'll be able to specify a custom criteria using the criteria builder
    • You'll be able to manually select the values that are to be shown as columns
- - - - - - -

Ability to search and sort records using the subfields of Name and Address fields

Applicable to : Zoho Creator 5

Your users will be able to search data in reports using the subfields of name and address fields. While accessing reports, in the Search pane on the right, you’ll see Search using Subfields option against the name and address fields. Clicking this expand the name field allow you to search against all the enabled subfields.

You'll be able to configure a sorting order for your reports using the subfields of name and address fields. You'll be able to select one subfield, and the selected sorting order will be applied from that subfield to all the ensuing subfields:
  • The address field is made of address line 1, address line 2, city/district, state/province, postal code, and country subfields. This order will be considered while applying sorting. For example, when you sort using the  City/District subfield, the records will first be sorted using city/district data, then the state/province, then the postal code, and then the country data.
  • The name field is made of prefix, first name, last name, and suffix subfields. This order, and the name field's Display Option property in that report, are considered while applying sorting. For example:
    • When you select the First Name subfield to sort with, records will first be sorted using the first name data, then the last name, and then the suffix data.
    • When the name field's Display Option property in that report's layout is set as Last Name first and you select the Last Name subfield to sort with, records will first be sorted using the last name data, then the first name data, and then the suffix data.
- - - - - - -

Currency field formatting

Currently, the data in the currency field is displayed in a locale-specific format in reports. To uniformly display the currency field's data across the form and its reports, we're introducing the Currency format field property. It'll be a dropdown with the following choices:
  • Default
  • 1,234,567.89 
  • 12,34,567.89 
  • 1 234 567,89 
  • 1.234.567,89
  • 1'234'567.89
While accessing forms, the selected format will be applied to the data in the currency field after the users step off the field. For all the existing currency fields, the Currency format property will be set as Default , thereby keeping existing data as is.

- - - - - - -

Looking forward to your feedback on these updates.

Best,
Lakshman | Zoho Creator Team

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts



                                                          • 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 capabilities
                                                          • 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


                                                          Manage your brands on social media



                                                                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

                                                                                    • 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

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ






                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Dynamic Signature - Record owner

                                                                                                            Hi everyone, I’m using Zoho Writer merge templates from Zoho CRM and have two questions: Owner signature: How can I automatically insert the CRM record owner’s signature in the merged document? I’m not sure where this signature is stored or how to reference
                                                                                                          • Writer sing up problom

                                                                                                            Zoho writer sing up prolom face
                                                                                                          • Unable to copy into a new document

                                                                                                            Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you
                                                                                                          • [Webinar] Live demos and user Q&A with Zoho Writer product experts

                                                                                                            Join us on June 12, 2025 for live demos based on your use cases and real-world scenarios raised via form. This is also an opportunity to get your questions answered directly by product experts from the Zoho Writer team. Webinar agenda Live demos based
                                                                                                          • Zoho Writer's built-in citation and bibliography generator

                                                                                                            Hey researchers and writers! Do you manually format citations and bibliographies, spending hours jumping between apps and tabs? If so, then check out Zoho Writer's built-in "Citations and Bibliography" feature. Imagine you're writing a thesis on the future
                                                                                                          • Single and group checkboxes in Zoho Writer's fillable forms

                                                                                                            Hey Writer Fam, Are you making the most out of single and group checkboxes in fillable forms in Zoho Writer? Here is a handy tip to optimize your use of checkboxes, both single and group, and enhance your data collection process. Single checkboxes: Single
                                                                                                          • Collaborate efficiently with Zoho Writer's track changes feature

                                                                                                            Hi Zoho Writer Community, Zoho Writer's track changes feature is a simple, built-in solution that helps you and your team work together efficiently. Instead of juggling multiple versions of a document or building up a long email chain of comments, each
                                                                                                          • Zoho Writer's WordPress extensions

                                                                                                            Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window
                                                                                                          • Time-saving table hacks

                                                                                                            Hey Zoho Writer Community, Do you find yourself using a lot of tables in your documents? We're here to share some of our time-saving hacks that will help you work more efficiently, organize your data, and make your documents look neat and professional.
                                                                                                          • Automating document approval and signing with Zoho Writer and Zoho Sign

                                                                                                            Hey Zoho Writer Community! Here's another automation tip to make your processes more efficient! Question: Can I send a document for client approval first, then automatically send it for signing with Zoho Sign if they approve? Since it's the same person
                                                                                                          • Customization hacks in Zoho Writer - Part 2

                                                                                                            Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating
                                                                                                          • Simplify your tax calculations with Zoho Writer

                                                                                                            Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income
                                                                                                          • Enhance document navigation with headings and TOC

                                                                                                            Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents
                                                                                                          • Use and download in PDF format of Zoho wirter Merge template using deluge

                                                                                                            Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface
                                                                                                          • Customization hacks in Zoho Writer - Part 3

                                                                                                            Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge
                                                                                                          • Daytime saving timezones messing up writer pdf

                                                                                                            Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months
                                                                                                          • Issue with locked content in Writer

                                                                                                            Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't
                                                                                                          • Deprecation of certain URL patterns for published Zoho Writer documents

                                                                                                            Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their
                                                                                                          • Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

                                                                                                            Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"
                                                                                                          • Problem with Writer and Workdrive

                                                                                                            Hi team, I’m the super admin for our Zoho One org. WorkDrive is active, and Zoho Docs is deprecated for our org. However, Zoho Writer cannot connect to WorkDrive at all — we’ve cleared cache, tried incognito, and restarted several times. I was able to
                                                                                                          • Set to Review for all

                                                                                                            We are testing the use of Writer as part of an internal review process for statement of work documents and have found that when the document is changed from Compose to Review by one person, that is not reflected for all others who view the document. Is
                                                                                                          • I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.

                                                                                                            These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho
                                                                                                          • stock

                                                                                                            bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem
                                                                                                          • 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 ZOHO
                                                                                                          • Zoho sheet for desktop

                                                                                                            Hi is zoho sheets available for desktop version for windows
                                                                                                          • Tip #18: 6 Trendlines and when to use them in your spreadsheet data?

                                                                                                            Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
                                                                                                          • Perform customized calculations with the new LAMBDA functions!

                                                                                                            We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs
                                                                                                          • No chat option

                                                                                                            Chat option is not supported.
                                                                                                          • Tip #17: Easily share spreadsheets with non-Zoho account users

                                                                                                            With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate more effectively by sharing your spreadsheets with anyone outside your organization, including users who do not
                                                                                                          • Work seamlessly with Sheet's shortcuts without affecting the browser

                                                                                                            Navigating your worksheets and performing specific actions should be a quick and easy process. That's where keyboard shortcuts come in. Shortcut keys help you accomplish tasks more efficiently, eliminating the need to move away from the keyboard. What
                                                                                                          • Zoho Sheet for iPad: Improved UI, external keyboard support, and more!

                                                                                                            The portability and capabilities of the iPad have made it an essential device in the business world. With this in mind, we had launched an exclusive Zoho Sheet app for iPad, with device-specific improvements and enhanced usability. Now, we're improving
                                                                                                          • The new Zoho Sheet for Android: Seamless UI and advanced features

                                                                                                            At Zoho Sheet, we know mobile apps have become the go-to platforms for creating, sharing, and storing information. And we understand the importance of an efficient and seamless app experience. We've been working hard on improving the overall user experience
                                                                                                          • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

                                                                                                            Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,
                                                                                                          • VBA attached to button no longer works on external shared sheet

                                                                                                            Hi - we have a Sheet that our clients use, which requires them to press a button once they've entered data. The button then triggers a flow via a webhook. The button works fine when editing within Zoho Sheet - however when shared externally it no longer
                                                                                                          • can I use zoho sheet for survey?

                                                                                                            Hi I wanna use zoho sheet for my ARY to know consumer better so i wanna have permission to do so
                                                                                                          • How to Avoid Impacting Other Users When Hiding Columns in Zoho Sheet

                                                                                                            Hi Team, We’re experiencing a challenge with the column-hiding feature on Zoho Sheet during collaborative sessions. When one user hides a column, it becomes hidden for all users working on the file, which disrupts others' workflows. In comparison, Excel
                                                                                                          • What are the benefits of procurement software in a growing business setup?

                                                                                                            I’ve been exploring tools that can help automate purchasing and vendor-related tasks. I keep hearing about the benefits of procurement software, especially for businesses that are scaling. I want to understand how it helps in streamlining operations,
                                                                                                          • Object required error

                                                                                                            Hi, I am getting an 'Object required' error on the line Call HideColumnsOutsideRange(ws, startOfWeek, endOfWeek) when I run the ShowCurrentWeek macro but not when I run the ShowCurrentMonth macro. Any ideas? Regards, GW Option Explicit Sub HideColumnsOutsideRange(ws
                                                                                                          • What formula to use in computing total hrs and decimal hrss

                                                                                                            So , my data includes log im column , 2 breaks with 2 columns that says back and lunch and 1 column that says back and logged out. What formula should i use to be able to automatically have my total hours as I input time in each column? Thankyou
                                                                                                          • Replacing email ID,

                                                                                                            In zoho sheets If I am sending it as an email attachments can I replace sender email ID from notifications to my email ID.
                                                                                                          • Next Page