We have a list of Individuals in our CRM, and several Shortlists, with a N:N relation between them: each person can be in multiple shortlists (e.g. “VIP”, “Met at Conference X”, etc.)
I created a new shortlist S and wanted to tag several individuals with it. I selected several individuals in the database view, pressed “Edit fields”, and edited the Shortlists field, adding the new shortlist to it.
Expected behavior: it would add the new shortlist to each individual. E.g. if it was “VIP” and “Met at Milken”, then it would become “VIP”, “Met at Milken”, and S.
Actual behavior: it set each individual’s shortlists to only this new shortlist. E.g. if it was “VIP” and “Met at Milken”, it became “VIP”, “Met at Milken”, it became simply S. It is now quite difficult to recover who was in what list before, and clearly I cannot do it in a bulk manner.
I would like the bulk-editor for a relationship field to perhaps have two components: “Relations to add” and “Relations to remove”. And maybe a button to clear all relations.