Whatever value i put in a field, it should create the child table with same column name

Aditya_vig1 · March 13, 2024, 2:34pm

Have a Look. I putting a values in this field.

So what i want, a dynamic child table gets created with a column name
S , S-XL

Aditya_vig1 · March 17, 2024, 6:56am

@NCP
Can you please help me in this requirement. I am not finding solution for this.

avc · March 17, 2024, 8:18am

Working with doctype child tables each column on the table represents one database column.

You could use html field, javascript to add to it a datatable, not “connected” with the doctype table, and render table with data dynamically as your requirement, fetching data from your backend. Anyway, this kind of customization is not easily doable without some programming knowledge …

Explore the component GitHub - frappe/datatable: The Missing Javascript Datatable for the Web and how it is being used on frappe and erpnext, like here:

github.com

frappe/frappe/blob/2f87a09ad9da558e664eeaabe93bb4ca0de9a677/frappe/desk/doctype/system_console/system_console.js#L66


      
          
          		if (frm.doc.output.startsWith("Traceback")) {
          			return;
          		}
          
          		let result = JSON.parse(frm.doc.output);
          		frm.set_value("output", `${result.length} ${result.length == 1 ? "row" : "rows"}`);
          
          		if (result.length) {
          			let columns = Object.keys(result[0]);
          			frm.sql_output = new DataTable(frm.get_field("sql_output").$wrapper.get(0), {
          				columns,
          				data: result,
          			});
          		}
          	},
          
          	show_processlist: function (frm) {
          		if (frm.doc.show_processlist) {
          			// keep refreshing every 5 seconds
          			frm.events.refresh_processlist(frm);

Hope this helps.

Aditya_vig1 · March 17, 2024, 9:26am

@avc
thank you for providing this. I’ll go through this and try it for my requirement.