updatin a text field if a field contain certain text

  • Profile Image
    Asked on December 19, 2015 at 08:31 AM



    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-



  • Profile Image
    Answered on December 19, 2015 at 09:10 AM



    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.

  • Profile Image
    Answered on December 20, 2015 at 06:38 AM

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


  • Profile Image
    Answered 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 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.