When the data source contains the same ID twice (human error), the interactive map should not show the ID and not allow the user to mark one of the markers as completed, as this might mark the wrong one as completed.
Similarly, if the user already marked something as completed, but later the ID is detected as an duplicate, then the marker should no longer be styled and handled as completed.
(Optional / open for feedback:)
When an already completed marker is later detected as a duplicate, the application should remove the completed flag from the localStorage, to prevent that the mark moves to another marker when the issue is resolved in the spreadsheet.
[Edit:]
On the other hand, when someone changes something temporarily in the spreadsheet, the user might loose all of his completion data, when he access the page at the wrong moment.
=> Don't implement this.
When the data source contains the same ID twice (human error), the interactive map should
not show the ID andnot allow the user to mark one of the markers as completed, as this might mark the wrong one as completed.Similarly, if the user already marked something as completed, but later the ID is detected as an duplicate, then the marker should no longer be styled and handled as completed.
(Optional / open for feedback:) When an already completed marker is later detected as a duplicate, the application should remove the completed flag from the
localStorage, to prevent that the mark moves to another marker when the issue is resolved in the spreadsheet.[Edit:] On the other hand, when someone changes something temporarily in the spreadsheet, the user might loose all of his completion data, when he access the page at the wrong moment. => Don't implement this.