Actiondesk Product Updates
Actiondesk Product Updates

Actiondesk Product Updates

Actiondesk lets you access, explore and analyze all of your data in one place. It's as easy to use as a spreadsheet, as powerful as a BI tool.

Top priorities on our roadmap:

  • Sorting
  • Graphs
  • Collaboration
  • Being able to create a table with manual inputs, and not only imported data
  • Better error management for formulas

January 14, 2021

Dragging a cell to copy ๐Ÿ‘‰

  • You can drag a cell to copy it over a range the same way you could in Google Sheets or Excel

image

Force refresh ๐Ÿ”„ ๐Ÿ‘‰

  • You can now refresh your raw data manually if at any point you want to make sure you have the latest data.
  • You just have to click on the refresh icon at the top right
  • You can also use the shortcut on Mac option + 9

image

image

๐Ÿ‘ˆ Loader in filter by values

  • When you import data, it takes us a bit of time to index all of the values of each column
  • This means that when opening the filter by values menu, it could be blank
  • Now we have a loader there so you know your list of uniques values is coming

Bug fixes ๐ŸฆŸ

  • The border formatting was not working anymore, it's now fixed.
  • The message error during spreadsheet loading was appearing very often, we made some fixes to prevent this.
  • The contextual menu was not disappearing after choosing an option within it, this is now fixed.
  • Cutting and pasting a cell or range would lead to unexpected grey formatting, this is now fixed.
  • As a collaborator, you couldn't edit the import created by another user from your workspace. This is now fixed.
  • The highlighting of table columns when writing formula was not working when the said column had a space in it, now fixed.
  • Resizing a column or row where there's a hidden column or row was not working well. now fixed.

Quality of life improvements ๐Ÿน

  • When formatting numbers to dollars, you now will have no more than 2 decimals. You could previously have many decimals which was frustrating.
  • The average and counta formula can now be used on any range of the spreadsheets (before that, it was only using table columns)

December 29nd, 2020

Big update today:

๐Ÿค Work with your colleagues in Actiondesk

  • You can now invite collaborators to Actiondesk
  • Head to the profile icon and click on Invite Collaborators
  • Enter the email addresses of your collaborators
  • They will then receive an invite to create their account

โš ๏ธ One current limitation is that you cannot invite people who already have an actiondesk account. Two workarrounds:

  • If they're okay, we can just delete their account. Shoot us an email and we'll do that for you
  • Another workaround is to invite a different email address. If you want to invite jonathan@actiondesk.io who already has an account, then send the invite to jonathan+actiondesk@actiondesk.io

image

Paste value

  • You can now copy formulas or others and paste only the value
  • To paste value, right click and then paste special / paste value

Renaming sheets at the bottom

  • You can now double click on the tab to rename the sheet, just like in google sheets

December 22nd, 2020

๐ŸŽ You can now fly through the import menu with your keyboard

  • Press enter to enter in any dropdown
  • Press tab to go to the next step
  • When selecting columns, you can navigate in the list with up and down arrows, and select / unselect a column by pressing space
  • Once you're done selecting column, press tab and then enter to proceed with the import

๐Ÿ›  Manage your data sources ๐Ÿ‘‰

  • You can now see the list of all your data sources and delete the ones you don't need anymore
  • Press on your profile icon, and then Manage data sources to access this menu
  • Soon, you'll be able to edit them as well

image

๐Ÿ˜ป Emoji in folders

  • You can now add emojies to your folder
  • Open the left menu, hover over the folder, and you'll see the emoji icon appearing, press on it and then select your emoji

