For the google sheets lookup enrichment, how would i write a formula that makes this only run if this lookup has run before, whether or not theres a result or not, and not just if there was no return value?
Separately, when i filter on a look up from a different clay table, i see these options, but what i want to see is all rows that have been run (whether there was a result or no result). None of the options below give me that, I can only see the following, but there's no "Has run" option. Am i missing something? has an error does not contain an error has results - Run with result has no results - Run with no result has not run - Not Run run condition not met
Thanks Bo! The follow up to my first post is more like a workaround because i couldn't figure out how to write that rule, hence i was trying to filter for both run with results and run without results
Do you see it now? I'm going to send it via slack instead of intercom. Sorry for the mixup
I see it now, thanks! Related question: https://clayrunhq.slack.com/archives/C025KSBLPGX/p1725386509892069 If i change this rule halfway, does it cause all the previous values to re-run again if i click run again or if i turn on auto update?