# IF-condition: Table aggregation -\> Is Not Empty

**URL:** <https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770>\
**Category:** Product Suggestions\
**Tags:** feature-request\
**Created:** [July 7, 2023, 9:43am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770 "2023-07-07T09:43:59Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [July 7, 2023, 9:44am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/1 "2023-07-07T09:44:00Z")

</div>

Hi all,  
in a trigger I can use the conditon  
Table Aggregation “Name” Is Empty  
inside the IF-part.  
I’m missing the counter part: “Is Not Empty”

Is it possible to include?

Regards Chris

---

<div class="post-metadata">

**Author:** ![John](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/john/32/4971_2.png) [@John](https://community.tulip.co/u/John)\
**Post date:** [July 7, 2023, 1:39pm UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/2 "2023-07-07T13:39:07Z")

</div>

Hi @ChrisF, thanks for sharing this. I changed this post to a product suggestion so folks can vote on it. Would you mind sharing your use-case here to help us understanding what “is not empty” would enable you to do?

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [July 10, 2023, 7:07am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/3 "2023-07-10T07:07:50Z")

</div>

Hi John,  
ofcourse I’ll do:  
1st: to complete the possibilities, because normally all conditions are like  
contains/does not contain; true/false; blank/not blank …  
so it’s stringent to offer this too  
2nd: In my app with linked record fields, I will only load a record if the table aggregation is not empty to avoid a trigger error.  
I created a table query where I use an app-variable as query input. The table aggregation is using the unique condition. So if the table query returns an empty result, the table aggregation will be empty too.  
And it’s easier for the existing code to use  
IF  
-table aggregation “FU” is not empty

- table FU has record with ID “myFU”  
Then  
…

Without the table aggregation condition “is not empty” I have to use the workaround:  
IF

- TA is empty  
Then  
do nothing  
ElseIf
- table FU has record with ID “myFU”  
Then  
…

Is it a little bit more clear now?

Regards Chris

---

<div class="post-metadata">

**Author:** ![John](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/john/32/4971_2.png) [@John](https://community.tulip.co/u/John)\
**Post date:** [July 10, 2023, 4:54pm UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/4 "2023-07-10T16:54:49Z")

</div>

Thanks @ChrisF, I appreciate the response. This kind of context is really helpful for our product teams to understand how a function like this would fit into your workflow.

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [May 21, 2024, 11:31am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/5 "2024-05-21T11:31:10Z")

</div>

Hi @John  
any news about this missing condition?

Chris

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [October 8, 2024, 8:03am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/6 "2024-10-08T08:03:51Z")

</div>

@John , @Beth

again a year without any response ☹

Will this come in the future or was it kicked?

Chris

PS:  
It’s so frustrating to work with workarounds due to all the not fully thought-out functions.

---

<div class="post-metadata">

**Author:** ![OlgaStroilova](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/olgastroilova/32/7199_2.png) [@OlgaStroilova](https://community.tulip.co/u/OlgaStroilova)\
**Post date:** [October 8, 2024, 4:41pm UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/7 "2024-10-08T16:41:34Z")

</div>

Hi Christian,

Thank you for following up on this thread.

I’m a new Product Manager who recently joined Tulip, currently covering several product areas including Triggers. Updating the Trigger editor to include this is not on the roadmap today, but let me check with the team about the history here, and I’ll circle back to this thread if we’re able to fit it in.

Out of curiosity, what’s your current workaround - e.g. do you create one IF Name is Empty, which might be blank, and then put your logic in the Else?

- Olga

---

<div class="post-metadata">

**Author:** ![ChrisF](https://avatars.discourse-cdn.com/v4/letter/c/d6d6ee/32.png) [@ChrisF](https://community.tulip.co/u/ChrisF)\
**Post date:** [October 9, 2024, 5:47am UTC](https://community.tulip.co/t/if-condition-table-aggregation-is-not-empty/8770/8 "2024-10-09T05:47:04Z")

</div>

Hi Olga,

yes, exact my use case as described above.

Regarding Triggers: are there any new information about copying functions inside a trigger to another IF-Then clause? Or duplicating a If-Then clause?

Regards Chris
