Upcoming updates - July 2019

Upcoming updates - July 2019

Hello App Creators,

We’re here with another set of updates.

During Jul-2019, the Zoho Creator team will be rolling out the following feature updates:
  • subform.insert() and subform.clear()
  • Zia-powered smart data import during form creation
  • Ability to control rendering of HTML content in Formula field
  • Lookup data from Radio and Drop down fields
  • Setting background images for panels
Here are the links to the recent posts in this series: Apr-2019 updatesMay-June updates. Refer to our changelog for the complete list.

- - - - - - - - - - -

subform.insert()  and  subform.clear()

Yes! It’s here!

We’ll be introducing two Deluge tasks — subform.insert() and subform.clear() — that’ll enable you to dynamically add and manage data in your subforms. You'll be able to address the following scenarios:
  • Insert data into subform as part of the add record Deluge task
  • Dynamically insert rows in the subform when your user's adding or editing data
  • Delete data from subforms
To achieve these, we've introduced the Collection data type, which can hold a list of values or a map. Let's take a look at these scenarios with syntax.

Inserting data into subform when you're adding a record in the main form

The add record Deluge task will now support adding rows in subforms. Syntax:
  1. row1 = <mainForm_linkName>.<subForm_linkName>();
  2. row1.<textField_linkName> = "value1";
  3. row1.<multiSelectField_linkName> = {"value2", "value3"};
  4. row2 = <mainForm_linkName>.<subForm_linkName>();
  5. row2.<textField_linkName> = "value4";
  6. row2.<multiSelectField_linkName> = {"value5", "value6"};
  7. rows = collection();
  8. rows.insert(row1, row2);
  9. rec_id = insert into <mainForm_linkName>
  10. [
  11.     <mainForm_textField_linkName> = "value";
  12.     <subForm_linkName> = rows;
  13. ];

Dynamically insert rows in subform when your user's adding or editing data
  1. row1 = <mainForm_linkName>.<subForm_linkName>();
  2. row1.<textField_linkName> = "value1";
  3. row1.<multiSelectField_linkName> = {"value2", "value3"};
  4. row2 = <mainForm_linkName>.<subForm_linkName>();
  5. row2.<textField_linkName> = "value4";
  6. row2.<multiSelectField_linkName> = {"value5", "value6"};
  7. rows = collection();
  8. rows.insert(row1, row2);
  9. input.<subForm_linkName>.insert(rows);

Delete data from subforms

This is where the clear() task will come in handy. Syntax:
  1. input.<subForm_linkName>.clear();
It'll behave differently based on the type of subform:
  • When you operate the clear() task on a blank/inline subform, it'll delete all the rows in that subform
  • When you operate the clear() task on a subform that itself is a form, it'll just delete the relationship between the main form's record and related subform records. Records in the subform will remain intact.
- - - - - - - - - - -

Zia-powered smart data import during form creation

Applicable to: Zoho Creator 5

Remember the Zia-powered smart data import capabilities that were recently introduced w.r.t. app creation? They’ll now available during form creation as well.

Additionally, the following abilities will be introduced:
  • Edit a cell’s value by double-clicking it
  • Edit identical cells in a column by right-clicking 
  • Enable the No duplicate values property for a column 
  • Enable the Mandatory property for a column
  • Establish relationship with data in existing forms via lookup field
- - - - - - - - -

Ability to control rendering of HTML content in Formula field

We're introducing the Show value in reports as field property for the Formula field. It can be set with the value Plain text or Rich text.

Having the formula field display data as plain text may benefit the performance of displaying its data in reports. How? — Late last year we upgraded our security framework w.r.t. processing HTML and CSS content. This ensures that only valid/allowed tags and attributes are rendered in your apps. Therefore, choosing to display the formula field's data as plain text will let the system skip consulting this white list. Even if HTML tags are present, they'll be treated and displayed as characters.

Note:
  • Existing formula fields will be set to show their data as Rich text.
  • Formula fields that you add after this update will be set to show Plain text. You’ll have to set it to Rich text to have that formula field render HTML tags in reports.
- - - - - - - - -

Lookup data from Radio and Drop down fields

In other words, you’ll be able to include radio and drop down fields as the lookup's Display fields.

- - - - - - - - -

Setting background images for panels

Applicable to: Zoho Creator 5

You’ll be able to upload an image and set it as the background for a panel or a cell in a panel. The panel or cell’s content will appear over (or “in front of”) the image.

- - - - - - - - -

Let us know what you think about these updates.

Best,
Lakshman | Zoho Creator Team

    Zoho Marketing Automation
            • Sticky Posts

            • 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
            • Join our developer community!

              Dear developers, To improve communication and transparency with you, we started a developer-focused newsletter in early 2021. To expand the scope of  our outreach, we are looking to create a go-to database of our developer community across professional
            • It's time to evolve: Upgrading to Zoho Creator 5

              Dear App Creators, With our commitment to continually refining and improving our user experience, we're gearing up to upgrade all accounts to Creator 5 on (UPDATED) from December 1st, 2020 , in phases . In other words, from this date forward, all your
            • Upcoming updates - October-November, 2020

              Hello App Creators, We'll be rolling out the following updates in the next 4-5 weeks: Support for encrypting IP addresses Applying permissions while printing and exporting Using pixels to specify font size in pages Connections for panels and Deluge integration
            • Zoho Creator positioned as a Visionary in 2020 Gartner Magic Quadrant for Enterprise Low-Code Application Platforms

              Hi folks, We come bearing good news! We are delighted to share that Gartner has named Zoho Creator a "Visionary" in this year's Gartner Magic Quadrant for Enterprise Low-code Application Platforms (LCAP). ​ Gartner Magic Quadrant for Low-code Application

            Zoho Pagesense Resources

              Zoho SalesIQ Resources



                    Zoho TeamInbox Resources

                      Zoho DataPrep Resources



                        Zoho CRM Plus Resources

                          Zoho Books Resources


                            Zoho Subscriptions Resources

                              Zoho Desk Resources

                                Zoho Projects Resources


                                  Zoho Sprints Resources


                                    Qntrl Resources


                                      Zoho Creator Resources


                                        Zoho WorkDrive Resources




                                            Zoho Campaigns Resources

                                              Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now