Autocomplete field

Dany_Carvalheiro · February 25, 2016, 9:53am

Hi, can you explain to me how does autocomplete works, like when i choose a customer when doing a quotation, the labels as price list, currency are autocompletion them selves, i wanted to make another label thats do autocomplete by choose the customer, but i dont know how does it work

max_morais_dmm · February 25, 2016, 10:10am

@Dany_Carvalheiro, this are based in 2 features

add_fetch and set_df_property

add_fetch, works like the VLOOKUP of excel, to fetch a value from a referenced record
set_df_property change certain properties of a field, in this case (label)

These actions are made in JavaScript

github.com

frappe/erpnext/blob/develop/erpnext/public/js/controllers/transaction.js#L444


      
          				this.frm.fields_dict["items"].grid.grid_rows[item.idx - 1].remove();
          			} else {
          				item.pricing_rules = ''
          				return this.frm.call({
          					method: "erpnext.stock.get_item_details.get_item_details",
          					child: item,
          					args: {
          						doc: me.frm.doc,
          						args: {
          							item_code: item.item_code,
          							barcode: item.barcode,
          							serial_no: item.serial_no,
          							batch_no: item.batch_no,
          							set_warehouse: me.frm.doc.set_warehouse,
          							warehouse: item.warehouse,
          							customer: me.frm.doc.customer || me.frm.doc.party_name,
          							quotation_to: me.frm.doc.quotation_to,
          							supplier: me.frm.doc.supplier,
          							currency: me.frm.doc.currency,
          							update_stock: update_stock,
          							conversion_rate: me.frm.doc.conversion_rate,

github.com

frappe/erpnext/blob/develop/erpnext/selling/sales_common.js#L22


      
          erpnext.selling.SellingController = class SellingController extends erpnext.TransactionController {
          	setup() {
          		super.setup();
          	}
          
          
	onload() {
          		super.onload();
          		this.setup_queries();
          		this.frm.set_query('shipping_rule', function() {
          			return {
          				filters: {
          					"shipping_rule_type": "Selling"
          				}
          			};
          		});
          	}
          
          
	setup_queries() {
          		var me = this;
          
          
		$.each([["customer", "customer"],

shraddha · February 26, 2016, 9:02am

Steps:-

1.For that Go to “Customize Form”
Enter Form Type=Item Price
Add new Row-
Label= Item Group
Type=Data
check option “Read Only”->Done
Drag that Row under “Item Name” row ,if you want…
click on “Update” button

2.After that Go to “Custom Script” form (search for "Custom Script)
Create ‘New’
select Doc Type=Item Price

Write Script:-

frappe.ui.form.on(“Item Price”, “onload”, function(frm) {
cur_frm.add_fetch(‘item_code’, ‘item_group’, ‘item_group’);
})

Save Form.

shraddha · February 26, 2016, 9:06am

You can refer following link also to read more things about custom script

http://frappe.github.io/erpnext/user/manual/en/customize-erpnext/custom-scripts/custom-script-examples/

Dany_Carvalheiro · February 26, 2016, 10:12am

thank you