Using JotForm with Integromat

  • DragonsVolleyball
    Asked on January 4, 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

  • AshtonP
    Replied on January 5, 2020 at 12:47 AM

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

  • AshtonP
    Replied on January 5, 2020 at 1: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 Screenshot 10

    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.

  • DragonsVolleyball
    Replied on January 5, 2020 at 2: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).

  • DragonsVolleyball
    Replied on January 5, 2020 at 7:55 PM

    Hi Ashton,

    Some screenshots below as requested.


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

    Using JotForm with Integromat Image 10

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

    Using JotForm with Integromat Image 21

    The next two images show what is inside each operation:

    Using JotForm with Integromat Image 32

    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.

    Using JotForm with Integromat Image 43

    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.

    Using JotForm with Integromat Image 54Using JotForm with Integromat Image 65


    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.

    Using JotForm with Integromat Image 76Using JotForm with Integromat Image 87


    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

  • Jed_C
    Replied on January 5, 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 Screenshot 10

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

    Let us know if you have any questions.

  • DragonsVolleyball
    Replied on January 5, 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?

  • jherwin
    Replied on January 5, 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.

  • DragonsVolleyball
    Replied on January 7, 2020 at 1: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.

  • Jed_C
    Replied on January 7, 2020 at 2: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 Screenshot 10

  • DragonsVolleyball
    Replied on January 7, 2020 at 6: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.

  • DragonsVolleyball
    Replied on January 9, 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?

  • AshtonP
    Replied on January 9, 2020 at 1:42 AM

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

  • AshtonP
    Replied on January 9, 2020 at 2: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?

    Using JotForm with Integromat Image 10

    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:

    Using JotForm with Integromat Image 21

    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.