Resolving Lookup Issues in Job Orders Table with Employee Data | Clay

Resolving Lookup Issues in Job Orders Table with Employee Data

In my “job orders” table I have a column which is the clay inbuild enrichment of “Find contacts at company”. It saves emplyees data in my employees table. The column which follows is a lookup inside the employees table. My problem now is, that the lookup runs before the employee data created of “Find contacts at company” is ready and therefore break my workflow.

10 comments

Channeled
APP
·
·
To resolve this issue, you need to re-run the lookup column in your "job orders" table after the "Find contacts at company" enrichment is complete. Here's what you can do: 1. Wait for the "Find contacts at company" enrichment to finish creating employee data. 2. Once the employee data is ready, go to your "job orders" table. 3. Locate the lookup column that's linked to the employees table. 4. Force a re-run of this lookup column to refresh the data. This process ensures that the lookup pulls in the newly created employee data, fixing your workflow. Remember, whenever you add new data to the source table (in this case, the employees table), you'll need to refresh the lookup in the destination table ("job orders") to sync the updated information.
Sources: Enrich People (Waterfalls) [CRM Enrichment] - Clay University Enrich People (Waterfalls) [Automated Outbound] - Clay University
Darius M.
·
·
But I want it to be automated…you suggest manuall steps.
Channeled
APP
·
·
To automate the refresh of your lookup column after the "Find contacts at company" enrichment, you can use scheduled columns. Here's how: 1. Click the ⛭ icon on the top right of your "job orders" table. 2. Under Run the table, select On a schedule. 3. Choose a frequency (e.g., hourly for Enterprise plans, or daily). 4. Select Only selected columns and choose your lookup column. This will automatically re-run your lookup column on a set schedule, ensuring it captures the latest data from the "Find contacts at company" enrichment. Remember, Clay automatically links your Find Companies table to your Find People table, making it easy to pull company-level data into a people table without manual configuration.
Sources: Scheduled columns | Documentation | Clay University Write to Table [Clay 101] - Clay University
Channeled
APP
·
·
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Darius M.
·
·
I would like to speak with someone.
Darius M.
·
·
I still have the same challenge. The schedule function is not an option because as I could see i can only rerun my tables daily. I would like to have support form the staff here. My table: https://app.clay.com/workspaces/402702/workbooks/wb_7q2B6SsZxV7z/tables/t_pBzFkQSgRGMy/views/gv_T6YgV2CdtdiN Loom explanation video: https://www.loom.com/share/bba73822447f4ab0b66dc41ff508bb61
Darius M.
·
·
My “Employee Create” column is the in build enrichment of clay “Find contacts at company”
Daniel K.
·
·
Hey Darius, thanks for reaching out! ☺️ To get around it, we recommend is adding an intermediate HTTP API column (or multiple) to introduce a delay, such as: https://postman-echo.com/delay/40 (replace “40” with the desired delay in seconds). This can help align execution timing. Here’s a link for reference: Postman Delay Template. I enabled the HTTP feature for you for 2 weeks to get this implemented :) Here are a few resources on HTTP API columns:
A basic tutorial on using HTTP API A guide with more detailed instructions on set up
Let me know if this does the trick for you.
Channeled
APP
·
·