Skip to main content

Hello, When trying to create a new row in Excel from a source (Excel or another database) I only have the option to add the ID field. I do not see an option where I can map additional fields for the new row in SQL. How do I add all the fields I need from the source into my SQL table?

Hi ​@USPADMIN 

Help us have more info by posting screenshots showing how your Zap step is configured in EDIT mode with the field mappings visible.

 

Help links for using Excel in Zaps: https://zapier.com/apps/excel/integrations#help


Thanks for the response. Thats what I do not understand. I can only map ID field. I do not know how to map other fields, I do not have the option.

 


I can see all of the fields in Excel but I can only map the ID field for SQL. I do not see how to map the other fields. Clicking on the Plus just adds (concatenates) the additional excel field to the ID field in SQL

 


I think, I figured it out. I did not have a primary key set on the SQL table, I was treating it as a FK. Once I added that, the additional fields appeared so they could be mapped.


Wow! Thank you for confirming that your resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.