This is probably not a bug, but I wasn’t sure where else to post it.
I have hit an issue with the favourites functionality where the
Is_Favorited? flag changes when the data in the underlying sheet is reordered. After much trial and error, I managed to come up with a simple test case that reliably replicates the problem.
The Google Sheet contains just a single column of names.
I have added a RowID column, as is recommended.
Steps to replicate the problem:
Select any name in the list (eg. Dustin Johnson), and add as a favourite. Checking the data shows it correctly tagged as
In the Google Sheet, select all the data in both columns (Name & Row ID), and reverse the order (ie. Sort Z-A by Name). Dustin Johnson is now row 14, but his Row ID has not changed.
However, Dustin Johnson is no longer tagged as a favourite. Instead, Mackenzie Hughes is the favourite - the
Is_Favorited?tag has remained with Row 7.
The weird thing is that if I “Unfavourite” Mackenzie Hughes, then the
Is Favourite flag immediately returns to Dustin Johnson.
Any assistance on how this behaviour can be explained/resolved would be very much appreciated.
(I did have a bunch of screenshots to go with this, but there seems to be a restriction on new users including screenshots, so I couldn’t add them)