Hi, I am trying to use the Lookup Single Row in Other Table operator but the setup inputs where I expect to select the table, column and key to search for only shows me Table to Search and misses any dropdown possibility. Also if I fill in the table ID nothing happens and it eventually runs an error. What am I expected to fill in there?
For the "Lookup Single Row in Other Table" operator, you need to enter the table ID in the "Table to Search" field. The complete inputs are: ** Table to Search (enter the table ID) ** Target Column ** Filter Operator ** Row Value Once you enter a valid table ID, the additional fields should become available for configuration. If you're still experiencing issues after entering the table ID, please request human assistance by clicking "Talk to a person" for further troubleshooting.
Where do I find the table ID of a table?
You can find the table ID in the URL when you open your table. The table ID appears after 'tables/' in the URL: https://app.clay.com/workspaces/WORKSPACE-ID/tables/TABLE-ID-HERE/... Simply copy the ID that comes after 'tables/' in your browser's address bar.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.