Release note - KAWA 1.19
🚀

Release note - KAWA 1.19

🎊 New features

MAIN FEATURES
IMPROVEMENT
Teams
Interrupt ETL
Add fields panel
Grid: Column resize by header nam
Chart: Legend resize options
Formulas: JSON, ENDS WITH and BEGINS WITH

This release brings a lot of bug fixes and UI improvements.

1. Main new features

1. a) Teams

Refer to KAWA WIKI > General Concepts > Collaborating for more information on Teams.

A team is managed by workspace. Each team has:

  • a name
  • at least 1 “Member” (by default the creator of the team)
  • at least 1 “Team Admin” (by default the creator of the team)

How to find the teams in your workspace? To manage your teams, go to Settings > Members > Teams 👇

image

Create a new Team and add members to this Team

đź“Ś
Teams consist of members who are already part of the workspace. Please ensure that all the members you intend to include in the teams have already been added as members of the workspace.

How to create a team:

  • Step 1: To create a Team, go to Members > Teams > Click on the “+ Team” button.
image
  • Step 2: Enter your team details and add members.

To add members to an existing team later on, simply click on your team name or the edit icon to edit the members list. Only users with “Manage Users right” will be able to add members.

Sharing Teams and Security Teams

There are 2 types of teams:

  • Sharing teams: These teams are designed for sharing datasources, sheets, views, or dashboards.
  • Security teams: These teams serve the specific purpose of implementing Row Level Security. Security rules applied to datasources are matched exclusively with these teams to manage data access rights. It's worth noting that Security teams can also function as sharing teams when needed.

Refer to KAWA WIKI > General Concepts > Row-Level Security to know more about rules on Security names.

Who can create Teams ?

To create a Team, users must have the "Manage Users" permission. To create Security teams, both the "Manage Users" and "Row Level Security policy" permissions are required.

image
Users with “Manage Users” rights
Users with “Row level security policy” rights
Users with both rights
Create Sharing Team
âś…
❌
âś…
Create Security Team
❌
❌
âś…

1. b) Add Fields Panel

In grid view, the new Add Fields Panel brings ease and flexibility to adding fields to your view.

image

How to add a Field in a Grid

There are two ways of adding fields from the “Add Fields” panel:

  • "+ Add" On Hover: Hover over where you want to add the field, and you'll see a "+ Add" option. Click on it to add the field at the end of the view.
  • Drag and Drop: Simply drag and drop the field where you want it in your grid. Grey lines will guide you, and you can place the field in your preferred position.

When a field is already available in the view, it is marked as “Added”:

image

Navigating the Add Fields Panel

Data Sources section:

You can add any columns from the primary datasource of your sheet. Additionally, you have the flexibility to perform joins with any other datasource within your workspace that has defined keys.

  • Step 1: Click on the "Join a new data source" button, which opens the panel for creating a new join.
image
  • Step 2: Match the keys of the datasource you intend to join with the columns from the current datasource.

Linked Views:

Within the Linked Views section, you have the flexibility to add fields from views that are already linked. All previously linked views are visible here, and a focus icon allow to open the linked view directly from the panel.

It’s also possible to create new linked views by clicking on the "Link a New View" button located at the bottom of this section.

image

This action will open a panel for creating a new linked view. In this panel, select the view you want to link and match its columns to the fields within the current view.

image

Formulas:

This section includes formula columns, linked columns, and mapping columns.

You'll find that any previously created formula, mapping, or linked column within the sheet is readily accessible in this section and can be seamlessly added to the view.

image

You can also create new formulas and mappings directly from the panel by clicking on the “+ Create Formula” or “+ Create mapping” buttons.

image

2. Improvements

2.a) ETL: Interrupt button

An “Interrupt” button now appears during runs, allowing you to stop the run.

2.b) Grid: Column resize by header name or by content

You can now resize columns either by their header names or by their content, giving you precise control over your grid view presentation.

To do so:

  • Step 1: Right click inside the Grid
  • Step 2: Select Autosize by headers or by content
image

2.c) Chart: Legend resize options

You can now easily customize the size and layout of chart legends to better match the aesthetics and clarity of your data visualizations.

  • Step 1: Click on clog icon in Chart
  • Step 2: Select resizing options of your choice
image

2.d) Formula functions

JSON

In the formula editor, you'll discover four new JSON functions designed to extract boolean, decimal, integer, and string values from JSON data.

image

ENDS WITH and BEGINS WITH

Find the “Ends with” and “Begins with” functions in the formula editor.

image
image