Clay Icon
Join the Community
02 Bugs

Troubleshooting Broken Connections in Database Tables

Avatar of Dave K.Dave K.
·
·

has anyone every experienced this? IT seems the connection to other tables is broken. The company column here was created by doing a find people search from the company table. But the connection is not there. I can't figure out how to get it back/connected to the company table.

7 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To reconnect the company column to the company table, you need to rerun the lookup in your people table. This process is simple: 1. Find the column in your people table that's linked to the company table. 2. Click on that column's header. 3. Select the option to rerun or refresh the lookup. This action will pull the updated company data into your people table, restoring the connection. If you've added new company data recently, this process will also ensure you have the most up-to-date information in your people table. If you're still experiencing issues after trying this, let me know, and we can explore other solutions.

  • Avatar of Dave K.
    Dave K.
    ·
    ·

    On the people table I choose three single rows and reran them. Nothing changed. Still no connection to the company table.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    If rerunning the lookup for selected rows didn't work, try these steps to restore the connection: 1. Force run the entire table: • Go to table settings • Use the Force Run option • (This may take some time depending on table size) 2. If the issue persists: • Delete the affected company column • Create a fresh column • Set up a new lookup using "Lookup Single Row in Other Table" • Select the company table as the "Table to Search" • Choose appropriate target column and filter options 3. If needed, use the "write to table" feature to update the data Remember to ensure auto-deduplication is activated in the company table. If these steps don't resolve the issue, please request human assistance for further support.

  • Avatar of Dave K.
    Dave K.
    ·
    ·

    didnt work

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey — sorry about this, it looks like there’s a bug affecting the connection. The best workaround is to use a lookup to pull the data from the company table back into this one. That should re-establish the connection and get everything working as expected. Let me know if you want help setting it up! We'll follow up here as soon as we know more!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Good news! Happy to report that we heard back from the team and this issue should be fixed. When doing a new search, it shouldn't be showing missing inputs anymore. If it does, please let us know. Thank you and thank you for your patience as we worked on it.