Issue with Write to Other Table Function in Clay Workspace | Clay

Issue with Write to Other Table Function in Clay Workspace

I have an issue with the function Write to Other Table - used in this view: https://app.clay.com/workspaces/558381/workbooks/wb_2fmTBMbNuzY6/tables/t_rujvfAh5FBD2/views/gv_t9WQjtfHKJgw - I am running the column - Write Hiring Manager LI - ROW Nr. 6 I get the answer Created 1 Record in TAB BUT the record can not be find in the specific table. So basically it seems to be executing but it does not write the ROW. - Can you please help?

6 comments

Channeled
APP
·
·
If your write to table function shows it created a record but you can't find it, try using the Force Run option in your table settings. This may take some time depending on table size. Alternatively, try these steps: 1. Delete the affected column 2. Create a fresh column 3. Re-map your data to the destination table Also check if your API key is properly connected under Settings > Connections > search for Clay.
Source: Write to Other Table | Documentation | Clay University
Irina C.
·
·
I have in this table: https://app.clay.com/workspaces/558381/workbooks/wb_2fmTBMbNuzY6/tables/t_0swimqtXCc8KqVoGC3C/views/gv_0swimqufzdqevPi3x7Y the function Lookup single ROW but I am not able to find the information - "Open Job Personalization" even if it exists in the table "Account | US | 11-50 | 51-200"
Irina C.
·
·
For example: I have this company CXAI in Account and has the information - Open Job Personalization completed in the table Accounts. When I writing in the People Table - "Hiring | People | US | 11-50 | 51-200" CXAI does not have the Open Job Personalization copied and I do not understand why is this happening
Bo (.
·
·
Hey — to fix this, try switching to Lookup Multiple Rows instead of Lookup Single Row. That way, it checks across all rows for matches, not just the first one it finds. For the issue with Write to Other Table, if the row was deleted after being written, it won’t show up anymore. You’ll need to create a new source and send the data again to a fresh table. If the value you’re trying to look up (like “Open Job Personalization”) was added later, using Lookup Multiple Rows will make sure it’s picked up correctly. Let me know if you have more questions.
Irina C.
·
·
Bo (. unfortunately the solution you provided does not work - I introduced Lookup Multiple Rows but somehow the information is not getting populated in any ways so I do not understand how can I get it done. All the rest is being "transfered from one table to another, Open Job personalization is not, Can you please investigate your self? I took the example of CXAI ROW number six in this Table: https://app.clay.com/workspaces/558381/workbooks/wb_2fmTBMbNuzY6/tables/t_rujvfAh5FBD2/views/gv_t9WQjtfHKJgw - I am writing the ROW in the People one: executing the Function Write HIRING Manager and in the Table: https://app.clay.com/workspaces/558381/workbooks/wb_2fmTBMbNuzY6/tables/t_0swimqtXCc8KqVoGC3C/views/gv_0swimqufzdqevPi3x7Y you see the ROW with all the data populated without the Open Job personalizatio even if I am using Lookup Multiple Rows instead of Single.
Bo (.
·
·
Hey, I see what you’re referring to. Just a heads-up—Lookups don’t automatically update like a sync. If the source column value changes, you’ll need to re-run the Lookup to pull in the updated data. Let me know if you have more questions.
(84 kB)