Fetch Data From One DocType To Another | Frappe | ERPNext
ฝัง
- เผยแพร่เมื่อ 5 ก.พ. 2025
- In this easy tutorial, we'll show you how to move data from one document type to another in Frappe and ERPNext. If you've ever been puzzled by this process, you're not alone - many beginners encounter this challenge. But worry not! We've got you covered with simple steps to get the job done.
Join us as we tackle this common issue that frequently pops up on the Frappe Forum.
discuss.frappe...
Whether you're just starting out with ERPNext or looking to make your workflow smoother, this video is for you. Say goodbye to confusion and hello to a permanent solution with our simple approach.
Watch now and master the art of fetching data between DocTypes easily!
🔗 Don’t forget to subscribe for more ERPNext tips and tricks!
👍 Like this video if you find it helpful, and comment below with any questions or what you'd like to see next.
Video Timestamps:
00:10 - Intro
00:55 - Fetch From (Default Feature)
04:15 - Fetch the parent doctype data using client script
07:18 - Fetch data from one doctype to another using client script
Connect with us:
Frappe Forum: discuss.frappe...
LinkedIn: / nihantra-patel
X: / nihantra
GitHub: github.com/Nih...
You can try out Frappe with a 15-day free trial without needing to enter credit card details! Sign up here: frappecloud.co...
Learn more about:
Frappe Framework: frappeframewor...
Frappe: frappe.io
ERPNext: erpnext.com
#frappe #erpnext #frappeframework #ERPNextWithNihantra #NihantraPatel #ERPNextSolutionsWithNihantra #Nihantra
Thanks, NCP it's a really good and nice explain.
Thanks 😊👍
thank you
Hey Nihantra,
does this mean here items child table will save copied data from invoice items?
Yes, Sales Invoice table data set in the Invoice data table.
My respect for you!!
clear and complete ! thank you
Thanks 😊👍
Nice work
Thanks 😊👍
Thanks, NCP it's a really good and nice explain.
may I request to have the script.
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
Do you have a tutorial about how to filter the data that I selected from Item group field to the table?
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
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?
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
Nice !!! 🤩
Thanks 😊👍
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.
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
@@ERPNextWithNihantra thanks sir
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
Nice work Sir
is it possible to put script on description on every video?
Thanks
Please check the all video codes. 😊
github.com/Nihantra-Patel/ERPNextWithNihantra