How to Stop Integration When Previous Column Throws Error

Daniel K.

·

whats the best way to stop the following integration if the previous column throws an error?

✅1

11 comments

· Sorted by Oldest

Stefan R.
·
·
Add {{PreviousColumn}} in the next column as a condition. I believe this is enough, but feel free to check it out and let me know
Stefan R.
·
·
It basically means that the next column will run only for the rows where the previous column has already run successfully.
Daniel K.
·
·
https://drive.google.com/uc?id=1ZATXHOZvQT0eJeSJc4vg-NOb5xe3N8Q2
Stefan R.
·
·
Is the text column after the Apollo enrichment related to the Apollo enrichment? If yes, trying using {{ApolloEnrichmentColumn}} != "" as a condition
Daniel K.
·
·
tried that before. not working: !!{{Enrich Company}}?.organization?.short_description
Stefan R.
·
·
That's strange. I can't recreate the Apollo error in my own workspace. An idea I just had -> maybe try using the Description output from Apollo in a new Formula column. No need to do anything, just get the Description output from Apollo and put it in a new column. Afterwards try doing the empty column condition but this time using the formula column? I have no clue if this makes sense or if it's going to work but I think it's worth trying
✨1
Daniel K.
·
·
thanks a lot! will do
:sparkles-clay:1
Clay Team
APP
·
Hey there Daniel thanks for reaching. Let us know if you are still having issues with your table.
Clay Team
APP
·
·
Awesome breakdown, Stefan! and thank you for the message, Daniel!Yes, the easiest way to ask condition it to run only if it has results, or you can also prompt the AI to only run if it's not empty.The formula would look something like this: !!{{Apollo}}
Clay Team
APP
·
·
Or a variation of that depending on what field from Apollo you condition it by.
Daniel K.
·
·
can confirm !!{{COLUMN NAME} works cheers
:sparkles-clay:1

Stefan R.
·
·
Add {{PreviousColumn}} in the next column as a condition. I believe this is enough, but feel free to check it out and let me know
Stefan R.
·
·
It basically means that the next column will run only for the rows where the previous column has already run successfully.
Daniel K.
·
·
https://drive.google.com/uc?id=1ZATXHOZvQT0eJeSJc4vg-NOb5xe3N8Q2
Stefan R.
·
·
Is the text column after the Apollo enrichment related to the Apollo enrichment? If yes, trying using {{ApolloEnrichmentColumn}} != "" as a condition
Daniel K.
·
·
tried that before. not working: !!{{Enrich Company}}?.organization?.short_description
Stefan R.
·
·
That's strange. I can't recreate the Apollo error in my own workspace. An idea I just had -> maybe try using the Description output from Apollo in a new Formula column. No need to do anything, just get the Description output from Apollo and put it in a new column. Afterwards try doing the empty column condition but this time using the formula column? I have no clue if this makes sense or if it's going to work but I think it's worth trying
✨1
Daniel K.
·
·
thanks a lot! will do
:sparkles-clay:1
Clay Team
APP
·
Hey there Daniel thanks for reaching. Let us know if you are still having issues with your table.
Clay Team
APP
·
·
Awesome breakdown, Stefan! and thank you for the message, Daniel!Yes, the easiest way to ask condition it to run only if it has results, or you can also prompt the AI to only run if it's not empty.The formula would look something like this: !!{{Apollo}}
Clay Team
APP
·
·
Or a variation of that depending on what field from Apollo you condition it by.
Daniel K.
·
·
can confirm !!{{COLUMN NAME} works cheers
:sparkles-clay:1