I have an issue with connecting the form with Excel

  • Profile Image
    kodeh
    Asked on January 09, 2022 at 09:58 AM

    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:



    Screenshot
  • Profile Image
    Amos_W
    Answered on January 09, 2022 at 10:17 AM

    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

  • Profile Image
    kodeh
    Answered on January 09, 2022 at 10:21 AM

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

  • Profile Image
    Amos_W
    Answered on January 09, 2022 at 10:45 AM

    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

  • Profile Image
    kodeh
    Answered on January 10, 2022 at 01:18 AM






    sddsdsds1641795473_61dbcf9191989_

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



  • Profile Image
    Bojan_J
    Answered on January 10, 2022 at 04:44 AM

    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.

  • Profile Image
    kodeh
    Answered on January 10, 2022 at 04:49 AM

    I did both ways, with no luck.

  • Profile Image
    Bojan_J
    Answered on January 10, 2022 at 06:01 AM

    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.

  • Profile Image
    kodeh
    Answered on January 10, 2022 at 06:13 AM

    1641813183_61dc14bf01d6e_step-4.png


    1641813183_61dc14bf0f4ea_step-5.png1641813182_61dc14bec6537_step-6.png1641813182_61dc14beab1e0_step-1.png1641813182_61dc14beae458_step-2.png

    a1641813182_61dc14beaccba_step-3.png

  • Profile Image
    kodeh
    Answered on January 10, 2022 at 06:15 AM

    1641813300_61dc1534be1a7_

  • Profile Image
    Jovanne_A
    Answered on January 10, 2022 at 07:41 AM

    Hi,

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

    1641818205_61dc285d8b215_

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

    1641818424_61dc2938192c0_

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

    We look forward to your response.

  • Profile Image
    kodeh
    Answered on January 10, 2022 at 07:51 AM

    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

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


    1641818933_61dc2b35f04f7_

  • Profile Image
    Richie_P
    Answered on January 10, 2022 at 08:52 AM

    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.