Make a field search able

Frappe Framework App Development
1

Hi Guys

I have an issue with the Link fields. I have created custom fields in Item DocType with is of fieldtype “Data”

now in the sales order item, i have created custom field however i want that when i put the focus on this field it should act like a Link field and query the Item table for that field and display the result.

I have created a Link field in the Sales Order Item and set the option field as “[Select]”

however this doesnt seems to be working, i have also set the query for this field but nothing is working.

can anyone help me out with it ??

2

Can you share the screenshot of Custom field?

In the Custom Field, Type should Select and in the option value should be

Link: doctype_name

3

i dont want a dropdown, and the field i am linking is not a DocType

it is just a custom field with type “data” created in the Item doctype.

in the Sales Order Item, i created another custom field with same fieldname as one in item, however i want this field to be search able and display the options just like a Link Field.

@umair

4

Hi, have you solved this issue?
I want the same — a searchable select field without linking to a DocType.

6

there is no such feature in the current system
here the solution you can follow for your senario

source doctype = Item , source field (data)= testdata1
target doctype = Sales Invoice , Source field (select )= testoption

in the sales invoice client script paste and save the below code

frappe.ui.form.on(‘Sales Invoice’, {
onload: function(frm) {
frappe.call({
method: ‘frappe.client.get_list’,
args: {
doctype: ‘Item’,
fields: [‘testdata1’],
limit_page_length: 999
},
callback: function(response) {
if (response.message) {
let options = response.message
.map(row => row.testdata1)
.filter(Boolean); // removes null/undefined/empty
// Remove duplicates
options = […new Set(options)];

            // Set dropdown options for 'testfield2'
            frm.set_df_property('testoption', 'options', options);
        }
    }
});

}

check and let me know.