# Automations overriding one another

**URL:** <https://air.tableforums.com/t/automations-overriding-one-another/311>\
**Category:** Automations and Integrations\
**Created:** [February 21, 2023, 10:24pm UTC](https://air.tableforums.com/t/automations-overriding-one-another/311 "2023-02-21T22:24:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![locale](https://avatars.discourse-cdn.com/v4/letter/l/9d8465/32.png) [@locale](https://air.tableforums.com/u/locale)\
**Post date:** [February 21, 2023, 10:24pm UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/1 "2023-02-21T22:24:57Z")

</div>

Hi!  
We have 7 different “campaign” types we sell to our advertisers, many of which have overlapping items (i.e. and Instagram Story). I want to create automations so that when a new record (Campaign A) is created, all of the line items for that type of campaign are also created, along with their starting point for each cell. The issue I am having is, since Campaign B also has an Instagram story, but has a different starting point, the cells within the Instagram Story line are initially populated correctly and then overridden by the other automation. Is there a way to have them both be live, or will each line item in every type of campaign have to be different, even though they are the same product? I’ve attached two screen shots of the different automations for you to see what I mean…

 ![Screenshot 2023-02-21 at 2.25.39 PM](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/cfd3191d68e8c86babb8c7c599c4000e89c355df.png)

---

<div class="post-metadata">

**Author:** ![locale](https://avatars.discourse-cdn.com/v4/letter/l/9d8465/32.png) [@locale](https://air.tableforums.com/u/locale)\
**Post date:** [February 21, 2023, 10:26pm UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/2 "2023-02-21T22:26:32Z")

</div>

![Screenshot 2023-02-21 at 2.25.27 PM](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/8aa80ee6904a7047d7da91e2399279314802249c.png)

---

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [February 22, 2023, 12:51am UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/3 "2023-02-22T00:51:53Z")

</div>

Welcome to the community, @locale!

I’m not sure I fully understand. Are you saying that for each client record in your database, you want to schedule multiple different types of campaigns for that particular client, and each campaign type also has its own list of tasks associated with it as well?

if so, this would require a significantly more complex setup, and it would also make data entry a little bit more difficult as well. Automating this would be slightly challenging as well.

This sort of a setup would likely require a “many-to-many relationship”, which requires 3 tables that are all linked together.

You would have:  
(1) a clients table,  
(2) a campaign type table, and  
(3) a line items table.

The line items table is where you would do most of the data entry. Each line item would be linked to ONLY ONE client and ONLY ONE campaign type, and would also have its own unique start date. Then, you could build the calendar from the line items table.

This can get a little bit complicated, but Airtable has an article discussing many-to-many relationships here:

> **[Understanding many to many links in Airtable | Airtable Support](https://support.airtable.com/docs/understanding-many-to-many-links-in-airtable)**
>
> Learn how Airtable uses the concepts of relational databases to link many records to one another.

---

<div class="post-metadata">

**Author:** ![locale](https://avatars.discourse-cdn.com/v4/letter/l/9d8465/32.png) [@locale](https://air.tableforums.com/u/locale)\
**Post date:** [February 22, 2023, 3:25am UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/4 "2023-02-22T03:25:33Z")

</div>

Hi!  
No this isn’t per client, it’s per campaign. So as you can see below when I added a Campaign L in, the automation created a line item just as it was supposed to, but then it was overridden by another automation that is tied to Instagram Stories…so essentially I need to find a way for just that initial automation to run/work when the campaign line is the first step. There are times where we add on random Instagram Stories (added value for a client let’s say) where the starting point is different

 ![Screenshot 2023-02-21 at 7.22.17 PM](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/1X/79dbc6b155e9f5b702e95fac26f307c7c01f3bf2.png)

---

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [February 22, 2023, 4:00am UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/5 "2023-02-22T04:00:02Z")

</div>

Perhaps you can create a Loom video to explain the problem in more detail?

---

<div class="post-metadata">

**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\
**Post date:** [February 22, 2023, 4:04am UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/6 "2023-02-22T04:04:12Z")

</div>

My initial reaction is that your automation needs to take into account both the campaign starting point as well as the campaign line item. You may be able to do this by using different conditional actions or by using multiple automations with different triggers.

---

<div class="post-metadata">

**Author:** ![locale](https://avatars.discourse-cdn.com/v4/letter/l/9d8465/32.png) [@locale](https://air.tableforums.com/u/locale)\
**Post date:** [February 22, 2023, 4:42am UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/7 "2023-02-22T04:42:20Z")

</div>

Yeah, so the only problem with different triggers, is that we have about 8 campaigns, so I don’t know how I would configure 8 different triggers for the same goal of creating the line items each campaign needs.  
This could very well just be something that Airtable could enact with a feature request (no idea how long) but as of now, I don’t think that would work, as each of the 8 campaigns have overlapping items.

---

<div class="post-metadata">

**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\
**Post date:** [February 22, 2023, 12:28pm UTC](https://air.tableforums.com/t/automations-overriding-one-another/311/8 "2023-02-22T12:28:35Z")

</div>

> [@locale](#):
>
> I don’t know how I would configure 8 different triggers for the same goal of creating the line items each campaign needs.

Can you list out the different situations in plain English? What are the input fields and values that uniquely identify each situation?
