Using Jotform with Integromat

  • Profile Image
    DragonsVolleyball
    Asked on January 04, 2020 at 11:16 PM

    Hi,

    I'm trying to use Jotform with Integromat, specifically using the trigger 'Watch for Submissions', which then immediately calls the operation 'Get Form Submissions'. The intention is to process a form submission each time one arrives.

    This seems to work, except that the latest form submission does not get returned by 'Get Form Submissions'. I suspect that the trigger is occurring before the submission is ready to be returned.

    I found (in one case at least) that by adding a 30s delay that the submission was then returned as it should be.

    I'm hoping this is something you can look into? The whole point of the trigger is to indicate that the submission is already ready.

    Regards,

    Michael

  • Profile Image
    AshtonP
    Answered on January 05, 2020 at 12:47 AM

     Let me run some tests and get back to you with an update soon.

  • Profile Image
    AshtonP
    Answered on January 05, 2020 at 01:46 AM

    I have tried to replicate it at my end but I am a bit unsure how you have configured your "Get Form Submissions". I have tried the test submission but was not able to replicate the exact case you are referring to. If you could please provide us more details or the screenshot of your configuration window it would be very helpful for us to understand the scenario.

    This is my replication screencast:

    1578206597Webhooks_Jotform.gif

    Please refer this guide in case if it helps:

    https://support.integromat.com/hc/en-us/articles/360014139793-JotForm

    We will be waiting for your response.

  • Profile Image
    DragonsVolleyball
    Answered on January 05, 2020 at 02:23 AM

    Thanks Ashton, I'm getting pretty tired now so will look at your screencast in more detail tomorrow and work on some screenshots for you then.

    Maybe it'll help to tell you that I have used the 'Watch for Submissions' trigger rather than a 'Custom webhook' to kick off the scenario.

    I have noticed that I don't get created_at or updated_at fields returned from that trigger, so instead have been trying to use either an empty filter field or {"id:eq":<submission ID>}.

    I note the documentation doesn't mention use of an equals operator, but it does seem to work (I think).

  • Profile Image
    DragonsVolleyball
    Answered on January 05, 2020 at 07:55 PM

    Hi Ashton,

    Some screenshots below as requested.


    First, the very simple Jotform I'm using for testing:

    15782714281.png

    This is an overview of the scenario - note it has a different 'trigger' to you.

    15782714382.png

    The next two images show what is inside each operation:

    15782714473.png

    Previously I was trying to use a filter with value {"id:eq":<submission ID>}, but even if that isn't working, it isn't the cause of this problem, as problem occurs with no filter value.

    15782714554.png

    I did two tests. For each test I hit 'Run Once', where first operation waits for a submission to occur. I then filled in my basic Jotform and hit submit button, and looked at results shown from each operation.

    First test results. Note that 'ID' in second pic is not the same as 'Submission ID' in first pic. The 'Answers' field is empty.

    15782714665.png15782714746.png


    Second test results. Again 'ID' in second pic is not the same as 'Submission ID' in first pic.However, 'ID' for second test IS the same as 'Submission ID' in first test.

    15782714817.png15782714898.png


    Adding a 30s delay between the two operations seems to fix this.

    (This does not allow me to get just the one submission, but one thing at a time)

    Ultimately what I'm trying to achieve here is to create an invoice in Xero for each Jotform submission as it arrives. Obviously that requires me to have no double ups to avoid duplicate invoices.

    Hope that helps replicate it!

    Thanks,

    Michael

  • Profile Image
    Jed_C
    Answered on January 05, 2020 at 10:38 PM

    The answers output for "Get form submissions" is not blank on my end. You'll just have to click the + sign to collapse and see the data.

    ex.

    1578281859integromat.gif

    Also, the submission ID in my screencast is the same. Kindly review my screencast.

    Let us know if you have any questions.

  • Profile Image
    DragonsVolleyball
    Answered on January 05, 2020 at 11:00 PM

    I agree it seems to be working in your screencast. Have you configured anything differently to me? Can you suggest any reasons why it may not be working in my case?

  • Profile Image
    jherwin
    Answered on January 05, 2020 at 11:52 PM

    Can you please redo the integration (disconnect and connect again) and see if that will fix the issue on your end?

    I will also ask my colleague @Jed_C if he did something to integration.

    Please give it a try and let us know how it goes.

  • Profile Image
    DragonsVolleyball
    Answered on January 07, 2020 at 01:22 AM

    After disconnecting and re-connecting, I now get the correct submission ID! Thank you!

    Now the second issue I was grappling with: How do I make sure I only process each submission once? As mentioned previously, my first attempt was to use a filter value {"id:eq":<submission ID>}, but is that the right way to do it? That is a guess, and wasn't mentioned as a possibility in the documentation.

  • Profile Image
    Jed_C
    Answered on January 07, 2020 at 02:41 AM

    That would depends on the filter you add. If you add the submissions ID filter twice, then it will be processed twice.

    Make sure that the connection is not using any duplicate filter.

    1578382879Integration Jotform _ Integrom

  • Profile Image
    DragonsVolleyball
    Answered on January 07, 2020 at 06:41 PM

    Oh, from the documentation I didn't realise you could just put the submission ID into the filter like that, thought it had to be something complex surrounded by {}. I'll give that a go later.

  • Profile Image
    DragonsVolleyball
    Answered on January 09, 2020 at 12:07 AM

    I tried adding 'Submission ID' as shown above, and I seem to be getting not just the latest submission but all previous ones in the response. Could you confirm that this method should work correctly please?

  • Profile Image
    AshtonP
    Answered on January 09, 2020 at 01:42 AM

    Give me some time to run some tests. I will get back to you with relevant information soon.

  • Profile Image
    AshtonP
    Answered on January 09, 2020 at 02:57 AM

    Hi!

    I have checked and configured the integration as per your requirement. As you have mentioned that you are getting all previous submissions too. Could you please confirm me are you referring to the bundles you see at the 'Get form submissions' or you are referring to something that is related to Xero?

    15785557301.png

    If you are referring to the submission bundles in 'Get form Submissions', then yes it is showing all the previous submission as it shows total submissions but the operation is performed on the single submission at a time which ultimately depends on what you have configured in Xero. 

    You can give it a try by configuring the next stage of integration in Integromat including Xero:

    15785562004.png

    So for every individual submission, you will be able to create separate invoices. I am unsure as I have not tested in Xero but I think this method should work perfectly if this is the case.

    I suggest you to please give a test submission integrating Xero and see if this works for you or not.

    I hope this helps. Let me know if you face any issue while integrating or executing any step. 

    Regards.