How to Hide child table fields in standard doctype

ERPNext Customize ERPNext
1

frappe.ui.form.on(‘Stock Entry’, {
refresh: (frm, cdt, cdn) => {
let doc = locals[cdt][cdn]
// console.log(doc)
// console.log(frm.doc.purpose===‘Material Transfer’)
frm.fields_dict[“items”].grid.set_column_disp(“source_warehouse_storage_location”, frm.doc.purpose ===‘Material Transfer’);
}
})

im trying to hide/show the child doctype fields based on stock entry type but it is not working.

P.S - I have a doctype js hook so the code is in my custom app not client script but anyways i check through client script it didnt work even then.

ERPNext: v13.19.0 (version-13)
Frappe Framework: v13.19.0 (version-13)

2

try this:

var df = frappe.meta.get_docfield("Child Table Name", "field_name", cur_frm.doc.name);
df.hidden = 1
1 Like
3

tried this but it works only before form is loaded

4

@OmarJaber this is working but it works only during setup,onload, refresh events my requirement is i need this field based on some conditions suppose from stock entry pupose and stock entry detail warehouse selected so if there is workaround so that I can use df even in child table fieldname events it would be very helpfull for me

Thank you

5

I’ve struggled with this too. The best solution I found came from this post. Using Sagar’s example, I’ve been able to trigger on refresh() events, and hide/show columns using some logic.

6

@brian_pond thank you let me try this out.

7

This did not work it worked fine in version 12 but then again version 13.19.0 its the same problem unable to hide fields on child table.

8

Hi @Yashwanth,

Please try in Depends On / Read Only Depends On permission

eval: parent.stock_entry_type == “Material Transfer”
OR
eval: parent.stock_entry_type != “Material Transfer”

Thanks!

9

i want it in script which user should not be able to see so, is there any other way

Thank you

10

can we hide column for particular doctype.

11

means?

12

i was create child table. That child table is present in multiple doctype , i want to hide dose% field in fg doctype only. (dose% is in_list_view == 1)

13

I think, you should implement a client script for this scenario. When using this child table multiple times and setting the eval condition, it affects all doctypes, so developing a client script becomes necessary. However, please note that you cannot configure the list view using a client script; it only allows you to manage hidden or read-only fields. This can be a bit complex. Therefore, I recommend checking the forums for a reference or further guidance.