Resolving Data Transfer Issues Between Tables for Enrichments | Clay

Resolving Data Transfer Issues Between Tables for Enrichments | Clay

Clay Support
APP
·
·
Use conditional runs to control column sequencing. In your lookup columns' "Run Settings," add an "Only run if" condition that checks if the enrichments have completed first.
Create a formula column using Clay.getCellStatus(#{{field_id}}) to check if your enrichment columns are finished, then reference this in your lookup columns' conditional settings.
You can also add a delay column between the enrichments and lookups to create a time buffer if needed. [1]
Clay Support
APP
·
·
Was that helpful?
Garrett W.
·
·
help
Clay Support
APP
·
·
To fix your lookup timing issue, use conditional runs in your lookup columns' "Run Settings."
Add an "Only run if" condition that checks if enrichments completed first using:
Clay.getCellStatus(#{{field_id}})
This ensures lookups only run after enrichments finish, preventing "No Record Found" errors. [1]
You can also add a delay column between enrichments and lookups for extra timing control.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the timing issue with your lookup columns, I’m here to assist. Would you like to provide more details about your setup or the specific problem you’re encountering?
Garrett W.
·
·
agent
Clay Support
APP
·
·
Would you like me to connect you with a human agent? Or if you provide more details about your setup, I can continue to assist you.
Garrett W.
·
·
agent yes
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Amit K.
·
·
Hey Garrett- in order to prevent this from happening, you can either turn the auto-update on your table off, or set the lookup column to run on a schedule. That way it could potentially run each day on a cadence to automatically update the column after all changes are made in the other table. And this will not cost any credits. Hope that helps!
Garrett W.
·
·
but i only want to update that column once, not on an ongoing basis
Garrett W.
·
·
i hear ya though
Amit K.
·
·
Yeah I totally get it, and that is a frustrating thing about Clay in that we haven't implemented delay columns yet to create a stall between when new records get added and when enrichments/actions run.