Integration of form with Zapier leads to blank lines

  • nadlancapitalgroup
    Asked on January 22, 2021 at 10:01 AM
    The data from JotForm is not taken - only the date - the rest of the fields are not fetched. Its all blank! I am talking about the initial data from JotForm - before even mapping the fields - its all blank - so the new row in the spreadsheet has only the date and nothing else - see screenshot: https://gyazo.com/f89b0cfcff9702255d73e1bb23b3be27You can see that I get the form ID< IP, submission date: https://gyazo.com/c7f2172dc57fa0029ce1c57bfd885e56But then all of the fields are blank: https://gyazo.com/c6d4a760ec0382988770b9c5f2fbb863


    This is the form:

    Nad lan Cap ital Gr oup Online Pre-Qualifying Form


    Link:

    https://www.jotform.com/build/203025266907453



    Jotform Thread 2843100 Screenshot
  • Sam_G
    Replied on January 22, 2021 at 10:56 AM

    Hi Nadlancapitalgroup,

    This form is not currently integrated into Zapier and what application are you trying to connect to your form via Zapier?

    Can you please share the error shown in Zapier regarding the issue? 

    In the meantime, please try to re-integrate the form to Zapier let's see if that would make any difference. 

    Thank you. Looking forward to your response.


  • nadlancapitalgroup
    Replied on January 23, 2021 at 2:35 PM

    Hi

    All I am doing is sending these lines to Google Spreadsheet - very simple

    I just tried to connect again and did a test and all fields coming to Zapier are blank - its a huge issue

    https://gyazo.com/c83c758269bebd7584b80014c7774e93

    Its not a matter of what I integrate it to - there is no data coming from JotForm to Zapier so anything I will try to integrate to wont work - its all blank - see the screenshots I sent

    You can see here everything comes blank:

    7ec161565fb674e0eb3bd383f85058af Screenshot 10

    https://gyazo.com/7ec161565fb674e0eb3bd383f85058af

    Here is the authorization:

    ebd193d69280cbf614cd524b15d5ec7a Screenshot 21

    https://gyazo.com/ebd193d69280cbf614cd524b15d5ec7a

    Information about the Zap:

    221239bf8b7649bc4d9d2821219992c7 Screenshot 32

    https://gyazo.com/221239bf8b7649bc4d9d2821219992c7

    I reconnected that connection just now again

    Still not working


    I tried 4 different connections:

    74e6ac5eb62651c9a1d8674e2db20cb3 Screenshot 43

    https://gyazo.com/74e6ac5eb62651c9a1d8674e2db20cb3


    This is a very simple basic integration and it doesnt work

    Please look into it ASAP as its critical to our business





  • Carlos_C
    Replied on January 23, 2021 at 11:37 PM

    Hello There!

    I already reset the API limits and clear the cache in your account.

    Please try again and let us know if the issue persists.

    Please feel free to reach out if you have other questions or need some more help. I will be happy to help!

  • nadlancapitalgroup
    Replied on January 28, 2021 at 3:17 PM

    Hi Carlos

    Unfortunately nothing changed - its exactly the same - we are getting only the creation date and nothing else - i just did another test:

    ccb90d263ba3b7c6373a7cc3092481c6 Screenshot 10

    https://gyazo.com/ccb90d263ba3b7c6373a7cc3092481c6


    This is a MAJOR issue for us - we must get this data to the spreadsheet


    Please fix asap



  • Carlos_C
    Replied on January 28, 2021 at 6:51 PM

    Hello,

    Could you please try to complete the setup with Zapier, the test Trigger is going to show just one result.

    I try to reproduce the issue but is working in a test (customer) account:

    1611877791 60134d9f79789 reeex1 Screenshot 10


    Please complete the setup and let us know if the integration is just showing one or a few fields, and sent us a screenshot of the spreadsheet.

    Please feel free to reach out if you have other questions or need some more help. I will be happy to help!

  • nadlancapitalgroup
    Replied on January 28, 2021 at 7:52 PM

    i dont understand

    i already tried that 50 times

    it doesnt work

    it comes empty


  • nadlancapitalgroup
    Replied on January 28, 2021 at 7:55 PM

    It works with other forms:

    https://gyazo.com/7cc8862c2876fb0eaba511f02d520878


    It DOESNT work with my form:

    https://gyazo.com/65b6ddf81bab012fb17379a364735ba9


    I need this fixed ASAP

  • Carlos_C
    Replied on January 28, 2021 at 11:27 PM

    Hi,

    I already create a clone of your form, the situation is that Zaiper is getting the data from Jotform, because in the test trigger is showing the date from the last submission.

    In this particular case the recommendation is to contact Zapier support https://zapier.com/help, so they can check the correct setup or if there is an issue posing the date in the Google Spreadsheets

    This is the setup that is working but, is not showing the headers in the correct format.

    1611893269 60138a150ccd3  Screenshot 10

  • 12345mail
    Replied on January 29, 2021 at 2:07 AM

    I dunt see any data on the test trigger - i sent you a screenshot, so it got nothing to do with the spreadsheet - there is no data.

    I have already contacted them - they said jotform doesn't send the data









  • 12345mail
    Replied on January 29, 2021 at 2:09 AM

    I honestly dont see that you are helping at all - i am showing you video no data with my form so fix that form. It doesn't help me another form works!

    Can you please just fix it? Your integration dunt work and i tried that 50 times





  • nadlancapitalgroup
    Replied on January 29, 2021 at 2:27 AM

    I dont see where you cloned that form:

    https://gyazo.com/4d92ab48988d58e1fa60913a945f5eea

    I dont see much data in your post as well - most blank:

    48c1044f0dc5ce3e62dccf7a8c9c1c2a Screenshot 10

    https://gyazo.com/48c1044f0dc5ce3e62dccf7a8c9c1c2a

  • nadlancapitalgroup
    Replied on January 29, 2021 at 2:29 AM

    The issue got nothing to do with connectin to spreadsheet - the data is not there!

    I explained that 5 times and you refuse to understand and to help!

    This is not relevant - there is no data!!!

    Why dont you check my own form ???

    This support is really frustrating - i want your manager or someone that knows something

    8a97bde39789b35755dd60e306f16bdf Screenshot 10

    https://gyazo.com/8a97bde39789b35755dd60e306f16bdf

  • nadlancapitalgroup
    Replied on January 29, 2021 at 2:38 AM

    Is anyone actually going to help and not just state the obvious?

    I know how to integrate to Zapier - it simply doesnt work !!!


    ALL DATA BLANK !

  • 12345mail
    Replied on January 29, 2021 at 3:22 AM

    I sent you a video showing no data is coming


  • Sam_G
    Replied on January 29, 2021 at 4:50 AM

    Hi Nadlancapitalgroup,

    We're very sorry for the inconvenience.

    I have cloned and tested your form then integrated it with Zapier,  it seems submission data is going to Zapier.
    1611913569 6013d961249ec  Screenshot 10Can you try cloning your form and running the Zap again?

    Let us know if the issue persists.