Grids are the spreadsheet-like tools available in HCL Unica Plan for data collection and display. Plan provided a user interface to display Grids data as a table or a list. HCL Unica Plan supports the below-given Grids.

1. Line Truncate View

2. Line Wrap View

3. Two Line Staggered View

4. Editable Grid View

Out of these, Line Truncate View, Line Wrap View, and Two-Line Staggered View are called Read-only Grids where Editable Grid View can be used to Edit and save the business data/details. An editable grid is for users to enter information, while a read-only grid displays information entered previously. This article will help you configure and display an Editable grid’s contents as a report in a Read-only grid.

You can configure the Read-only grid in the same OR different HCL Unica Plan Form Definition Page as per your business requirement. In the below-given scenario, we will use the single Form Definition Page with Editable and Read-Only grid. Below given steps will help you to walk through the scenario.

1. Create a new form with an editable grid view in HCL Unica Plan. Refer given Fig.1

New Form - Editable Grid in Unica Plan

Fig.1

2. Post form creation, add an editable grid view component in this form, and save the changes. Refer given Fig.2.

Editable grid view component - Unica Plan

Fig.2

You need to note down the value for the “Database Table” column. This is the table from where the Read-only grid will pick up the data for display.

3. Create editable grid type attributes per your business requirement; in this scenario, we used the Integer and Text Multi-Line attribute. See below given Fig. 3 a, b and c

New Custom Attribute - Unica Plan

Fig.3a

Create a new custom attribute - Unica Plan

Fig.3b

Save the new custom attribute - Unica Plan

Fig.3c

4. Add editable grid view component to form canvas. Similarly, drag and drop editable grid attribute(s) to editable grid component. See below given Fig 4.

drag and drop editable grid - Unica Plan

Fig.4

5. Save changes and Publish your form from the “Administrative settings > Template configuration > Form definitions” page.

6. Column need to note down from form is <Form Table Name>.uap_grid_row_id. In this example, its Purchase.uap_grid_row_id. To avoid duplicate rows display in the Read-only grid, you need to explicitly use the “uap_grid_row_id” field.

7. In the same form or in a new form, add a read-only grid component. As said above HCL Unica Plan provides three different read-only grid components, which are
– Line Wrap View
– Two Line Staggered View
– Line Truncate View
For more details, refer HCL Unica Plan Administration guide. In this example, we are using “Line Wrap View.”

8. Add “Line Wrap View” read-only grid to form. Refer Fig. 5

Line Wrap View - Unica Plan

Fig.5

Note: ‘Database table’ columns value needs to populate as noted in point #2 “Database Table” column, and ‘Table key column’ value needs to be “uap_grid_row_id.” Refer to point #6 for more details.

9. Add appropriate column(s) and map to fields from the editable grid. In this example, we have used Integer and Text Multi-Line for the editable grid; hence similar type attributes are used for Read-only grids. Refer Fig 6 (a,b &c)

Appropriate column(s) and map to fields from editable grid.

Fig.6a

Appropriate column(s) and map to fields from editable grid.

Fig.6b

Attribute Database - Unica Plan

Fig.6c

Note: “Attribute Database Column Name” needs to be exactly the same as what is used in the editable grid attribute.

10. Add Read-only grids attribute(s) to Read-only grids frame. See Fig 7.

Read-only grids frame - Unica Plan

Fig.7

11. Once again, save changes in form and publish it.

12. Use the same form in the appropriate template and create an object instance out of it. Refer Fig. 8 and 9

Fig.8

Fig.9

13. Editable grid and Read-only Grid appear as shown in Fig. 10.

Fig.10

14. Once you save data in an editable grid, it reflects in Read-only Grids as shown in Fig. 11-a and b.

Fig.11a

Fig.11b

To learn more about Unica Plan, you can refer to HCL Unica Plan User and Administrators guides, gather more details on Form definitions and create forms with different attributes, etc. You can reach out to us anytime, and we will be happy to help.

Comment wrap
Further Reading
article-img
Marketing & Commerce | July 30, 2021
Releasing the new feature pack – Unica 12.1.1 Summer Release
We're excited to announce the release and general availability of latest Summer update to Unica 12.1 cloud native integrated-Unica 12.1.1.
article-img
Marketing & Commerce | May 5, 2021
Traditional MRM vs Collaborative Work Management
It’s a marketer’s world. Customers can be reached by virtually any medium (email, SMS, social media) a marketer puts their mind to. But with so many channels, meeting customer expectations, understanding their needs, and formulating strategies to provide a great customer experience, the list of marketing "to do's" is much longer than it used to be. Hence Marketing Resource Management has become an essential part of new marketing approaches. What is MRM? Forrester1 defines marketing resource management as enterprise marketing technology that helps marketers with financial planning, performance measurement, collaboration and calendaring, project management, content production, asset management, brand compliance, and marketing fulfillment. MRM is not a new space, but marketers need to take a fresh look at available solutions. As the MarTech landscape has exploded over the past decade, marketing operations has become the backbone that keeps all of the tools and processes working together to achieve the organization's goals - encompassing everything from planning, processes, execution to technology and resource allocation. MRM includes the resources available to internal teams and the relationships with external stakeholders and approval processes. MRM lets you organize, automate and optimize marketing tasks. The Purpose MRM fulfills MRM exists to save time and marketing resources. Think of just one single marketing task – for example, preparing an email marketing campaign. The list of activities includes the coordination between your marketers, graphic designers, copywriters, and others involved – it is time-consuming and, therefore, costly. This was just an email campaign; consider the cost of running hundreds like these together. For every hour spent on this, you lose focus on other marketing collateral or company growth. With MRM in the picture to manage the assets, tools, and operations, it is easier and more cost-efficient. Creative Approvals - Easily float creatives to brand, legal and other teams for...
article-img
Marketing & Commerce | January 28, 2021
Partitioning in HCL Unica Suite
Keeping user information safe is of utmost priority for any brand or organization. In the Unica family of products, partitions provide a way to secure the data that is associated with different groups of users. When you configure Unica Campaign or a related Unica application to operate with multiple partitions, users can see each partition as a separate instance of the application. There is no indication that other partitions exist on the same computer. How multiple partitions work? For the Unica applications that operate with Unica Campaign, you can configure the application within the partitions where you have configured an instance of Unica Campaign. Application users within each partition can access the Unica Campaign functions, data, and customer tables that are configured for Unica Campaign in the same partition. Partition benefits Multiple partitions are useful for setting up strong security between groups of users because each partition has its own set of Unica Campaign system tables. Multiple partitions cannot be used when groups of users must share data.  Each partition has its own set of configuration settings, and Unica Campaign can be customized for each group of users. However, all partitions share the same installation binaries. With the same binaries for all partitions, you can minimize the installation and upgrade efforts for multiple partitions. Partition user assignment Access to partitions is managed through membership in Unica Platform groups. Except for the partition superuser (platform_admin), each HCL user can belong to one partition. A user who requires access to multiple partitions must have a separate user account for each partition. If there is only one partition, users do not have to be explicitly assigned to that partition to access the Unica Campaign. Partition data access In a multi-partition configuration, partitions have the following security characteristics: A user cannot access a partition...
Close