Hey Clay team, I have some rows in my main table that are checked off based on criteria….how do I send all of the data from these rows into a new table to organize the data without having to use filters on the main table constantly?
You can use our "write to table" feature to automatically transfer data from rows that meet specific criteria to another table.
Here's how to set it up:
1. Get your Clay API key (found in your account settings)
2. Add the "write to table" action to your main table
3. Select the destination table where you want to send the data
4. Skip the list selection by entering "/"
5. Map the columns from your source table to the destination table
6. In the "Only run if" section, set your criteria conditions to control which rows get transferred
7. Enable "Auto-update" if you want new qualifying rows to be automatically sent to the destination table
This way, you'll have a separate table with just the data that meets your criteria, eliminating the need for constant filtering.