Posting here as an FYI as I’ve filed a bug report but am yet to get anything useful back from Support.
I’ve had unchanged workflows in place for over 12 months that recently stopped working correctly. Essentially these workflows do something different to a record depending on another field linked to the record being empty or not.
It seems that there has been a recent change where deleting an item from the database via a workflow no longer truly clears that item from linked records. If the item that was deleted was linked to another item as a list and was the only item in said list, the system thinks there is still a list in place on the linked field even after deletion (see editor debug below).
If I understand correctly, this is a long-standing and known issue. See this thread. In my experience, it happens regardless of the number of items remaining in the list. (I first encountered it years ago in the context of a shopping cart stored as a list of cart items directly on the user.)
Basically, as a best practice, a reference to a thing should always be explicitly removed from list fields before deleting the thing from the database.
Great info, thanks. Searched around before posting and somehow did not come across that thread or any of the others.
I’ve adjusted my workflows, but this definitely would have been broken in my app for well over a year so I’m a bit surprised I’ve just noticed it, but maybe related to Bubble performance as a whole as well as the growth of data in my app.
