Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Resolving Data Transfer Issues Between Tables for Enrichments

·

·

hey guys - im trying to send data from one table to another, where we do a bunch of enrichments, and then pull the results back into this master table. unfortunately the lookup columns are running before the enrichments can complete. is there a way to account for this? https://app.clay.com/workspaces/532984/workbooks/wb_0t3wfuxvq94vcsjWvVt/tables/t_0t3wgk2rTPnvYpZ4MxA/views/gv_0t3wgk2tWkkd5K5oZUv

Loading attachments

11 comments

· Sorted by Oldest

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 Wolfe
·
·
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 Wolfe
·
·
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 Wolfe
·
·
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!