Calculated Column Calculation Failure When Credits Run Out: Any Solutions? | Clay

Calculated Column Calculation Failure When Credits Run Out: Any Solutions?

It seems like when there's a calculated column and credits run out, the calculation fails to perform. Is there a way around this? See below:

6 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Adam W.
·
·
https://app.clay.com/workspaces/209795/tables/t_p2DmsiNftExX/views/gv_1kPmonAS0CEb
Clay Team
APP
·
·
Hey Adam, thanks for reaching out! Taking a look
Clay Team
APP
·
·
Ah, looks like it's working properly but rather than not calculating the final output it seems that the validation provider checking each of these emails determined the email was not valid (the validation columns are hidden but you can unhide them if you'd like to check)
00ab12b0-994b-421d-937b-94483f56f227.png(40 kB)
Clay Team
APP
·
·
In case this helps, here's a more detailed breakdown/explanation of what is happening. The waterfall gives you the option to add a validation provider to check results from each email finder. When the validation tool determines the email is invalid, the next email finder tries to find a new one, but if it finds the same email as the previous column it won't try to validate it again because it already tried to validate once before, and this could result in no final output because none were valid.We automatically hide validation columns helping keep tables clean and that's why it's not evident at first glance. Let me know if you still have any questions though!Example and explanation: https://www.loom.com/share/e79acd92841a4706b1710c4ce1bddaa4
Clay Team
APP
·
·
To continue running the columns, you can click on the play button on top of each one so they pick up where they left off, it should not re-run those that already found results (unless the inputs or input sources they were given changed)