Unique Submission to check duplicate street address

  • Profile Image
    lbsenergyadmin
    Asked on January 23, 2021 at 10:34 PM

    Hi Guys,


    I was wondering if it is possible for me to cross check the address I have for new entries against the previously submitted ones for double ups (contains similar street names) to avoid double entry?


  • Profile Image
    JohnRex
    Answered on January 24, 2021 at 05:57 AM

    Unfortunately, the UNIQUE SUBMISSION feature will not work for an Address field because it consist of multiple text boxes.

    If you want to prevent double entry of the STREET ADDRESS, you would need to split the address field into several separate fields using Short Text fields:

    1611485834_600d528a8065b_

  • Profile Image
    luntiands
    Answered on January 24, 2021 at 08:53 AM

    Thanks for that... I found a way around it... I duplicated the street name by prepopulated field from another form.

    My question now... is the unique question only capable of restricting submission or can it just issue a warning so the user can just ignore it and submit anyway?

  • Profile Image
    luntiands
    Answered on January 24, 2021 at 09:05 AM

    By the way setting the unique question on this form seems to not work.

    https://form.jotform.com/210230392515848

  • Profile Image
    JohnRex
    Answered on January 24, 2021 at 10:48 AM

    As checked, you are using this field as the UNIQUE SUBMISSION checker:

    1611503212_600d966c08d2d_

    How do you populate this field? I can't see any condition that adds value to it.

    Unfortunately, we cannot strip the address field and pass only the street address into the said field, so I think this workaround won't work.

  • Profile Image
    luntiands
    Answered on January 30, 2021 at 07:27 PM

    Hi,


    How does the Unique Submission field work exactly? Does it check on the form where a certain word is placed in the field?

  • Profile Image
    JohnRex
    Answered on January 31, 2021 at 12:25 AM

    When the user clicks the SUBMIT button, the form will check if the word inside the Unique Submission field already exists in the submission. If it does, then an error will be shown preventing the form to be submitted.

    So for example, a word "TEST" already exists for the Unique Submission field, using "TEST" again into the same field when doing another submission will not be successful.

    That's how it works.

    And since an ADDRESS field is a multi-input field, it cannot be used as UNIQUE SUBMISSION field, thus I suggested to use separate fields for the STREET, CITY, COUNTRY, and ZIP using SHORT TEXT ENTRY fields only.

  • Profile Image
    luntiands
    Answered on January 31, 2021 at 11:12 PM

    HI John Rex,


    Can I open up this query on a new thread... I think it would be best if I explain my process on another form...

    Form 1 - https://form.jotform.com/210229043029849

    Form 2 - https://form.jotform.com/210230392515848

    So I have Form 1 fill in an address field. Upon submission I can get it to pre-populate a Short Text field in Form 2 "Street Test".

    Now when the process is restarted, my assumption is that the Unique Submission field will test the submissions on Form 2 - "Street Test"-Short Text Field.

    Is that correct? (This is assuming that there would be other submissions thereafter in Form 2 and the "Street Test" field will be pre populated at all times)

  • Profile Image
    ashwin_d
    Answered on February 01, 2021 at 01:28 AM

    I did check your form #2 and found that you have configured "Street Test" field as a unique question. Please note that when form 1 is submitted, and you redirect user to form 2 with field data prepopulated. When the form 2 is submitted, the data will be captured and the unique question validation will trigger when the process is restarted with form 1.

    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    luntiands
    Answered on February 01, 2021 at 02:12 AM

    @Ashwin.... thanks for that...

    Do you think my workaround will work?

    Basically what I want is for Form 2 to check whether the same address has been put in the system.

    Currently it doesnt seem to do it... I have already tried more than 5 times of the same address but it is just logging it as it goes...

  • Profile Image
    Gaetan_B
    Answered on February 01, 2021 at 04:08 AM

    Hello,

    It will not work.

    On Form 1 - https://form.jotform.com/210229043029849, you are not sending the address as separate fields as explained by my colleague above.

    1612169484_6017c10c50b7e_


    So the data doesn't get sent properly and the check will not work properly.

    Hope this helps.

    Do not hesitate to reach out if you need further assistance