I have always been confused about how to go about adding existing entities into another entities collection (i.e. linking to those entities in a many-to-many relation) through automations. The actions offered are:
- Add [Database] Item: This basically creates a whole new entity rather than searching and linking to an existing entity
- Update [Database]: This updates the linked entity/entities (based on optional filter) rather than updating the collection
- Delete [Database]: This actually deletes the linked entity/entities (based on some filter)
- Unlink [Database]: This removes the linked entity/entities from the collection without totally deleting the source entity
It seems to me there is a glaring omission here in that “Link [Database]” does not exist. You are able to use the Update Field Action to add one and and only one item to the collection but the next time you call that, it just overwrites the previous relation even though it is a many-to-many relation.
I have worked around this using scripts but I am not sure why this hasn’t been implemented. Can someone tell me what I’m missing?