IF-condition: Table aggregation -> Is Not Empty

Product Suggestions
1

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

2

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?

3

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

4

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.

5

Hi @John
any news about this missing condition?

Chris

6

@John , @Beth

again a year without any response :frowning:

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.

7

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
8

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