- 🎊 New features
- 1. Main new features
- 1. a) Teams
- Create a new Team and add members to this Team
- Sharing Teams and Security Teams
- 1. b) Add Fields Panel
- How to add a Field in a Grid
- Navigating the Add Fields Panel
- 2. Improvements
- 2.a) ETL: Interrupt button
- 2.b) Grid: Column resize by header name or by content
- 2.c) Chart: Legend resize options
- 2.d) Formula functions
- JSON
- ENDS WITH and BEGINS WITH
🎊 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 👇
Create a new Team and add members to this Team
How to create a team:
- Step 1: To create a Team, go to Members > Teams > Click on the “+ Team” button.
- 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.
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.
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”:
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.
- 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.
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.
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.
You can also create new formulas and mappings directly from the panel by clicking on the “+ Create Formula” or “+ Create mapping” buttons.
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
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
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.
ENDS WITH and BEGINS WITH
Find the “Ends with” and “Begins with” functions in the formula editor.