Solved

jQuery handsontable auto-complete to auto-fill other fields

Posted on 2013-11-24

1 solution

4,462 Views

1 Endorsement

Last Modified: 2013-11-26

Hi all,
it's about jQuery Excel-like data grid editor. More can be found here:

http://handsontable.com/

I need help to combine this working jQuery autocomplete autofill :

<!DOCTYPE html>
<html>
	<head>
		<meta charset='utf-8'>
		<title>jQuery UI Autocomplete - Autofill</title>
		<link rel="stylesheet" type="text/css" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1/themes/redmond/jquery-ui.css">	
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
		<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
		<script type="text/javascript">
		$(function() { 
			$('#iprice').val("");
			$('#icode').val("");

			$("#name").autocomplete({
				source: [{"name":"BMW","label":"Air Soft Gun","price":"212","abbrev":"BMW"},
						 {"name":"Chrysler","label":"Pepsi Cola Hat","price":"24","abbrev":"CRY"},
						 {"name":"Nissan","label":"Candle Lights Dinner","price":"780","abbrev":"NSS"},
						 {"name":"Suzuki","label":"Pork Meat Ball","price":"178","abbrev":"SZK"},
						 {"name":"Toyota","label":"Granny Health Supplement","price":"24","abbrev":"TYT"}],
				minLength: 2,
				select: function(event, ui) { 
					$('#iprice').val(ui.item.price);
					$('#icode').val(ui.item.abbrev);
				}
			});"BMW", "Chrysler", "Nissan", "Suzuki", "Toyota", "Volvo"

			$["ui"]["autocomplete"].prototype["_renderItem"] = function( ul, item) {
				return $( "<li></li>" ) 
  				.data( "item.autocomplete", item )
  				.append( $( "<a></a>" ).html( item.label ) )
  				.appendTo( ul );
			};

		});
		</script>
	</head>
<body>
<div class="container">
<form action="" method="post">
	<p class="ui-widget">
		<input type="text" id="name" name="name" />
		<input readonly="readonly" type="text" id="iprice" name="iprice" size="5">
		<input readonly="readonly" type="text" id="icode" name="icode" size="3">
	</p>
</form>
</div>
</body>
</html>

Open in new window

...into this working handsontable autocomplete feature:

<!doctype html>
<html>
<head>
  <meta charset='utf-8'>
  <title> Handsontable | Autocomplete OK | Autofill ?!? </title>
  <script data-jsfiddle="common" src="https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
  <script data-jsfiddle="common" src="http://handsontable.com/dist/jquery.handsontable.full.js"></script>
  <link data-jsfiddle="common" rel="stylesheet" media="screen" href="http://handsontable.com/dist/jquery.handsontable.full.css">
</head>

<body>

        <div class="pad">
          <div id="mytables"></div>
        </div>

<script type="text/javascript">
var $container	= $("#mytables");
var comsources	= ["BMW", "Chrysler", "Nissan", "Suzuki", "Toyota"];

$container.handsontable({
  startRows: 1,
  startCols: 5,
  rowHeaders: true,
  colHeaders: ['Item Name', 'Price', 'Code'],
  minSpareRows: 1,
  contextMenu: true,
  columns: [
    {
	  data: "name",
      type: 'autocomplete',
      source: comsources,
      strict: false
    },
    {
	  data: "price"
	},
    { 
	  data: "code"
	}
  ]
});
</script>

</body>
</html>

Open in new window

So, what I'm looking for is the autocomplete autofill feature to be applied to "handsontable". On handsontale I can manage to have an autocomplete field... I want this, when a value is selected from the autocomplete, it will also fill 2 other fields with a value.

I was doing lots of trial & errors but seems not able to find a proper solution.

Please help... Thanks.

Comment

Question by:tobece

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

6 Comments

LVL 82

Accepted Solution

by:leakim971

leakim971 earned 500 total points

ID: 396735902013-11-24

Test page : http://jsfiddle.net/wvXvJ/

