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

Can I write to a Clay table but specifically write values to existing...

Siddhant Bhansali (Certified Clay Expert)

·

Can I write to a Clay table but specifically write values to existing rows, ie find the matching row and then update the column mentioned with the value specified. In the attached, I know the Company HQ country in another table.

Loading attachments

Can I write to a Clay table but specifically write values to existing... | Clay

7 comments

· Sorted by Oldest

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 😉
Siddhant Bhansali (Certified Clay Expert)
·
No action needed: https://app.clay.com/workspaces/39601/tables/t_A2tGrv4ikYlJ/views/gv_E40wRhNY2518
Clay Team
APP
·
Hey Siddhant! To clarify, you're trying to append the data, right? The best way to do this is to use a lookup record integration since it would find the matching value in a row.Write to the table will always create a new record in your tables and can't find any matches. Let me know if you have additional questions!
Siddhant Bhansali (Certified Clay Expert)
·
Well, I want to "update" the field "Company HQ country" in table 2, from columns in table 1. The rows already exist in table 2 with a lot of existing content.
Clay Team
APP
·
Got it, yep. Lookup is the way to append/update that information when there's a match for let's say a domain or LI URL. I'll drop the video about the integration in case it helps- https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=0194f8b1-d773-4aaf-a40b-dbb34c279656
Siddhant Bhansali (Certified Clay Expert)
·
·
Hi Arturo (Clay) - thanks for this, but am actually looking for a way to "write" to another table, but instead of writing an entirely new row, I want to just write one column's value in an existing row. Does that make sense? Sort of like an UPDATE statement in SQL... :)
Arturo (Clay)
·
·
It makes sense, and the Lookup Record would actually do that for you since appending data would be synonymous with the action you mentioned. Let me know if setting up an example of that would help determine if that's what you're looking for. Write to table only creates new rows and cannot update existing ones from another table.