Dropdown Issues: No Tables Appearing in Column Mapping

Trying to lookup row from another table. in the column mapping section "table to search" no tables appear in the dropdown so I cannot do anything. This has happened a couple of times. Any fix or work around?

8 comments

Clay
APP
·
·
If no tables appear in the "Table to Search" dropdown for your lookup column, try these solutions: Force Rerun the Column: Click the column header and select "Force Rerun Column" to reset it. Use Force Run: Try using the Force Run option in the table settings, which may take some time depending on your table size. Refresh Column Data: If you're not seeing newly created tables, you may need to re-run or force run the column to see updated values. If the issue persists after trying these steps, you can recreate the column by deleting it and creating a fresh one.
Ross R.
·
·
no - I am creating a new column so I cannot force anything as I need the table to seach in the first place.
Hunain F.
·
·
Hi - Ross R. If no tables show up in the "Table to Search" dropdown when using “Lookup Row from Another Table” do this: Refresh your browser. Often it's a temporary UI bug a full refresh usually makes the tables appear. Make sure both tables are saved. If the table you want to search has unsaved changes, it won’t appear. Click “Save” on both tables first. Reopen the column mapping step. After saving and refreshing, go back into the “Lookup Row” step the table should now be visible.
Ross R.
·
·
Hi this isn't working. I've shut down, restarted, refreshed browser and tried different tables.
Clay
APP
·
·
Hi Ross = I am so sorry that you are encountering this issue, I am happy to dig in here.
Clay
APP
·
·
Hey Ross (and sorry for the typo above!) I'm looking at your current personal workspace, and I only see one table which could be why the lookup doesn't work if there isn't another table to view. Are you seeing this issue in a different workspace? It would be really helpful to send the table link. Thank you!
Ross R.
·
·
I have loads of tables. This is a work critical job I am doing. Still not working https://app.clay.com/workspaces/467449/workbooks/wb_0t0322d9iyUsndyAVuJ/tables/t_0t0322o2bT3XTmEuk7r/views/gv_0szrzrkuz2DXPeAPPgT
Clay
APP
·
·
Hey Ross! I replaced your Clay API key, and this fixed the table to search issue. Please let me know if this works, or if it still persists. Thank you!

Dropdown Issues: No Tables Appearing in Column Mapping | Clay