<!doctype html>
<html>
<head>
<meta charset='utf-8'>
<title> Handsontable | Autocomplete OK | Autofill ?!? </title>
<link data-jsfiddle="common" rel="stylesheet" media="screen" href="http://handsontable.com/dist/jquery.handsontable.full.css">
<script data-jsfiddle="common" src="https://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script data-jsfiddle="common" src="http://handsontable.com/dist/jquery.handsontable.full.js"></script>
<script type="text/javascript">

	$(document).ready(function() {

		var $container	= $("#mytables");
		var comsources	= ["Chrysler", "Nissan", "Suzuki", "Toyota"];

		var ac = [
			{"name":"Chrysler","label":"Pepsi Cola Hat","price":"24","abbrev":"CRY"},
			{"name":"Nissan","label":"Candle Lights Dinner","price":"780","abbrev":"NSS"},
			{"name":"Suzuki","label":"Pork Meat Ball","price":"178","abbrev":"SZK"},
			{"name":"Toyota","label":"Granny Health Supplement","price":"24","abbrev":"TYT"}
		];
	
		var ht = $container.handsontable({
			startRows: 1,
			startCols: 5,
			rowHeaders: true,
			colHeaders: ['Item Name', 'Price', 'Code'],
			minSpareRows: 1,
			contextMenu: true,
			columns: [
				{
					data: "name",
					type: 'autocomplete',
					source: comsources,
					strict: false
				},
				{
					data: "price"
				},
				{ 
					data: "code"
				}
			],
			afterChange : function(arr, op) {
				if(op=="edit"&&arr.length==1) {
					var value = arr[0][3];
					for(var i=0;i<ac.length;i++) {
						if(ac[i].name == value) {
							$container.handsontable("setDataAtCell", arr[0][0], 1, ac[i].price);
							$container.handsontable("setDataAtCell", arr[0][0], 2, ac[i].abbrev);
							return false;
						}
					}
				}
			}
		});
	});

</script>
</head>
<body>
<div class="pad">
	<div id="mytables"></div>
</div>
</body>
</html>

Open in new window

Author Comment

by:tobece

ID: 396758512013-11-25

Thanks @leakim971 it really saves my time a lot.

Would you help me once more time on the lowercase issue.
For example :
* If I type su then nothing appears as suggestion.
* If I type Su (1st char is uppercase) then Suzuki appears as suggestion.

I think will be better if I type su (all lowercase) then Suzuki would appears as a suggestion.

I've tried to put toLowerCase() on some possible places (that I can think of) but still not getting a proper solution.

LVL 82

Expert Comment

by:leakim971

ID: 396758772013-11-25

replace :

if(ac[i].name == value) {

Open in new window

by :

if(ac[i].name.toLowerCase() == value.toLowerCase()) {

Open in new window

Author Comment

by:tobece

ID: 396759602013-11-25

Actually that was where I placed toLowerCase() but seems like nothing changes?

Typed su (all lowercase) : Suggestion NONE
Typed Su : Suggestion Suzuki
Typed SU (all uppercase) : Suggestion NONE

LVL 82

Expert Comment

by:leakim971

ID: 396760062013-11-25

Look like the autocomplete type cell don't support that :
http://handsontable.com/demo/autocomplete.html

you should ask the developer to add this in their plugin as I don't see any solution outside the plugin

Author Closing Comment

by:tobece

ID: 396784162013-11-26

@leakim971:
OK thanks for the codes.
I'll be contacting them regarding the issue of lowercase letters in autocomplete.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Delegation for dynamic elements using JQuery on()

Article by: Anthony

There are a couple ways to attach a JavaScript function to dynamically created elements. You can make a new script for each element as it’s created or you can use delegation. Delegation allows a single script that is added at page creation to mat…

jQuery

Passwords in HTML Forms: Allow the Client to Show or Hide

Article by: Ray

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form. And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…

PHP, jQuery, and Form Actions

Video by: Marco

The viewer will learn how to dynamically set the form action using jQuery.

Introduction to jQuery (Part 1)

Video by: Jason

The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)