# Many-to-many Linking in Automations

**URL:** <https://community.fibery.io/t/many-to-many-linking-in-automations/2480>\
**Category:** Ideas & Features\
**Tags:** automations\
**Created:** [February 3, 2022, 6:26am UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480 "2022-02-03T06:26:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Post date:** [February 3, 2022, 6:26am UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/1 "2022-02-03T06:26:51Z")

</div>

Further to [my earlier question](https://community.fibery.io/t/link-to-collection-item-action/2457), 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.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 3, 2022, 7:11am UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/2 "2022-02-03T07:11:45Z")

</div>

Just to clarify, it is possible to link multiple items using the Update Field action, but you’re right that these items will replace any previous linked items, rather than add to the collection.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [February 3, 2022, 4:25pm UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/3 "2022-02-03T16:25:47Z")

</div>

Having a separate “add entity(ies) to collection”, while NOT overwriting the existing collection, would seem like a pretty fundamental capability.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 3, 2022, 4:36pm UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/4 "2022-02-03T16:36:51Z")

</div>

Yep, only currently possible with a script, I’m afraid ☹

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 11, 2022, 11:29am UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/9 "2022-03-11T11:29:05Z")

</div>

Fixed 🙂

> [@CHANGELOG: March 10 / Limit Access by IPs, “Link \[Collection\]” Action, 10 Fixed Bugs](https://community.fibery.io/t/changelog-march-10-limit-access-by-ips-link-collection-action-10-fixed-bugs/2625):
>
> We are slowly getting back to work. Some people are relocating from Belarus, so development speed was not great last two weeks. Here is the first Spring release with some minor improvements. Limit Access by IPs Now you can make your Fibery workspace secure by allowing a list of IPs to access it. Navigate to Workspace Settings and find Access Settings section. Automations: “Link [Collection]” Action Now you may link existing entities to the parent entit…

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [March 11, 2022, 11:29am UTC](https://community.fibery.io/t/many-to-many-linking-in-automations/2480/10 "2022-03-11T11:29:42Z")

</div>


