Flookup Changelog

[Flookup for Google Sheets]

25/03/2021: Performance improvements all round

01/04/2021: Major bug fixes for FUZZYMATCH LRM where it was returning wrong results

12/04/2021: Upgraded the "Remove duplicates" function to allow comparing two different columns

[Flookup for Google Sheets]

26/04/2021: Numbers are now treated as numbers (they are not converted to strings) and so the percentage similarity is calculated mathematically.

[Flookup for Google Sheets]

29/04/2021: When running menu functions, the function modal windows will no longer close automatically after executing the respective function. This is to overcome a bug that causes functions like "Highlight duplicates" to fail to run consistently.

[Flookup for Google Sheets]

25/12/2021: We have temporarily removed the "Maximum similarity" feature from the FLOOKUP Long Run Mode function.

This will allow a more consistent and intuitive function until we release a better way to implement that feature.

[Flookup for Google Sheets]

30/12/2021: We have added the NORMALIZE to the family of Long Run Mode functions.

[Flookup for Google Sheets]

06/01/2022: We have made three significant updates to the NORMALIZE LRM function:

1. We have added the ability to remove punctuation marks and removed it from the ordinary NORMALIZE function.
2. We have updated field names to improve your overall user experience.

We have also improved the algorithms for both versions of the NORMALIZE function to make them work faster.

[Flookup for Google Sheets]

08/01/2022:

We have made updates to the FLOOKUP LRM function. Below is the new list of modes currently available:

1. Return the best match plus similarity.
2. Return the best match plus row number.
3. Return all matches for each item.

You can read more about this update in our documentation.

There has also been a significant change to Google's function timeout policy:

Before December 2020, those who were on Consumer accounts (e.g. @gmail or @googlemail accounts) could run our "Long Run Mode" functions for 6 minutes, while those on Workspace accounts could run those functions for 30 minutes.

However, since the beginning of 2021, all account types are now limited to running "Long Run Mode" functions for a maximum of 6 minutes.

As a result of this change, we have updated Flookup (Build 731) to ensure that all affected functions continue running smoothly.

We apologise for any inconveniences caused.

[Flookup for Google Sheets]

13/01/2022: We have fixed a bug that made the "Remove duplicates" functions fail to remove all duplicates and, in some cases, they ended up causing the data to get mixed up.

[Flookup for Google Sheets]

18/01/2022: We have added ULIST to the family of Long Run Mode (LRM) functions.

[Flookup for Google Sheets]

29/01/2022: 

• Fixed an issue that caused Flookup to throw an error whenever the tableArray had no matches.
• Fixed an issue that caused functions to randomly return !IndexError.

[Flookup for Google Sheets]

13/02/2022: 

• Increased our unlimited free trial from three days to fourteen days.
• Add a Lifetime free plan for educational institutions called the Flookup EduPlan.
• Added a facility to cancel subscriptions from within the application. It can be found at "Add-ons > Flookup > Manage subscription > Cancel subscription" in the spreadsheet menu.
• Removed the "Troubleshoot" menu item. Troubleshooting instructions can still be found here.

[Flookup for Google Sheets]

18/02/2022: 

• Changed the steps needed to highlight and delete duplicates: Previously, upon launching the function window, one would have no way of adjusting the selected number of columns. Now, after launching the function window, if you would like to adjust the column count, simply click "Count columns in selection". There is no longer a need to relaunch the function window.
• Nota bene: The number of columns in the selection determines the valid values for the "Target column" and the "Secondary column".

[Flookup for Google Sheets]

22/02/2022:

• Further revised our unlimited free trial to seven days.

[Flookup for Google Sheets]

We have added a new function to the Flookup suite: MLOOKUP!

It is a modified version of the FLOOKUP function and it is specifically designed to make merging different tables easier.

Look out for MLOOKUP in the most recent update (Build 779).

[Flookup for Google Sheets]

17/03/2022:

• Fixed a bug that caused lookup functions to return the "!NoResultFound" error even when matches exist. This occurred when feeding the lookupValue parameter with arrays.

[Flookup for Google Sheets]

14/06/2022:

• Flookup free trials no longer require credit cards or registration with PayPal.

[Flookup for Google Sheets]

10/07/2022:

• The progress bar colour variations, for sidebar functions, have been updated for clarity.
• Sidebars no longer close automatically, after running a function. This is intended to make it easier and quicker to re-run that function, should it be deemed necessary to do so.
• When a function finishes processing data or times out, the sidebar will display a message indicating how many rows have been processed up to that point.

[Flookup for Google Sheets]

21/07/2022:

• Sidebar functions that fuzzy match by percentage similarity now step that parameter by 0.05 as opposed to 0.1.
• NORMALIZE can now be used to remove unwanted words by percentage similarity.

[Flookup for Google Sheets]

15/09/2022:

• The SOUNDMATCH function has been disabled and will not be available from Build 919 onwards.

[Flookup for Google Sheets]

26/09/2022:

• FLOOKUP LRM can now be used to merge data from other datasets.

[Flookup for Google Sheets]

15/09/2022:

• The SOUNDMATCH function has been disabled and will not be available from Build 919 onwards.

04/10/2022:

• The SOUNDMATCH function has been fully restored. This decision was taken after a critical bug was fixed.

[Flookup for Google Sheets]

14/10/2022:

• The NORMALIZE function is now free to use without prior registration or subscription.

[Flookup for Google Sheets]

30/11/2022:

• When removing duplicates, you can now choose to look-up or look-down the table. The former will retain the first unique value Flookup finds and delete the rest, while the latter will remove all duplicates but retain the last unique value Flookup finds.