Troubleshooting Write to Other Table Errors in Simple Formulas

Is there a place for really dumb questions 👀 ... I'm having issues with Write to Other table, in that it keeps running an error, it's such a simple formula normally and I don't get why I can't get it to work

21 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Muhammad S.
·
·
No question is dumb and you can ask your questions here.
Matt S.
·
·
I have a table here, and I want to have the "Person LinkedIn URL" automatically populate in the new customer table, in excel I would do =unique(Apollo List: A:A), and it would link the two data columns
Matt S.
·
·
I've tried, but i keep getting an erorr
Muhammad S.
·
·
In this case you have to lookup record from custom table. Go to custom table Add lookup single row enrichment Select the table as "Apollo list export" Select the lookup value (must be present in both tables) Run the column
Matt S.
·
·
but for that you would need to have the values present in both the Apollo List and Custom Table correct?
Matt S.
·
·
if i added another item to the "Apollo List" i would also have to add the value to the Custom Table, it wouldn't get added automatically
Muhammad S.
·
·
Yes, it wont be added to other table automatically. Then you have to rethink the design of these tables and see what would work best in your usecase.
Matt S.
·
·
That seems a bit strange that you can't have two standard columns linked
Matt S.
·
·
/ a column populated based on new data
Muhammad S.
·
·
it is possible but you have to explore another approach
Muhammad S.
·
·
try write to other table integration.
Matt S.
·
·
already tried that as well
Muhammad S.
·
·
It errored out
Matt S.
·
·
exactly
Muhammad S.
·
·
Can you open the write to other table column up and show the screenshot to figure out what is causing the error?
Matt S.
·
·
https://app.clay.com/shared-table/share_ScAgVGHXBxSY
Bruno R.
·
·
Hi Matthew, thanks for reaching out. Do you mind sending the link to the table so we can take a look? This one is a shared link and I can't find this table in your workspace. I'll be happy to take a look at what's happening here! https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1729263600&signature=e583544faf500687f42ca75e915750917de02743d071d07702e5bb89a764b592&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCL%2BAJQQ2BKsam%2FhVPsieQ%3D%3D%0A
Matt S.
·
·
https://app.clay.com/workspaces/353442/workbooks/wb_beVvyJqnCaYj/tables/t_nUem5kFgvfr7/views/gv_ufgAeXdJ6YwD
Bruno R.
·
·
Hi Matthew, was able to set this up for you here: https://www.loom.com/share/2460143805a34db095639b85aa46b8ab?sid=8bbab7bc-0cc6-409f-8b85-2ee6614bca01 The issue seems to have been related to how you linked you API key, you can see my troubleshooting process in the video and the column is now running as expected. I hope this was helpful. If there's anything else I can assist you with, please let me know!
Channeled
APP
·
·
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.

Troubleshooting Write to Other Table Errors in Simple Formulas | Clay