Fetch Data From One DocType To Another | Frappe | ERPNext

[@LeQuocKhanh-q9s]

thank you

[@mohammednaji7820]

Thanks, NCP it's a really good and nice explain.

[@ERPNextWithNihantra]

Thanks 😊👍

[@BalezedeITServices]

My respect for you!!

[@farisalsolmi1921]

clear and complete ! thank you

[@ERPNextWithNihantra]

Thanks 😊👍

[@akshykhade]

Hey Nihantra,
does this mean here items child table will save copied data from invoice items?

[@ERPNextWithNihantra]

Yes, Sales Invoice table data set in the Invoice data table.

[@techinfo4114]

Thanks, NCP it's a really good and nice explain.
may I request to have the script.

[@ERPNextWithNihantra]

Please check the code: github.com/Nihantra-Patel/ERPNextWithNihantra/blob/main/fetch_data_from_one_doctype_to_another/fetch_data_from_one_doctype_to_another.js

[@HarikrishnanM-jn4xt]

Thank you for the information,
Please do a demonstration of fetching data from QR code scanner in a new doctype.
Eg: when scan the QR code of an item , Fetching Item code, Image, etc..
I am stuck in this. please help me

[@franciscobuendia8239]

I'm having this error "TypeError: Cannot read properties of undefined (reading 'options')", table is not pulling data from other doctype. Could you please point me for a solution?

[@ERPNextWithNihantra]

Please check the code:
github.com/Nihantra-Patel/ERPNextWithNihantra/blob/main/fetch_data_from_one_doctype_to_another/fetch_data_from_one_doctype_to_another.js

[@chloia.5880]

Do you have a tutorial about how to filter the data that I selected from Item group field to the table?

[@ERPNextWithNihantra]

Please check the example in the forum: discuss.frappe.io/t/how-to-apply-filter-to-child-table-link-fields/109010/2?u=ncp
And please check the documentation of the Overriding Link Query By Custom Script: frappeframework.com/docs/user/en/guides/app-development/overriding-link-query-by-custom-script

[@sandeepsandy2679]

Nice work

[@ERPNextWithNihantra]

Thanks 😊👍

[@raZz_Kutty]

Hi sir, i have a doubt
In ERPNext have a doctype called Interview it has child table named Interview Details.
Now i want to do this , when the interviewer login to ERPNext then i need to list out the interview documents that are only assigned to that particular interviewer.
I used user permissions but the interviewer can seen only one document. So each time creating a interview document the creator needs to give permission to that interviewer right?
Please can you help how to do this.

[@ERPNextWithNihantra]

Yes, you need to give the user permission each time you assign them to a document. Otherwise, try sharing the document and test it.
If you have any doubts, please raise the issue on the Frappe forum: discuss.frappe.io/new

[@raZz_Kutty]

@@ERPNextWithNihantra thanks sir

[@gadgetsforyou8378]

Nice work Sir
is it possible to put script on description on every video?
Thanks

[@ERPNextWithNihantra]

Please check the all video codes. 😊
github.com/Nihantra-Patel/ERPNextWithNihantra

[@tjomtek1079]

Nice !!! 🤩

[@ERPNextWithNihantra]

Thanks 😊👍