Hi @dustin.s 

Map variables form Jotform to Clay, then from Clay to Salesforce.

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode.

Hi Troy, thank you for the response.

For example, I have a field in my Clay table called “Description” that is not on the Jotform - it is data that clay uses webscraping to find. 

When trying to link that description column to the description field in SalesForce, that option does not show up. I am only shown the fields that came in through the Jotform.

@dustin.s 

Looks like Clay returns the internal field IDs instead of the friendly field names.

Try searching for the expected Description value to help you narrow the list of variables to map.

Help link for using Clay in Zaps: https://help.zapier.com/hc/en-us/articles/24937325149965-How-to-get-started-with-Clay-on-Zapier#additional-authentication-instructions

Hi Troy,

I have tried that, but unfortunately the field is not there. I’ve tried refreshing but does not work.

I’ve got about 30 columns in my Clay table, and it is only showing me the columns that came directly from Jotform.

@dustin.s 

Some apps only return columns that have values to minimize the data payload.

Try adding this Zap action: Clay - Find Row in Table

See if that returns the desired column.

Hi Troy, 

Those columns show up in the configuration stage of that action. However, it still does not allow me to select one of these enriched columns when linking them to SalesForce lead fields.

I’m wondering if the enriched columns for Clay are being considered “formulas” and that is why I cannot send that data to SF?

@dustin.s 

The documentation for using Clay in Zaps says Custom Fields are not supported, so perhaps that is why.

Perhaps try reaching out to Clay Support for help with their Zap app integration.

Hi @dustin.s!

I did some checking on our side and couldn’t see any mention of enriched column fields not being supported. But I did see a mention that “When adding a record to a table, fields that are Actions or Formulas will not be included.” So if it does consider enriched fields to be the same as formulas then you could well be right.

I’d suggest also contacting our Support team to submit a new feature request for enriched fields to be supported. You can do that here: https://zapier.com/app/get-help. This will help us to get it on the radar of the Clay app’s developers, and allow us to start tracking interest from other customers that would like this functionality too.

Please do keep us updated on how you get on with Clay’s Support team as well. Would love to hear whether they know of any workarounds!