Can I access the submission ID in Monday.com integration?

  • Profile Image
    diurnate
    Asked on January 26, 2020 at 01:44 PM

    I have an integration that pushes form data to another service (Monday.com). I'd like that interface to be able to link directly back to the raw data in Jotform using a unique identifier. 

    There doesn't seem to be any submission identifier in the integration builder where you map Jotform to Monday fields. Is this a limitation of the Monday integration, or integrations in general? Is there any workaround?

    Nate

  • Profile Image
    jonathan
    Answered on January 26, 2020 at 03:19 PM

    Unfortunately no. Because the Submission ID# is generated only on post submission, it is not an available field on the form during design.

    Since the Submission ID# field is not available on the form, you will not be able to map the field during the field mapping steps in the integration configuration.

    The workaround you can do is to use a widget/field on the form that can be use as the Submission ID#. 

    Check on the Random Value Generator widget.

    You can use this to add the unique number/ID# on the form on submission. Because it is on the form, you can use the field to map it on your Monday.com field in the field mapping steps.

    I hope this help. Let us know if you need further assistance.


  • Profile Image
    diurnate
    Answered on January 26, 2020 at 05:01 PM

    Ok, but how would I use that random ID to link back to the form submission? Is there a way embed that ID in a search query? I don't even see a way to search a specific field in the submission browser to find the submission. So I could use it in a data extraction process only.

    This seems odd as the ID is available to the "Thank You Page" as {id} so that you can embed it a create a link back to the submission. I guess this is a feature request, but it would be really great to access the submission data - submission date and submission ID - in the integrations.

    \ Nate

  • Profile Image
    jonathan
    Answered on January 26, 2020 at 06:17 PM

    Ok, but how would I use that random ID to link back to the form submission? Is there a way embed that ID in a search query? I don't even see a way to search a specific field in the submission browser to find the submission.

    You can use the random ID to do search query in the form Submission page.

    Guide : How to Search a Submission from the Submissions Page

    If this is not what you meant, please elaborate further on how you were doing the search query.

    ---

    This seems odd as the ID is available to the "Thank You Page" as {id} so that you can embed it a create a link back to the submission. I guess this is a feature request, but it would be really great to access the submission data - submission date and submission ID - in the integrations.


    The Submission ID# is available in the Thank You Page because it is in post submission state already (the Thank You Message appears after submitting the form).

    To simplify, in the integration field mapping steps, you can only use those fields that are available in the form while the user is using the form.

    If you notice, the Submission ID# is not available in the published form(or the user could not see or fill it in). 

    Please let me know if this is still not clear.

    I will create a separate thread to submit a feature request ticket base on this.


  • Profile Image
    diurnate
    Answered on January 26, 2020 at 07:44 PM

    Ugh. So thats mostly workable as a workaround ... however the integration doesn't recognize the Random ID widget as a mappable data type. So it doesn't work. I also tried creating a condition to copy the widget contents to a text field, but it looks like they aren't recognized for Update conditions.

    Sounds like this is squarely in a feature request to make it possible.

    \ Nate

  • Profile Image
    JohnRex
    Answered on January 27, 2020 at 01:17 AM

    Hello Nate - I just tried creating a condition to copy a RANDOM VALUE GENERATOR widget's value to a SHORT TEXT ENTRY field and it works.

    Here's the condition I used:

    15801057362132984.png

    Here's the demo form: https://form.jotform.me/91928338173465 

    So, as soon as the said widget generates a new random value it means it is on "FILLED" state. It will then trigger copying the said value to the Short Entry Text field which you can map to Monday.com.