I have an issue with connecting the form with Excel

Im using the ZAP to connect my form , but I cant map the excel sheet with JotForm fields , how can you help me?

1. New Submission in Jotform - as Triger
2. Trigger event - New Submission
3. Add Row in Microsoft Excel - as Action
4. Folder - root
5. Spreadsheet - choose one excel sheet from MS
6. Col$a - here is the problem , cant assign the Jotform fields to MS excel

Im getting this message ' Test was successful!

We’ll use this as a sample for setting up the rest of your Zap. '

id :2

row: 2

COL$A:

Hey there,

First of all, please keep in mind that you can integrate Google Sheets directly to your form

Here's an article on that

https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets/

Regarding Zapier,

If you still want to use that feature,

Can you please remove and re-integrate Zapier?

Here's an article on how to correctly integrate Zapier with Jotform

https://zapier.com/apps/jotform/help

Please let us know if you need any further assistance,

Thank you

Hi, i have only issue in mapping the excel columns with the Jotform, how can I fix it?

hey, apologies,

I haven't noticed that you're referring to Microsoft excel and not Google Sheets.

Please have a look at the following article

Please keep in mind that you can Integrate Excel Directly to your form

https://www.jotform.com/integrations/microsoft-excel

Also, please have a look at the following article on how to integrate

https://www.jotform.com/blog/zapier-excel-form-connection/

Please let us know if you need any further assistance,

Thank you

sddsdsds

I need to have the same as above, is that complex to explain?

Greetings.

Can you please let us know have you created your Zap from Jotform? If you did, can you please try to remove the integration from the form builder, and create a new Zap directly from your Zapier account?

If you are still having problems, please let us know.

Thank you for your cooperation.

I did both ways, with no luck.

Can you please send us a screenshot of your Zapier configuration? Please click here to see how to share images with us.

Thank you for your cooperation.

a

Hi,

I have tested the Zap Integration between JotForm and Excel, and I was able to set up the integration successfully.

Please note that when you link Excel fields in JotForm's, a list of available fields will be shown in the dropdown:

Could you please confirm if this dropdown is showing on your end?

We look forward to your response.

Yes, shown . but what shall I select them all in the Col$a?

I need to have the excel as below :

Date First Name Last Name

----- ------------ ------------

May we know what field COL$A is in your excel?

Is it a column or calculation column?

Have you tried leaving the column COL$A blank?

You can try selecting all three options.

Looking forward to your response.