How to fetch data and insert into table

Abhishek_Shah · May 22, 2019, 10:48pm

Hi,

I am creating a DocType for some internal requirement. I liked how the BOM could fetch operations and populate the table with values previously stored.

But I not able to replicate that fetch in a custom DocType. Basically I need to be able to auto load rows into a child table based on a template.

Also in DocType I noticed a fetch textbox. How can I use this, will it do what I require?

Is there some way to do this?

Pawan · May 23, 2019, 6:08am

You may have to use custom scripts for this.

Abhishek_Shah · May 23, 2019, 10:14am

@Pawan This is perfect, thanks!
Quick question, will Custom Script Fetch Values From Master, bring a list or just a single record? Because I need to populate a table with a set of results.

clarkej · May 27, 2019, 6:58pm

For this example https://erpnext.com/docs/user/manual/en/customize-erpnext/custom-scripts/fetch-values-from-master

Just a guess add_fetch here retrieves a single record

github.com

frappe/frappe/blob/develop/frappe/public/js/frappe/form/form.js#L849


      
          									me.script_manager
          										.trigger("on_submit")
          										.then(() => resolve(me))
          										.then(() => {
          											if (frappe.route_hooks.after_submit) {
          												let route_callback =
          													frappe.route_hooks.after_submit;
          												delete frappe.route_hooks.after_submit;
          												route_callback(me);
          											}
          										});
          								}
          							},
          							btn,
          							() => me.handle_save_fail(btn, on_error),
          							resolve
          						);
          					});
          				},
          				() => me.handle_save_fail(btn, on_error)
          			);

littlehera · May 28, 2019, 1:02am

add_fetch usually retrieves one value/field from your master (field is the one specified in the arguments).

I think you’ll need to create a custom script (and maybe a python script) that fits the use case you’re trying to achieve. By the way , is this a custom app with a custom doctype/child table ? Or are you just adding a custom script to an existing ERPNext doctype?

Regards,

Hera