Kuika's Pivot Table element allows you to view data in a dynamic and summarized way. Users can analyze large data sets by grouping them into categories and metrics. This element is used in processes such as reporting, data analysis and performance tracking. In this course, you will learn how to use the Pivot Table element, how to structure your data, and how to customize table layouts.

The Pivot Table element only supports web applications.

This training content consists of the following topics:

Adding a Pivot Table Element
Pivot Table Element Properties
Element Settings and Properties

Add Pivot Table Element

Log in to the Kuika platform.
Open the project you will work on from the Apps screen.

In the UI Design module, select the Pivot Table element under the Data category from the Elements panel on the left side.
Drag and drop the element to the desired area.

Pivot Table Element Properties

You can configure the following settings from the Properties panel:

Datasource: Select the source of the data to be displayed in the Pivot Table.

Create and Manage Pivot Table Templates

You can create, save and upload your Pivot Table templates whenever you need them. For this, follow the steps below:

1. Export Pivot Table Config

Add the Export Table Config action using the ADD ACTION button.
This action exports the data and column configurations from the Pivot Table in JSON format.
You can save the JSON data to a database or storage such as Local Storage.

2. Import Pivot Table Config

Import the configuration using the previously exported JSON file.
Upload the file to the Pivot Table using the Import Table Configs action.

3. Multiple User and Template Management

To store different Pivot Table configurations for multiple users, use user-specific keys in the database or Local Storage.
With this method, you can easily access and import the templates you have defined.

Authorization.

You can customize user access with “Anonymous Access” and “All Roles Access” authorization options on the screens and elements of your application. While “Anonymous Access” enables access without any account information query, “All Roles Access” provides access by verifying user account information.

For element level authorization, you can manage the security and user experience of your application by selecting the relevant element and editing the “Authorization” settings from the Properties panel.

Visibility.

It allows you to adjust the visibility of screens or elements. Visibility in Elements allows you to regulate visibility based on a specific state or condition. For each element, you can make it always visible, hidden, or visible and hidden depending on a condition.

Click on the element on the screen.
Open the “Properties” panel on the right side.
Click on the “Visibility” field and make one of the following selections according to the needs of your application. Kuika offers Always Visible, Hidden, Sometimes Visible options to control the visibility of the screens in your application.

Always Visible: Ensures that the screens in your app are always visible. ‍
Hidden: Allows hiding screens in your application. ‍
Sometimes Visible: Makes screens in your application conditionally visible.

Editability

Allows you to make elements editable.

Enabled: Selecting this option makes the element editable.
Disabled: In this case, the element cannot be edited.
Sometimes Enabled: This option means that the element is sometimes editable and sometimes not, depending on certain conditions.

Customize the İnterface Design with Style Panel

By customizing your elements with the Styling Panel, you can create unique and impressive user interfaces in your web and mobile applications.

The sections defined below vary depending on the element.

Layout‍: Here you can make visual adjustments such as sizing, alignment and padding of elements. These settings also affect the layout of other elements within the element. Properties include Size, Min Size and Align; however, some elements may not support the Display property.
Text: The element's text properties can be edited here through font family, style, color, size, spacing and other options. This section supports all Text related adjustments.
Fill: You can use the Fill setting to customize the element's background with color or images.
Border: You can give your elements a more aesthetic look by adding borders and adjusting the corner radii.
Shadow: You can add a shadow effect to elements used in web applications to give a sense of depth. However, the shadow feature may not be supported as some elements are not suitable for mobile applications.

Actions.

Kuika contains system actions such as Arithmetic, Authorization, Condition, Device, Export, Geolocation, Invers, Local Storage, Multi Language, Navigation, Notification, Payment, UI Control, Process Administration, Process Automation, Trigger, Process Automation, Process Administration and String Operations.

In addition to system actions, you can also use SQL actions that you create yourself.

To add actions to elements, you can use the “+ADD ACTION” button from the Properties panel on the right side.