Troubleshooting Zapier Column Update Issues in Clay

Travers N. · 2024-10-16 18:48:33.28683+00

I'm trying to update a column in Clay using a Zap but when I identify the row that needs to be updated, it's only giving me the option to update a single column, and it's not the column that I would like to update. What am I missing? Screenshot of Zap attached. Table . I'm trying to update the opp stage column if the Opp ID Clean field matches my Zap.

Troubleshooting Zapier Column Update Issues in Clay | Clay

14 comments

· Sorted by Oldest

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!
Tanvi R.
·
·
Hi Travers, thanks for reaching out! We're looking into this internally and will get back to you with an answer! Do you mind sending the link to the table you're looking to update so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1729113300&signature=11f48efc17effedb31007215fe387a799848db74f9aa6b92327057ffa85260b6&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCL9B5QV2BKsam%2FhVPtr1A%3D%3D%0A
Travers N.
·
·
The table is linked in my initial message. Thanks!
Tanvi R.
·
·
Hey Travers, I just got word from our team that this action can be buggy due to some changes we've made to the product on our end. The best method to troubleshoot right now is just delete this action and re-create it. Could you try doing this and see if you're able to successfully see the column? If not, let me know and I'll raise this issue with our engineers.
Channeled
APP
·
·
Hi Travers N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Travers N.
·
·
I'm still not able to see any columns other than the import report data to salesforce column.
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
LuisArturo
·
·
Hey there Travers thanks for reaching out, jumping in for Tanvi here, question the ID that you are using to Identify your Record which field did you use for this?
Travers N.
·
·
I am using Opp ID
Tanvi R.
·
·
Got it Travers, in that case it looks like there could be a bug preventing the rest of the columns from being pulled into Zapier. I've escalated this over to our engineering team and we'll let you know as soon as we know more!
Tanvi R.
·
·
Hey Travers, just wanted to touch base that our engineers are still looking into this issue and we will keep you updated once we know more
Bo (.
·
·
Hi Travers! We’re going to be adding this to the backlog/close bbecause it’s not a bug—it’s working as designed. The table you’re using has fields that are all formula-based, meaning each field pulls values from either the source or a lookup, including the Opp ID. When the Zapier integration was set up, formula fields were intentionally excluded, as these fields are meant to be populated automatically from other table columns. The need to overwrite a formula field was rarely seen. A ticket has been created to review this and we'll work on this soon. Let me know if you have any questions—I’m here to help!
Stefano
·
·
Hi Travers. The issue should have been solved now! Let me know if there is anything else I can help you with!
Channeled
APP
·
·
Hi Travers N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

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!
Tanvi R.
·
·
Hi Travers, thanks for reaching out! We're looking into this internally and will get back to you with an answer! Do you mind sending the link to the table you're looking to update so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1729113300&signature=11f48efc17effedb31007215fe387a799848db74f9aa6b92327057ffa85260b6&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCL9B5QV2BKsam%2FhVPtr1A%3D%3D%0A
Travers N.
·
·
The table is linked in my initial message. Thanks!
Tanvi R.
·
·
Hey Travers, I just got word from our team that this action can be buggy due to some changes we've made to the product on our end. The best method to troubleshoot right now is just delete this action and re-create it. Could you try doing this and see if you're able to successfully see the column? If not, let me know and I'll raise this issue with our engineers.
Channeled
APP
·
·
Hi Travers N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Travers N.
·
·
I'm still not able to see any columns other than the import report data to salesforce column.
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
LuisArturo
·
·
Hey there Travers thanks for reaching out, jumping in for Tanvi here, question the ID that you are using to Identify your Record which field did you use for this?
Travers N.
·
·
I am using Opp ID
Tanvi R.
·
·
Got it Travers, in that case it looks like there could be a bug preventing the rest of the columns from being pulled into Zapier. I've escalated this over to our engineering team and we'll let you know as soon as we know more!
Tanvi R.
·
·
Hey Travers, just wanted to touch base that our engineers are still looking into this issue and we will keep you updated once we know more
Bo (.
·
·
Hi Travers! We’re going to be adding this to the backlog/close bbecause it’s not a bug—it’s working as designed. The table you’re using has fields that are all formula-based, meaning each field pulls values from either the source or a lookup, including the Opp ID. When the Zapier integration was set up, formula fields were intentionally excluded, as these fields are meant to be populated automatically from other table columns. The need to overwrite a formula field was rarely seen. A ticket has been created to review this and we'll work on this soon. Let me know if you have any questions—I’m here to help!
Stefano
·
·
Hi Travers. The issue should have been solved now! Let me know if there is anything else I can help you with!
Channeled
APP
·
·
Hi Travers N.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: