Is it possible to "Write to Other Table" (Clay table) in a way that writes 10 fields of data into 1 column of the other table? So it stacks up, like eg Apollo does when it finds 4 people and all the mappable data is contained in that 1 column/cell? Hopefully that makes enough sense, if not ask me and I'll do a Loom video!
Hey,
Sorry for the delay! That’s definitely feasible, though it requires a bit of a workaround. You’ll need to create an AI formula column to format the JSON with the fields and values in a single field, like this:
[{"name":"John"},{"name":"Jane"},{"name":"Doe"},{"name":"Smith"}]
Then, in the Write to Other integration, instead of mapping the array, use JSON.parse(COLUMN), and the fields should appear properly:
Feel free to share your table if you don't get it setup, happy to assist!
Hey Daniel, I'm not seeing an error on my end when I add the write to other table. Curious if you could record a video of what you're seeing?
.png){kind=logo}
