Mike Casey
02/13/2025, 10:06 PMCeligo AI
02/13/2025, 10:07 PMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, it seems you are looking for a way to create a case formula for a saved search that checks if a field exists and then performs an action. Here is a general example of how you might structure such a formula:
CASE WHEN {field} IS NOT NULL THEN 'Do Something' ELSE 'Do Something Else' END
In this formula, {field}
should be replaced with the actual field you are checking. If the field exists (i.e., is not null), then the formula will return 'Do Something'. If the field does not exist (i.e., is null), then the formula will return 'Do Something Else'.
Please note that this is a very basic example and you may need to adjust it to fit your specific needs. For example, if you are checking a text field, you might want to check if it is not empty rather than not null. In that case, you could use a formula like this:
CASE WHEN {field} != '' THEN 'Do Something' ELSE 'Do Something Else' END
Remember to replace {field}
with the actual field you are checking.Celigo AI
02/13/2025, 10:07 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.882604122
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.866164267
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.863228798
Celigo AI
02/13/2025, 10:07 PM