Limitations on Linking Multiple Tables and Data Reflection in Table Edits

hey team, if I use "Look up multiple rows" to match data between different tables, how many tables can I link at max before it breaks? Also, if I add a column in table one, will the edits reflect in table two and will I be able to see the new data in table 2?

6 comments

Channeled
APP
·
·
There is no explicit limit mentioned for the number of tables you can link using "Look up multiple rows." The feature is designed to handle "one-to-many" data relationships, such as one company having many contacts.Regarding your second question, when you add new data to your source table (table one), you'll need to manually rerun the lookup in your destination table (table two) to see the updated information. This process will pull the new data into your destination table, ensuring you have the most current information. Sources: Enrich People (Waterfalls) [Automated Outbound] - Clay University Write to Table [Clay 101] - Clay University
Andi D.
·
·
Is there a way to automate it? Can it be done via N8N or Make?
Channeled
APP
·
·
Yes, you can automate updates between tables using Clay's built-in auto-update feature. When enabled, auto-update will automatically run all columns whenever rows are added or edited in your table.To enable auto-update: 1. Click the Auto-update icon at the bottom right of your table 2. Click "Turn on Table" and choose to either "Continue without running" or "Update cells"This native automation eliminates the need for external tools like N8N or Make for basic table updates. The feature ensures your tables remain current by automatically running all configured operations when data changes. Sources: Auto-update and Auto-dedupe Table Configuring your table settings | Documentation | Clay University
Andi D.
·
·
well i meant for updates in table 1 to be automatically shown in table 2
Channeled
APP
·
·
You can use the Write to Table integration with auto-update enabled to automatically sync data between tables. Here's how: 1. Set up Write to Table integration: • Get your Clay API key • Select your destination table (table 2) • Map the columns from your source table (table 1) to the destination table 2. Enable auto-update in the run settings to automatically enrich new rows when they're added.This will ensure that when you make changes in table 1, the data will automatically update in table 2 through the Write to Table integration. Source: Write to table integration overview | Documentation | Clay University
Channeled
APP
·
·
Hi Andi D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Limitations on Linking Multiple Tables and Data Reflection in Table Edits | Clay