• 🎊 New features
• 1) Main Features
• 1.a) Controls Panel
• Create Controls
• Edit Controls
• Controls Types
• Variables Usage
• Sharing and visibility
• 1.b) Formula Editor: Grand Total
• 2) Improvements
• 2.a) Un-join data source
• 2.b) API key: Add expiration date
• 2.c) Filter: Create single formula when multi-selecting values

🎊 New features

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

1) Main Features

1.a) Controls Panel

Create Controls

To access Controls Panel, go to your Sheets section.👇

👉 Your controls are automatically added to the top panel. Click on Apply to save any modification.

Edit Controls

Find the edit icon on the left side of your Controls Panel.

Controls Types

There are 9 types of controls:

Click on each control type to find details of their configuration here 👇

Variables Usage

Variables can be used in Formulas and Filters.

Variables in Formulas

• Step 1: Open the formula editor to create a formula with your variables. Find them in the third section of the panel:

• Step 2: Click to add a variable.

Variables for Filters

• Step 1: Create a filter and select Conditon.
• Step 2: Click on the $ button ($ is the link to all your variables)

• Step 3: Select variable

• Your filter is created 👇🏼

Sharing and visibility

The control panel is personalised for each user. All users can:

• Hide and unhide controls
• Arrange controls order
• Modify variable values without affecting other users

When a sheet is shared with a user, the user can access all the sheet’s variables. If the sheet is private, all variables remain private.

1.b) Formula Editor: Grand Total

You can now use a Grand Total function in the Formula editor to impute the grand total of a given formula (first argument).

• This first argument must be of group level of details.
• The second argument (TRUE() or FALSE()) implies if the current filter of the view should be applied to compute the grand total.

2) Improvements

2.a) Un-join data source

It is now possible to delete a data source after joining it. All columns created based on this data source will remain in your sheet. To edit or delete your data source, click on the three dots menu:

2.b) API key: Add expiration date

You can now create an expiration date for you API key. Go to Settings > API key > Generate new key 👇

2.c) Filter: Create single formula when multi-selecting values

Use the drag and drop shortcut to Filter and select multiple fields to apply. You can choose to create separate columns for each value by ticking the box below.