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

    "If Contains" condition, allow multiple matches separated by comma

    Asked by Mrkay on July 04, 2014 at 11:02 AM

    Hi there,

     

    We offer installation services in parts of the UK; but we do not not install everywhere.

    I would like customers whose Postcodes match my conditions (those that have an installer in the area) to be sent to a specific lading page promoting the installation services.

    I am fully aware how to create landing pages and how to use conditions.

    However, there are thousands of postcodes in the UK. They look like this 

    BL40 9TT

    The only part of the postcode to be used is the HIGHLIGHTED AREA OF THE POSTCODE

    BL40 9TT

    Instead of making a condition for ever single eligible postcode is it possible to us a ' OR ' function or a ' '.

     

    For example:

     

    Hopefully you can see what I am trying to achieve...

    OR is there an option where I can use a hidden matrix with my jotform.

     

    Thanks

    JotForm style height hidden
  • Profile Image
    JotForm Support

    Answered by EltonCris on July 04, 2014 at 11:56 AM

    Hi,

    Thank you for your suggestion, I think I see what you mean here.

    I have raised this as a feature request so it will be considered in the future.

    For the meantime, you can try the Auto Complete field and insert all the post codes as its items so users will be able to see suggestions while entering answers on the auto complete field. Auto Complete is on the Widgets section.

    Guide:

     

    Here's how it works:

    Hope this still helps. Regards!

  • Profile Image

    Answered by Mrkay on July 07, 2014 at 04:23 AM

    Hi thanks for your reply,

    Yes this is the feature I am looking for.

    This solution does not resolve my issue as (If I can direct you to the sample form in question.) we are already collecting the postcode via our our address finder.

    http://greatgrass.co/sample-request

    Can you think of any other solutions such as an widget which checks a list via Google drive? Or can we insert the postcodes into a matrix as a hidden field on the form its self?

    Any further assistance would be helpful.

    I am surprised that the seperators via Comma ' , ' and OR features are not available now as its a pretty basic function even via MO Excel.

    Thanks

     

     

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 07, 2014 at 05:37 AM

    Hello Mrkay,

    Thank you for your clarification.

    Unless my colleague have any other suggestion, currently it is not possible to check / verify the data from any external source. For now the closest match I can think of is "Auto Complete" widget as mentioned by my colleague.

    My colleague have already created a feature request and sent it to our back end team. I did check the feature request ticket status, I found that it is already assigned to one of our developer. That means our back end team is already looking into this feature. We will update your here if we have any update from them.

    Thank you!

     

  • Profile Image

    Answered by Mrkay on July 09, 2014 at 09:50 AM

    Hi there,

    I know you do not usually comment on development time but is it possible to get an indication of how long this may take?

    If it is week I will hold back and wait. However, if it is months I will try to find a solution in the mean time.

    Thanks

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 09, 2014 at 11:01 AM

    Hello Mrkay,

    Unfortunately we cannot provide an ETA on this completely depends on the priority of our back end team. I did check the ticket status and since it is already assigned to one of our developer, this feature should be released very soon.

    Thank you!

  • Profile Image

    Answered by Mrkay on September 17, 2014 at 05:07 AM

    Thanks for completing this.

     

    I was wondering if you could offer any additional assistance with this.

     

    I have a customer who has provided there postcode as BN2 8QR

    BN2 is not a postocde area we cover.

    However we do cover N2.

     

     

    Obviously what has occurred us the condition has been met as it contains N2.

     

    I'e tried to change the condition to IF... Starts with...

     

    But it seems this function doesn't allow Comma separated values. Is it possible to add the function to this IF option.

     

    Thanks

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 17, 2014 at 07:43 AM

    Hello Mrkay,

    So if I understand your requirement correctly, you want to input multiple comma separated values in the "Starts With" condition as well. Is that correct?

    This will make it a separate requirement and I have moved it to a new thread. We will send a feature request and answer you on the following thread:  http://www.jotform.com/answers/430076 

    Thank you!

  • Profile Image

    Answered by Mrkay on September 17, 2014 at 11:31 AM

    Hi @Ashwin_d,

     

    I didn't create a new thread as it would create confusion what I was asking for as you can see from your colleagues response in the new thread...

     

    Thanks 

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 17, 2014 at 12:18 PM

    @Mrkay 

    You're indeed right. I will get back to you on your other thread. Sorry to missed that.

    Thanks!