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?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
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
- Beginner
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.
- Beginner
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
- Beginner
- Answer
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.
+6- Zapier Staff
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.