Understand advanced principals around Powershell Core with a focus on the Linux Administrator. This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.
COURSE of the MONTH
11 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
jQuery handsontable auto-complete to auto-fill other fields
Posted on 2013-11-24
Hi all,
it's about jQuery Excel-like data grid editor. More can be found here:
I need help to combine this working jQuery autocomplete autofill :
...into this working handsontable autocomplete feature:
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.
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>
...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>
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.
[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
3-
3
6 Comments
Active today
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>
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.
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.
Active today
replace :
if(ac[i].name == value) {
if(ac[i].name.toLowerCase() == value.toLowerCase()) {
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
Typed su (all lowercase) : Suggestion NONE
Typed Su : Suggestion Suzuki
Typed SU (all uppercase) : Suggestion NONE
Active today
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
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
Featured Post
Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to build a simple, quick and effective accordion menu using just 15 lines of jQuery and 2 css classes
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery including how to code hide show and toggles.
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…
Suggested Courses
Course of the Month11 days, 20 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.