Further to my earlier question, there doesn’t seem to be a way of adding existing entities into another entity’s collection (i.e. linking to those entities in a many-to-many relation) through automations. The actions currently 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
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. You are able to work around this using scripts.
So I wanted to propose a “Link [Database]” action in automations.