What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    The Data Which Goes to Zapier is Incorrect

    Asked by Hardyc on March 06, 2016 at 11:20 PM

    I have setup a zapier task to accept data from my Jotform.  So of the data fields are not being sent and some are sending "N/A".

    The above capture shows the data that Zapier has said it has received.  fields__Approved By: I know has data - fields__Requester Email also has data.

    Above is Zapier also telling me that is received to fields with no value.  I know fields__Sub Total has a value in it.  When I send an email to myself with all these fields they have data in them.

     

    How is Zapier access the data? it seems to be missing some stuff.

    Page URL:
    https://form.jotform.co/60657836669877

    sent JotForm uploads png www
  • Profile Image
    JotForm Support

    Answered by mert on March 07, 2016 at 07:30 AM

    Hi there,

    On my tests, I didn't encounter the same results with you.

    Could you please re-integrate the Zapier? Please, follow the instructions from the link below:

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

     

    Alternatively, there is app called "" from our side which is doing the same thing. You can check it from the following link:

    http://apps.jotform.com/app/zapier_integration

     

    After applying the steps, please do let us know the results. If the problem insists, we can take further action to fix it.

     

    Thanks.

  • Profile Image

    Answered by Hardyc on March 07, 2016 at 02:17 PM

    I have tried the integration again.  Recreated the zap many times without success.  As I've highlighted the data that zapier believes it is getting is incomplete.  I don't know if this is the way zapier is collecting/calling the data or the way jotform is sending the data.

     

    the link you provided for the app on your side just redirects you to the zapier website, so its not a app on the jotform side.

     

    this is still occurring and is providing major issues.

  • Profile Image

    Answered by victor on March 07, 2016 at 04:33 PM

    Sorry for the inconvenience. I have just tested and successfully integrated zapier with jotform. I did not get any issues with the data when submitting forms. Can you please indicate what you are using Jotform and Zapier with. I used google spreadsheet and did not have any problems.

  • Profile Image

    Answered by Hardyc on March 07, 2016 at 06:27 PM

    Hi

    I'm integrating it with Salesforce (custom object so cant use the Jotform app).  It works fine on other forms.  Our account is silver, the form was created by someone else, but the integration with jotform from zapier uses a different account - I'm going to check if that makes a difference.  I'm also going to create a whole new form to see if it will send correct data.

  • Profile Image

    Answered by Hardyc on March 07, 2016 at 06:54 PM

    ip:
    119.15.97.138
    updated_at:
    2016-03-07 18:40:54
    fields__Number of Hours:
    60.8
    id:
    333120667831672603
    fields__First Date of Leave:
    24/02/2016
    fields__Number of Days:
    8
    new:
    0
    status:
    ACTIVE
    fields__You cannot use the same email address. Please use your Manager's Email.:
    N/A
    fields__Date you will return to work:
    07/03/2016
    form_id:
    60225945306857
    fields__AM eforms:
    Aspen Medical eforms
    flag:
    0
    fields__Submit:
    N/A
    fields__Leave Request:
    N/A
    fields__Upload files:
    N/A
    fields__Your Managers Name:
    David Tulloch
    fields__Worker:
    5 Day
    fields__Your Email Address:
    snylen@aspenmedical.com.au
    fields__Your Name:
    N/A
    fields__Leave Type:
    Sick
    created_at:
    2016-03-06 19:44:27
    fields__Your Managers Email:
    N/A

    It doesn't matter what I'm integrating with - I don't get that far.  The above is what Zapier has read.  There is data missing and replaced with N/A.  This is a problem...not sure who's -- but it is a problem.....you might have to ask Zapier how it is getting the data request.  The two fields Your name and Your Managers Email have data in them.  I will also upload the CSV file of this submission held in JotForm.

  • Profile Image
    JotForm Support

    Answered by Chriistian on March 08, 2016 at 03:05 AM

    We apologize for the inconvenience. Can you try clearing your form cache to see if that fixes the issue? Here's how: How to Clear your Form Cache

    However, from your screenshot of the csv, I can see that the data is being submitted correctly. This suggests that the issue might be with zapier integration to salesforce since the data appears as n/a in zapier. I would suggest you to open a ticket at Zapier about fields displaying as N/A.

    Do let us know how it goes.

  • Profile Image

    Answered by Hardyc on March 08, 2016 at 02:28 PM

    Thanks.

    I've opened a ticket at Zapier but also doing more testing.  I have created a brand new set of forms identical to the one having issues and it sends all data to Zapier correctly.  With both set of forms I'm passing parameters via URL posting between them.  With the one having issues we pass data from one to the next with URLENCODE, but with the one that works we don't use URLENCODE. Its then submit of the last form that triggers Zapier.  Still need to test it more but it looks like URLENCODE may have something to do with it.

    I'll let you know how I get on

  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 08, 2016 at 05:21 PM

    Sure, feel free to update us here with the results from your tests, since it is weird that it is not working when you add URLENCODE, and as we have tested the integration and seems to be working fine in our end. But let us know, we will be glad to assist you.