Fetch From Option Frappe Dialog table field

Frappe Framework
1

This is Dialog box table link field, to fetch the serial number from serial number table.

  1. How to avoid the display of row 1, row 2 in grid ?

  2. is there any option to apply fetch from - specific field like docType in dialog box link field, Need to show the serial no in 2nd column.

  3. is any option to set the width of each column ?

  4. Is any option to show the serial no while selecting the ID from link field

{
label: ‘Serial No’,
fieldname: ‘serial_list’,
fieldtype: ‘Table’,
in_place_edit: true,
fields: [
{
label: __("ID "),
fieldname: ‘name’,
fieldtype: ‘Link’,
in_list_view: true,
options: “Serial No”,
change() {
let doc = this.doc;
frappe.db.get_value(‘SKU Serial No’, this.get_value(), ‘serial_no’, function (value) {
doc.serial_no = value.serial_no;
})

                        },
                    },
                    {
                        label: 'Serial No',
                        fieldname: 'serial_no',
                        fieldtype: 'Data',
                        in_list_view: true,
                    },
                   
                ]
            },

image
image722×412 19.2 KB

2

I’m guessing both 2 and 4 are the same question.

There is no option of fetch_from that we use in DocTypes. But you can fetch the value using the ‘onchange’ event of that field of the table.

Refer this for example.

To answer your 3rd question, you can use “columns” key. The max column combined is 10.

1 Like
3

Thanks for the support