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

    updatin a text field if a field contain certain text

    Asked by caboride on December 19, 2015 at 08:31 AM

    Hello.

     

    Long time ago ( like 1 year ) i use form in which if you choose a type a car and a hotel the text field price is updated depending of the car and hotel and to short the number of conditions, there is a contain value in jotform so if the user choose from a list of hotels like this:

     

    Z1 Alegranza
    Z1 Barcelo Grand Faro
    Z1 Bel Air
    Z1 Cabo Azul
    Z1 Cabo Surf
    Z1 Casa Natalia
    Z1 Coral Baja
    Z1 El Encanto Inn
    Z1 Holiday Inn
    Z1 Hyatt Place
    Z1 Hyatt Ziva
    Z1 Las Olas
    Z1 Mañanitas
    Z1 Mar Adentro
    Z1 Mayan Palace
    Z1 Mikonos
    Z1 Mira Vista
    Z1 Posada Real
    Z1 Royal De Cameron
    Z1 Royal Park
    Z1 Royal Park
    Z1 Royal Solaris
    Z1 Sampaguita
    Z1 Suites Las Palmas
    Z1 Tropicana
    Z2 Esperanza
    Z2 Fiesta Americana Grand
    Z2 Grand Regina
    Z2 Hacienda Del Mar
    Z2 Hacienda Encantada
    Z2 Hilton
    Z2 JW Marriott
    Z2 Las Ventanas
    Z2 Los Patios
    Z2 Marbella Suites en la Playa
    Z2 Marquis
    Z2 Melia Cabo Real
    Z2 Palmilla
    Z2 Puerta Del Sol
    Z2 Secret Puerto Los Cabos
    Z2 Sheraton
    Z2 Sirena del Mar
    Z2 The Cape
    Z2 Villa Serena
    Z2 Westin

    the price field is updated, to short the options i use contain value and Z1, Z2, Z3 and so on.

    It seems this option is missing or i forgot how to use-

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by Chriistian on December 19, 2015 at 09:10 AM

    Hi,

     

    The "contains" rule is only applicable for textbox field. As a workaround, you can try the following instructions:

    1. Add a Textbox field to pass the value of the Hotel or Location dropdown.

    2. Add condition (Update a form field value ) to pass value from Dropdown field to textbox.

    3. Then add condition (Update a form field value ) to set the Price field value.

     

    You can check this sample clone form that I have created - http://www.jotform.com/form/52954372911863.

     

    Do let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by caboride on December 20, 2015 at 06:38 AM

    Thank you so much, thats was what i was missing.

    Kudos

  • Profile Image
    JotForm Support

    Answered by Mike_G on December 20, 2015 at 07:22 AM

    On behalf of my colleague, Chriistian, you're most welcome. Please feel free to get back to us should you have any other questions or concerns and we will be glad to help you. Thank you.

  • Profile Image

    Answered by grade4pagasa on December 20, 2015 at 10:29 AM

    Hi JotForm Support Team. 

    Is there a similar function within JotForm that works like MS Excel's VLookup? It would be tedious to create numerous conditions using the Update a form field value. 

  • Profile Image

    Answered by Boris on December 20, 2015 at 10:49 AM

    Randy, I'm afraid that we do not have any VLookup-like functions built in as far as I know, neither directly in Conditions or Calculations wizard, nor in our Spreadsheet widget.

    However, if you could describe what you are trying to achieve on your form in a little more detail, we would be happy to look for possible alternatives or workarounds to perhaps get such a behavior some other way. If you would like us to, please do open a new thread about it, so that our user caboride doesn't get unrelated email notifications from that other issue.

    Thank you.