sir select box mai agr 3 options ho or hum first row mai ik option select kr dy to next row mai wo select box mai show na ho option isi kaise kry gy using simple jquery
how can we fetch the data from an api in this project i mean when i start typing the name of a product it should search the product in my database and when i select that particuler product it will be inserted in the table with respected price ... i need your help in this.
Thanks for Watching. I have made a video on this channel with the name "Fetch Item Rates from Google Sheets | Dynamic Invoice Tutorial using Apps Script & JavaScript" in which Google Apps Script has been used. You can understand the logic, use whatever API you want.
Thanks for Watching. Exactly as we have done for amt = qty * rate you can do for gst_amt = amt * gst_per /100 and you can pass 0 in index because gst value is in footer not in table which is only one time.
Value already in input box means echo value or fetched from database tables then how is calculate? Means one input box value is 10 and other one is 20 then how is calculate?
Thanks for Watching. You create a function in JavaScript and call it when the page loads or after the value is set from the database, which will do the calculation.
Thanks for Watching. You will have to create another input before the GST amount and calculate it by writing JavaScript on it. I will make a detailed video on this in a few days
Thanks for watching. Shwetank, "Perfection comes from practice". If you want to Mastery in any programming language, then you have to understand them well by taking small tasks. I have also not read particulars from any website or book, I also take small tasks and complete them, for example you must have seen this invoice example. Soon I will make a Blog/Video to learn JavaScript from scratch. Thanks
Thanks for watching, you will also get videos on storing data on this channel. If you want to store data in MySQL then watch this video (How to Connect HTML to MySQL Database using PHP). And if you want to store on Google Sheet then watch this video (How to Submit a HTML Form to Google Sheet Using Apps Script), there are different videos on Google Sheet according to the concept.
Sir iss mai aik masla hai jab mai form ko dubara clone karta hu Thu kaam karta hai lakin jab iss mai value ditha hu aur phir cross btn pi click karta hu thu voh value total se subtract nahi huta hai sir kia masla hu saktha hai
Delete के लिए हमने BtnDel() Function बनाया हैं , इसमे Row Remove करने के बाद आपको फिर से GetTotal(); Function Call करना होगा, शायद इसी कारण Delete करने पर Re Total नहीं हो रहा हैं।
We have created BtnDel() Function for Delete, in this after removing Row you will call GetTotal() Function, probably because of this, Re Total is not happening after deleting.
Hello sir nice tutorial... But sir how to display GST 18% amount in GST input field... Sub total calculate karne ke baad total GST amount display karna hai... Please reply sir
Thank you so much sir for making this video help me a lot But I have a question That as we enter the product name, can the rate be automatically displayed or fetched from google sheet? Because I want to create an invoice in such a way that I only need to enter the barcode of the product, and after that, the product name, unit of measurement, and cost price should automatically appear from [my sheets "all products" database]. I can simply enter the quantity and submit it."
Welcome, You can do exactly as you want. As soon as you select the item, the information related to the item is picked up from the item sheet and appears on the HTML.
Sir, This video is very helpful for me Thank you
Welcome
Very nice teaching by you... Thank You so much.. 🙏
You're welcome! I'm glad that you found my teaching helpful.
thank you so much sir for making this video help me a lot
You are most welcome
awesome boss. wanna this type of practicle js video more and more.
Sure 👍
very good, you are my savior
Welcome, I'm glad I could help
Nice teaching experience
Thanks and welcome
Plz make all your videos playlist, by series, to learn step by step
sir! Thanks so much You are great
Most welcome
very good
Thank you
Thanks really helpful
Welcome
Superb superb superb
But I want in django
Excellent Thank u Brother
You're most welcome
❤❤❤❤ Thank you for the video.
You are so welcome!
thank you for tutorial
Welcome
sir how to inser this data in database usig JDBC
sir select box mai agr 3 options ho or hum first row mai ik option select kr dy to next row mai wo select box mai show na ho option isi kaise kry gy using simple jquery
Assalamualaikum
Sir how do i write this code in django
THANK YOU
Welcome
thanks
Welcome
Serial No. wise kahan se start h
mujhe jquery k vedios ho to dijye nd mujhe java ko use karna h back end me to .. study kara dijye full..
Sir aadhar number se pan find ka full video banaiye
how can we fetch the data from an api in this project i mean when i start typing the name of a product it should search the product in my database and when i select that particuler product it will be inserted in the table with respected price ... i need your help in this.
Thanks for Watching. I have made a video on this channel with the name "Fetch Item Rates from Google Sheets | Dynamic Invoice Tutorial using Apps Script & JavaScript" in which Google Apps Script has been used. You can understand the logic, use whatever API you want.
Dear brother
I tried to do as same you have written but it is not multiplying the row what I do for more instruction please tell me how to do
Please check on the console, there must be some errors coming.
jb tamam row delete krain to gst b zeero hona chiay
Sir how to find auto gst using Javascript only
Thanks for Watching.
Exactly as we have done for amt = qty * rate you can do for gst_amt = amt * gst_per /100 and you can pass 0 in index because gst value is in footer not in table which is only one time.
Value already in input box means echo value or fetched from database tables then how is calculate? Means one input box value is 10 and other one is 20 then how is calculate?
Thanks for Watching.
You create a function in JavaScript and call it when the page loads or after the value is set from the database, which will do the calculation.
what code is required to calculate 18% GST?
Thanks for Watching. You will have to create another input before the GST amount and calculate it by writing JavaScript on it. I will make a detailed video on this in a few days
Best❤❤❤❤❤❤❤❤
Thanks for Watching.
Assalam o Alaikum Ham Grand Total jo is page par aaya hai isko kisi dusaray page par kaisay display karvaye gain
Namaste, Aap URL par parameter pass kar Value ko dusre page par le ja skate hain.
Sir, Its possible to show how i can use "rate" with decimel
Yes it is possible, if you type decimal in the rate, it will be typed.
useful information sir. what book should I refer for JavaScript. from where u mastered it.
Thanks for watching.
Shwetank, "Perfection comes from practice". If you want to Mastery in any programming language, then you have to understand them well by taking small tasks.
I have also not read particulars from any website or book, I also take small tasks and complete them, for example you must have seen this invoice example.
Soon I will make a Blog/Video to learn JavaScript from scratch.
Thanks
How to store this data from + colum into database
Thanks for watching, To store in database you can watch this video on this channel "How to Connect HTML to MySQL Database using PHP"
var net = +(sum) + +(gst); ki jagah bas ye use krna hain var net = +(sum) * ((100 + +(gst)) / 100); GST calculate into percentage
Why disabled is not working brother in my code
Thanks for Watching. You just try writing disabled, if it is still not there then try changing the browser once.
Hi! What if I would like to divide the total score by amount of items?
bro how to store the database in background
Thanks for watching, you will also get videos on storing data on this channel. If you want to store data in MySQL then watch this video (How to Connect HTML to MySQL Database using PHP). And if you want to store on Google Sheet then watch this video (How to Submit a HTML Form to Google Sheet Using Apps Script), there are different videos on Google Sheet according to the concept.
thank you so much sir for making this video help me a lot
Can u give me the practice file?
Welcome, Link Available in Description, Thanks for Watching.
Sir iss mai aik masla hai jab mai form ko dubara clone karta hu
Thu kaam karta hai lakin jab iss mai value ditha hu aur phir cross btn pi click karta hu thu voh value total se subtract nahi huta hai sir kia masla hu saktha hai
Delete के लिए हमने BtnDel() Function बनाया हैं , इसमे Row Remove करने के बाद आपको फिर से GetTotal(); Function Call करना होगा, शायद इसी कारण Delete करने पर Re Total नहीं हो रहा हैं।
@@selfimagination sir plz written english or urdu
Muje hindi nahi athi hai
We have created BtnDel() Function for Delete, in this after removing Row you will call GetTotal() Function, probably because of this, Re Total is not happening after deleting.
@@selfimagination thank you sir muje reply dena ka layee
Ok sir mai try karonga
How to insert those input fields results in database at a time?
HTML to MySQL wala video kal publish kiya hain use dekh kar aap html se mysql me data store kar sakte hain
@@selfimagination thank you so much sir 🙏🙏🙏🙏
Iski coding step by step btaiye sir plz
इस Video के Description मे Video की लिंक हैं उसमे इस Invoice को शुरू से बनाना बताया हैं।
Maine without input krna hai wo kaise hoga
Thanks for Watching. आपने Input की जगह पर क्या लिया हैं? , Div हैं या Table TD मे डाटा हैं ?
Hello sir nice tutorial...
But sir how to display GST 18% amount in GST input field... Sub total calculate karne ke baad total GST amount display karna hai...
Please reply sir
Thank you,
You can calculate 18 percent GST and add GST to Net on the same which we have brought Sum in GetTotal function in JavaScript.
Thank you so much sir for making this video help me a lot
But I have a question
That as we enter the product name,
can the rate be automatically displayed or fetched from google sheet?
Because I want to create an invoice in such a way that
I only need to enter the barcode of the product, and after that,
the product name, unit of measurement, and cost price should automatically appear from [my sheets "all products" database].
I can simply enter the quantity and submit it."
Welcome,
You can do exactly as you want. As soon as you select the item, the information related to the item is picked up from the item sheet and appears on the HTML.
Hallo sir, this video is very helpful for me, but can you help me to get separator for calculated value? e.g : 10000 --> 10,000 Thanks
Welcome, Thanks for Watching, A video related to this (Currency Format) is going to come on this channel in some time.
Oh great I'll wait for the video, thank you so much@@selfimagination
Thanks & Welcome
Source code please
can you send me the code i realy need it plzzz
There are links in the description, you can make your own with their reference.
sir
Yes, Please
thanks
Welcome