Doctype Table - need ability to search for and add

cshankey · April 15, 2015, 12:00am

When you create a “Table” based field for a DocType it looks like the only option you have is to create an object in that table. Is it possible to have the ability to search for an item, which is then added to the table? I am using Links in other places but they seem to apply only to link a single object to the current object.

rmehta · April 15, 2015, 5:48am

As per the current design, you will have to create a separate DocType for the table. There is no work-around.

cshankey · April 15, 2015, 6:12am

Thanks for responding so quickly. Is it possible in Python to use the Link field type as a “virtual” or proxy relationship for the actual relationship represented by the table?

rmehta · April 16, 2015, 3:31am

Yes you can override the link query

https://kb.frappe.io/kb/customization/overriding-link-query-by-custom-script

or

You can manually add an autocomplete

see example:

github.com

frappe/erpnext/blob/develop/erpnext/stock/doctype/item/item.js#L7


      
          // Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
          // License: GNU General Public License v3. See license.txt
          
          
frappe.provide("erpnext.item");
          
          
frappe.ui.form.on("Item", {
          	setup: function(frm) {
          		frm.add_fetch('attribute', 'numeric_values', 'numeric_values');
          		frm.add_fetch('attribute', 'from_range', 'from_range');
          		frm.add_fetch('attribute', 'to_range', 'to_range');
          		frm.add_fetch('attribute', 'increment', 'increment');
          		frm.add_fetch('tax_type', 'tax_rate', 'tax_rate');
          
          
		frm.make_methods = {
          			'Sales Order': () => {
          				open_form(frm, "Sales Order", "Sales Order Item", "items");
          			},

NoBoneZ · January 1, 2024, 12:47pm

Hello, i have a doctype(A) which is used as a link field in a lot of doctypes, instead of overriding the link query in every doctype which the doctype(A) is being used as a link field, how can just set a global query, such that whenever that doctype(A) is being used as a link field, that query kicks in

szufisher · January 1, 2024, 2:45pm