๐ŸŽจ See active sheet and open sheets in the left menu ๐Ÿ‘‰

  • You'll have a purple dot on any sheet that's open
  • The active sheet (the one you're currently looking at) will also have a purple bar on the left

๐Ÿž Bug fixes

  • There was a bug where a lookup function written in small letter wouldn't work. Fixed โœ…
  • There were some issues with Airtable imports where some formulas would return errors and calculations would generally be slow. This is now fixed and the performance has been greatly improved. โœ…
  • There was a bug where if you clicked on the formula bar when you your cursor on a calculated column, the content of the column would disappear. Fixed โœ…
  • The import button sometimes didn't work properly. Fixed โœ…
  • Formulas would be broken if you changed the name of the sheet containing the data used in the formula. Fixed โœ…
  • The loader on the Add a data source button wouldn't always display. Fixed โœ…
  • The operator >= didn't work for some time, now fixed โœ…
  • Finally, when applying percentage formatting, you'd have many decimals that you'd have to reformat. Fixed as well โœ…
image

December 9th, 2020

Quality of life improvements

  • Shortcuts to fix cell references.
    • Instead of adding $ manually to fix a cell reference, you can just use Option + 4 (Mac) / F4 (Windows).
      • Use it once to fix the reference entirely (both rows and columns)
      • Twice to fix the row
      • Thrice to fix the column
  • If you're used to using F2 to enter in a cell (like in Excel), it now has the same behavior in Actiondesk too

New Stripe and intercom imports

  • You can now import companies from Intercom
  • You also import charges and Balance transactions from Stripe

New search bar to search sheets

  • We've added a search bar to search your sheets. Hit Cmd + P (Mac) / Ctrl + P (Windows) to access the search bar on the left menu.
image

Filters within filters

  • Filters: If you apply a filter on a first column, then the available option in the filters of other columns will be filtered out

image

Bug fixes

  • Fixed multiple issues linked to download csv
  • Fixed an issue that led to the RIGHT formula not to work properly

December 2nd, 2020

As we've had a surge of users in the past few weeks, the main focus was ensuring the app was stable and reliable for all these new users.

Drastically improved stability and reliability

  • We fixed most of the issues that could lead to table data not being loaded and formulas not returning a result.
  • Formula errors: You now have a detailed error message when a formula you write is wrong. We'll keep on improving these to make it as easy as possible to debug a formula.
image

New integrations

Quality of life improvements

  • If you write a formula or add a filter on the right of your screen, it will be offset so that it's not hidden by the end of the screen.
  • If you scrolled down a table, and then apply a filter, it will scroll up automatically

Bugs

  • We fixed 67 bugs ๐Ÿ›in the past 9 weeks ๐Ÿคฏmainly improving the way writing a formula works
  • There was a bug that didn't let you erase the last sheet at the root of a folder. This is now fixed โœ…

New features

  • New import menu ๐Ÿ‘‡
    • It's now easier to choose columns you want to import with checkboxes.
    • We also added a select all and clear options
image
  • You can now hide several columns or rows at the same time. Just select columns, rows or a range, right click and then choose Hide columns or Hide rows
image
  • If you add emojis to your sheets, they'll now be displayed also in the bottom tabs โ˜๏ธ

October 6th, 2020

New UI

Before:

image

After:

image

Add emojis to sheets ๐Ÿ˜

  • Just hover on your sheet title
  • Click on the emoji icon
  • Choose your emoji

image

September 29th, 2020

Folders and organizing sheets ๐Ÿ—‚ ๐Ÿ‘‰

You can now:

  • Create folders
  • Move sheets to a specific folder
  • Create sub folders and sub sub folders
  • Delete folder
  • Rename your workspace
  • Expand / collapse the content of each folder

Bug fixes and improvements ๐Ÿ› 

  • โœ… Fixed some issue with the copy paste to a table.
  • โœ… In the case where you had a lookup using data from a user generated table, and you changed the data in that table, it wouldn't change immediately the results of the lookup. It's now fixed
  • โœ… Fixed a bug that prevented some users to download a sheet to csv
  • โœ… Fixed some bugs related to SQL queries imports
  • โœ… Fixed several issues related to writing and editing data into a user generated table

UI improvements ๐ŸŽจ

We've redesigned a few components including:

  • Tabs
  • Formula bar
image

September 15th, 2020

Copy and paste CSV to a table

  • If you need to use data from a CSV, you can now easily paste this data into a user generated table in Actiondesk and mix it with dynamic data coming from your data sources

Onboarding flow

  • We now have a new onboarding flow to show new users the most important features of Actiondesk

Bug fixes and improvements ๐Ÿ› 

  • Fixed a bug that made impossible the edition of custom SQL query imports
  • Fixed many small bugs related to user generated tables

September 8th, 2020

๐Ÿ‘ป Hide column or row ๐Ÿ‘‰

  • You can now hide a column or a row
    • Right click on a cell or on a column / row
    • Then choose Hide column or Hide row option
    • To unhide, simply click on the double arrow between the columns
  • Limitations
    • You cannot hide several columns or rows at the same time

Bug fixes and improvements ๐Ÿ› 

  • You can now rename the headers of a user generated table as well as notes columns
    • Limitation: Avoid renaming columns once you have computed columns or formulas using these columns. It will break things.
image

September 1st, 2020

image

๐Ÿ‘ˆ User generated tables ๐Ÿ“

  • Previously, you could create a table only by importing data from a data source. You can now create a table from scratch and manually fill it
    • Right click anywhere and choose Insert table
    • Fill the table with data
    • To add a column, just write the title of the column on the right of the headers
    • To add a row, just write data in any of the cells right below the table
  • Current limitations
    • You cannot rename the headers, we'll fix that asap
    • You cannot copy and paste data into the table

Bug fixes and improvements ๐Ÿ› 

  • Fixed a bug that prevented users from editing a SQL imported table โœ…
  • Fixed one display issue with data overlaps โœ…
  • Fixed various bugs linked to the Notes columns feature that we released the week before โœ…
  • Fixed a bug that led to formulas not working when inserting a column. โœ…
  • Fixed a bug where aggregation formulas were displaying "..." forever if you made a syntax mistake in the column reference. It now returns an ERROR โœ…

August 25th, 2020

Notes columns ๐Ÿ—’๏ธ

  • Previously, you could only add calculated columns
  • Now, you can add a column and write text or numbers in it.
  • What you write in these columns will always stay associated to the right record, even when you data refreshes

Limitations:

  • This won't work for tables created before we shipped the feature, only for new tables
  • For it to work, you need to make sure you import the primary key field of your table (generally the id for SQL, vid for Hubspot contacts, dealid for Hubspot deals, etc)

image

Bug fixed and improvements ๐Ÿ› 

  • Fixed problem that prevented the editing of SQL query imported tables โœ…
  • Fixed a bug that led to problems when editing a Hubspot imported table โœ…
  • Copy paste Improvements: You can now select a range and paste it over a bigger range โœ…
  • Fixed bugs that led to wrong data returned when filtering tables โœ…
  • If you delete a column or row of which some cells were referenced in formulas, the formula will now return an error and you'll have a REF! instead of the referenced cell โœ…

August 11th, 2020

Insert / Delete column and row ๐Ÿ‘€

  • You can now insert a row, insert a column, delete a row, delete a column
  • Just right click on any cell / column / row and you'll have the various options available
    • Insert 1 column left
    • Insert 1 column right
    • Insert 1 row above
    • Insert 1 row below
    • Delete column
    • Delete row

Desktop app ๐Ÿ–ฅ

  • Brand new desktop app for Windows, Mac, Linux. Download it here

Bug fixed and improvements ๐Ÿ› 

  • Fixed a bug that led to not being able to select a column from another sheet when this column was the same column as the one where you're writing the formula โœ…
  • Fixed a bug with the cut paste that led to some problem when copying and pasting something right after having cut something else โœ…

August 4th, 2020

SQL: Support for private schemas ๐Ÿ‘€

  • If you have tables you need to use that not in the public schema, you can now use them as well
  • They will appear in the dropdown "choose your table" prefixed with the schema name: schema_name.table_name

New formulas ๐Ÿงฎ

Bug fixes and improvements

  • Fixed a bug that led to the error message you already have a spreadsheet with this name when entering in the sheet title, doing nothing and pressing enter (or clicking anywhere else) โœ…
  • When you cut and pasted a range containing empty cells, it pasted a 0 instead of an empty cell. This is now fixed โœ…
  • Fixed a bug that led to the formula bar being empty when you were pressing escape on a cell containing text or a formula โœ…
  • Fixed an issue that led to a cell appearing empty if you applied the % format on an empty cell and then wrote on it โœ…
  • Fixed a bug that led to empty dates appearing as Invalid date for hubspot imports โœ…
  • Fixed an issue that made the selection of a column not possible when editing an existing formula from the formula bar โœ…

July 27, 2020

Copy and paste Unique ๐Ÿคฏ๐Ÿ‘‰

We're particularly excited for this feature which saves time and headaches in many cases

  • Right click on any cell of a column from an imported table
  • Select "Copy Unique"
  • Paste your unique values wherever you'd like

This is very helpful when you build a dashboard and want to do a conditional count, sum or average depending on one or several conditions

image

image

๐Ÿ‘ˆ Include function

We're not going to lie, we're pretty excited about this one too ๐Ÿค—

  • New function: INCLUDE(substring, string)
  • Include returns TRUE if the string contains the substring, FALSE otherwise
  • Include can be used in a computed column or in the spreadsheet

Bug fixes & Improvements

  • There was a bug where if you opened a sheet with formulas, but didn't open the sheet with the table that these formulas used, the formulas wouldn't compute. This is now fixed โœ…
  • When entering in a non empty cell and pressing escape, the formula was empty. This is now fixed โœ…
  • Cut paste a range with empty cells used to paste 0. This is now fixed โœ…
  • Divided by zero used to return โˆž, it now returns ERROR โœ…
  • If you removed column from an import which was used in a computed column, it would bug your whole import. This is now fixed, the computed column will just return ERROR โœ…
  • You couldn't select a part of text within a formula with your mouse, this is now fixed โœ…
  • If you did Cmd + Z (Mac) / Ctrl + Z (Win) after pasting a range, it just removed one cell instead of the whole range. This is now fixed โœ…
  • Sheets with more than 500 formulas tended to be slow, we did a fix for this and the performance is now similar to an empty sheet โœ…
  • If you had an import with a filter, and you'd add or update a computed column and make an error, it would crash the sheet. We fixe โœ…
  • If you were trying to count the number of cells empty in a column of a table where this column is a date (for example: the date entered columns in Hubspot deals), it would return systematically 0. This is now fixed โœ…

๐Ÿค–AI experimentation

  • This is not in production at the moment but we started playing with the GPT-3 API from OpenAI
  • It could power a "Ask me Anything" function, which given a question as an input would give you what you need.
  • See example where we ask the population of a list of countries ๐Ÿ‘‰

image

July 20, 2020

The past 5 weeks have been focused on stability, reliability and bugs fixing

We solved a grand total of 77 bugs in the past 5 weeks ๐Ÿคฏ๐Ÿ˜“๐Ÿ’ช

Improvements and bug fixed on Hubspot integration ๐Ÿ’พ

  • Fixed bugs which lead to having empty columns with Hubspot with an account with more than 300 properties โœ…
  • Fixed some issues linked to the import of Hubspot data which led to the import of data to be very slow ๐ŸŒ(several minutes) for dataset of more than 50,000 records โœ…
  • Fixed bug which led to formulas not working when Hubspot properties contained special characters such as :, ', or () โœ…
  • Added Hubspot import: Owners
    • This is helpful if you want to lookup the full name or email of a deal or contact owner

Improvements made on the spreadsheet experience ๐Ÿค“

  • Modified the table loader, see screenshot on the right ๐Ÿ‘‰
  • Made improvements to the way aggregation calculations are made. Now when you change a parameter, only formulas that depends on this parameter will recalculate instead of all of them previously ๐ŸŽ
  • Fixed a bug: when you were selecting a range with Cmd + shift + arrow (or control + shift + arrow for windows), and part of the range was out of the screen, the screen was not moving. It's now solved. โœ…
  • Fixed a bug that led to some basic math operations (particularly ratios) to return ERROR โœ…
  • You can now write formula names in small letters, it will work whereas it previously didn't
  • We now automatically close parenthesis if you forget a parenthesis in a formula both in the spreadsheet and in computed columns
  • Improved cut paste: There was some issues with the paste of the format that are now fixed
  • Fixed bug related to decimal formatting that led to users not being able to remove decimals from a calculation โœ…

image

Improvements made to aggregation formulas ๐Ÿงฎ

  • Fixed a bug that led to aggregation formulas not calculating unless you opened the sheet with the raw data. โœ…
  • Fixed many bugs related to aggregation formulas. It happened frequently that some formulas wouldn't return a result unless you refresh the page. It's now not happening again. โœ…

Improvements on imports ๐Ÿ’ช

  • Fixed a bug with edit of imports which was not working properly anymore โœ…
  • Fixed a bug that messed up the order of columns when you edited your import after having added a computed column โœ…
  • Fixed a bug with led to the sheet not loading when adding a computed column after a filter. โœ…

Error management ๐Ÿ˜“

  • If there's a problem with a filter, instead of blocking you, you'll get an error message saying the filter has encountered an unexpected problem. The filter will be removed, and you'll be able to continue working on your data.
  • If there'a an error with a computed column, or an aggregation formulas, it will now always return an error and not block you while working on your data.

Better management of null values 0๏ธโƒฃ

  • Previously, null values were appearing as zero. They now appear as blank
  • You can now do a condition test on null values. If the column "test_column" has some null values in some records, and you add a computed column with the formula =#test_column="" , these records will return true.
  • If you a calculation with null values, they'll be considered as zero. If "test_column" is null, then =#test_column + 1 will return 1

June 12, 2020

  • In the past two weeks, we mainly worked on:
    • Solving bugs linked to data imports and formulas
    • Putting in place a better infrastructure and tools on our end to solve bugs much faster.

June 1, 2020

New Hubspot integration

  • Connect your hubspot account to Actiondesk
  • Import deals, companies and contacts data
  • See demo here

image

May 25, 2020

๐Ÿ”Ž Lookup

  • You can now retrieve columns in one table from another table using a matching key
  • Tutorial here.

image

May 18, 2020

๐ŸŽ Computed columns

  • You can now add a column to your imported tables and write a formula in this table using other columns from the table.
    • This formula will automatically apply to all the rows.
    • As your table refreshes with new data, the formula will automatically apply to the new rows.
  • You can edit just by entering in any cell of the column and changing the formula
  • You can delete a computed column by right clicking on any of the cell of the column and choose "Delete column"
  • Some use cases

New formulas

  • YEAR: returns the year of a specific date
    • Ex: YEAR(02/02/2020) will return 2020
  • MONTH: returns the month (as a number) of a specific date
    • Ex: MONTH(02/02/2020) will return 2
image

May 11, 2020

Bug fixes & refinements

  • Fixed multiple bugs related to creation and edition of SQL query imports
  • Fixed multiple bugs that lead cells with content to appear empty when entering in them
  • Fixed multiple bugs that lead aggregation formulas to not return results

May 4, 2020

Bug fixes & refinements

  • Fixed a bug that led the input dropdown in the import menu to not be clickable
  • If you write a cell reference in small caps, it now works
  • Fixed a bug that led to duplicates in the filter by values component on dates
  • Fixed a timezone related bug that led to problems connecting databases for some users
  • Fixed a bug with the autocomplete component
  • We changed the "In between" filters operator on dates. It used to exclude the start and end dates. It now includes them.
  • Fixed a bug that led to the sheet freezing when doing cmd (or control) + bottom arrow and going to the bottom of the sheet
  • New "New sheet" button right by the tabs. Easier to access.
image

New formulas

  • Countif, Sumif
  • Countunique, countuniqueif, and countuniqueifs

April 16, 2020

References between sheets ๐Ÿ”—

  • In formulas, you can now reference to cells, ranges, columns from imported tables from other sheets.
  • As Actiondesk doesn't have a concept of files, it means you can reference to any sheets that exist in your workspace ๐Ÿคฏ

Significant performance improvements ๐ŸŽ

  • There were lags when scrolling down an imported table. You can now easily scroll down thousands of rows without any lag.
  • You can import up to 100k records. Loading and computing of aggregation formulas will take 5-10 secs but it will work. We don't guarantee performance, but you can even try 500k rows
  • There were lags in the spreadsheet when you had more than 10 aggregation formulas, this has been fixed

Bug fixes & Refinements ๐Ÿ”ง

  • When scrolling down on a table, you'll now still be able to access the filters
  • You now don't have to click on the arrow for filter by condition and filter by values, you can just click on the text
  • Fixed a bug that caused filter on date ranges to be inaccurate
  • Fixed a bug that caused filter in exact date to not filter
  • Fixed a bug that caused tab names not to be updated when renaming a sheet
  • Fixed a bug that caused columns from an imported table to be loaded not at the same time

March 30, 2020

Filters ๐Ÿ˜Ž

Here's a much improved version of filters:

Filter by values

  • Like in Google Sheets and Excel
image

Filter on dates

  • Four date operators
    • Is exact date
    • Is after
    • Is before
    • Is between
image

New integration SQL Server ๐Ÿฅณ

You can now connect a Microsoft SQL Server, import tables and SQL queries into your Actiondesk spreadsheet

image

Edit cell content from the formula bar ๐Ÿค“

This was highly requested

image

Tabs!! ๐Ÿ˜‡

  • Have several sheets open
  • Toggle easily between them through bottom tabs
  • Coming soon: references between several sheets

March 16, 2020

Filters

Here's the first version of filters.

For columns that are texts, you can use the following filter operator:

  • Is Equal to
  • Is not Equal to

For columns that are numbers:

  • Is Equal to
  • Is not Equal to
  • Is greater than
  • Is greater than or equal
  • Is less than
  • Is less than or equal
image

Over the next two weeks, we'll ship a v2 of this feature:

  • Filter by values like in Google Sheets and Excel
  • Filter on dates

image

New functions

We've added four new functions:

  • ROUND, ROUNDDOWN and ROUNDUP: respectively rounds, rounds down and rounds up a number
  • PMT: Returns the periodic payment for a loan

Automatic fixed headers for imported tables

As you scroll down on the spreadsheet, headers of your imported tables will always be visible

image

Bug fixes

  • It is now possible to copy a value from an imported table and paste it
  • Fixed other bugs related to copy pasting

February 28, 2020

Cancel last action through Cmd + Z (mac) / Ctrl + Z (Windows)

You can cancel any of following actions:

  • Writing in a cell
  • Editing a cell
  • Applying a format
  • Resizing a column or a row
  • Paste

Cut and Paste

You can now cut with Cmd + X (Mac) / Ctrl + X (windows). It currently only works for cells, not for ranges.

New functions

We've added the two following functions:

  • TODAY: Returns the current date
  • NETWORKDAYS: Returns the number of net working days between two provided days.

Also, you're now table to perform calculation on dates. For example =TODAY()+1

Aggregation formulas are now reactive

When you have an aggregation formulas where:

  • The criteria columns is a column from an imported table
  • The criteria is another cell

And when you change the parameter cell, now the formula will recompute automatically

Three new shortcuts

  • Open the left menu with Cmd + [ (Mac) / Ctrl + [ (Windows)
  • Open the right import menu with the shortcut Cmd + \ (Mac) / Ctrl + / (Windows)
  • Lock cells
    • Within a formula, you can toggle between locking the cell, locking the row, locking the column with Option + 4 (Mac) / F4 (Windows)

Insert and delete column and row

  • You can now insert a column, insert a row, delete a column and delete a row
  • Just right click on a cell or column / row and you'll have the options in thez