JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
updatin a text field if a field contain certain textAsked by caboride 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-
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.
Thank you so much, thats was what i was missing.
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.
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.
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.