Forums

Autocomplete in a form

beatfenix 05 Apr, 2011
First, sorry for my English (Google translate). I have read all posts related to auto-complete, but I can not understand how to do it for me, because most are looking at local data but in my case should look in the MySQL-DB on the same field where I would place the function. My knowledge of code are very few. Could you show me where to put different parts of the code that provides digitaral and how to break into ChronoForms. I guess it will be in the form code tab.

My html code form:
 <div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Grupo</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="Introduce el nombre del grupo" id="text_1" name="grupo_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_datetimepicker">
    <label class="cf_label" style="width: 150px;">Fecha</label>
    <input class="cf_datetime required" title="Introduce una fecha" size="20" id="fecha_evento" name="fecha_evento" type="text" />
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Hora</label>
    <input class="cf_inputbox" maxlength="5" size="5" title="Introduce una hora" id="text_9" name="hora_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Lugar</label>
    <input class="cf_inputbox required" maxlength="150" size="30" title="Introduce un lugar" id="text_4" name="lugar_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Dirección</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="Introduce una dirección" id="text_6" name="direccion_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">CP</label>
    <input class="cf_inputbox validate-number" maxlength="5" size="5" title="Introduce un CP" id="text_8" name="CP_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Ciudad</label>
    <input class="cf_inputbox required validate-alpha" maxlength="150" size="30" title="Introduce la ciudad" id="text_9" name="ciudad_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Provincia</label>
    <select class="cf_inputbox validate-selection" id="select_11" size="1" title="Selecciona la provincia"  name="provincia_evento">
    <option value="">Elige una provincia</option>
      <option value="Álava">Álava</option>
<option value="Albacete">Albacete</option>
<option value="Alicante">Alicante</option>
<option value="Almería">Almería</option>
<option value="Avila">Avila</option>
<option value="Badajoz">Badajoz</option>
<option value="Baleares">Baleares</option>
<option value="Barcelona">Barcelona</option>
<option value="Burgos">Burgos</option>
<option value="Cáceres">Cáceres</option>
<option value="Cádiz">Cádiz</option>
<option value="Castellón">Castellón</option>
<option value="Ciudad Real">Ciudad Real</option>
<option value="Córdoba">Córdoba</option>
<option value="A Coruña">A Coruña</option>
<option value="Cuenca">Cuenca</option>
<option value="Gerona">Gerona</option>
<option value="Granada">Granada</option>
<option value="Guadalajara">Guadalajara</option>
<option value="Guipúzcoa">Guipúzcoa</option>
<option value="Huelva">Huelva</option>
<option value="Huesca">Huesca</option>
<option value="Jaén">Jaén</option>
<option value="León">León</option>
<option value="Lérida">Lérida</option>
<option value="La Rioja">La Rioja</option>
<option value="Lugo">Lugo</option>
<option value="Madrid">Madrid</option>
<option value="Málaga">Málaga</option>
<option value="Murcia">Murcia</option>
<option value="Navarra">Navarra</option>
<option value="Orense">Orense</option>
<option value="Asturias">Asturias</option>
<option value="Palencia">Palencia</option>
<option value="Las Palmas">Las Palmas</option>
<option value="Pontevedra">Pontevedra</option>
<option value="Salamanca">Salamanca</option>
<option value="Tenerife">Tenerife</option>
<option value="Cantabria">Cantabria</option>
<option value="Segovia">Segovia</option>
<option value="Sevilla">Sevilla</option>
<option value="Soria">Soria</option>
<option value="Tarragona">Tarragona</option>
<option value="Teruel">Teruel</option>
<option value="Toledo">Toledo</option>
<option value="Valencia">Valencia</option>
<option value="Valladolid">Valladolid</option>
<option value="Vizcaya">Vizcaya</option>
<option value="Zamora">Zamora</option>
<option value="Zaragoza">Zaragoza</option>
<option value="Ceuta">Ceuta</option>
<option value="Melilla">Melilla</option>

    </select>
    
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Precio</label>
    <input class="cf_inputbox validate-number" maxlength="3" size="3" title="" id="text_12" name="precio_evento" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Aceptar" name="button_14" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>


The textbox that must contain de autocomplete function is grupo_evento. Thanks a lot.
GreyHead 06 Apr, 2011
Hi beatfenix,

I'm sorry but I don't understand your question clearly enough to give you an answer. I don't think it's just the Google translation.

Exactly what do you want autocompleted and from where?

Bob



Bob
This topic is locked and no more replies can be posted.