FANTASTIC video! In the first 3 minutes and 20 seconds you've taught the entire concept of PySimpleGUI. You're really good at this! 💖 the style, the clarity, the animations, and so much more about what you've done.
Thank you so much for your comment & this fabulous and simple to use library. I simply love it - with just a few lines of code, we can add a GUI to our program without messing around with the underlying frameworks. So clever and very well done! 😃👍
@@CodingIsFun Very nice. I have just started learning PySimpleGUI, last month. I want to build a project for my niece for garment shop. Hope I will achieve it soon with the help of experts like you. Thanks a lot. Keep it up.
This is the correct benchmark of technical teaching - I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding - thank you !
I am able to create this exe file. But whn I try to input some data through the application, the data doesnt get appended in the xlsx file. Anything I am missing
WOW I am impressed. This video is friendly and right to the point. Love it. In 10 minutes I learnt more stuff than reading any book on this topic. Excellent Job!
By far this is the best tutorial video I have seen, clear instructions, demonstrations in theory behind each concept and easy to follow bite size steps, learnt more in this short video then in some hour long ones. Thank you for taking the time to produce this and share your expertise with the Community
This is a great video. I am a beginner at using python and coding. This will help me understand what a GUI is and allow me to create something nice for work. Thanks a lot!
@@CodingIsFun Although there is a problem i hope you can help me with , the script wont convert to .exe , whenever i tried it says (IndexError: tuple index out of range) , dist folder is empty as well everything is updated i'm using Visual Studio and the script work fine with Visual Studio and from the Command prompt I would really appreciate if you know the answer Regards
Hello Sven, I can just add another positive reaction to all the others you already received, WOW WOW what a great tutorial! Thanks for this amazing work and I guess the Python community should build a statue for you! Regards, Frank
@@dishangmehta4397 Thanks for watching the video & your video suggestion. Sounds like an exciting video topic. I cannot make any promises, but l will see what I can do.
@GYAAN TECH Thanks for watching the video. In the PySimpleGUI Cookbook, there is an example of how to save the input: 'Recipe - Save and Load Program Settings' pysimplegui.readthedocs.io/en/latest/cookbook/ Regarding the multiline input box: As mentioned in the video, please have a look at the 'Demo' folder. PySimpleGui offers the following widget: sg.Multiline(default_text='This is the default Text should you decide not to type anything', size=(35, 3))
I am a novice, and I need guidance on how to install the Command Prompt. The Windows Command Prompt returns errors only. Thank you. BTW. Great job! Straight to the point, and it is exactly what I needed. Regrettably, I am not a programmer and I have difficulties to install the tools to code and follow your instructions. Thanks again.
you just got another subscriber , this is so useful and relevant in my field of work . Just started out with python and your explanation is so clear and concise . Thank you brother.
Xlent video.. ❤️simple and clear Sven..U shortened my learning with this video.. if possible.. please make video on update, search and delete options on this topic itself...which will enhance knowledge of ur followers. ❤️ My advanced wishes...
Thank you for the video. I was using the append with concat when I was trying Web Scraping, but it was very confusing when dealing with multiple page scrapes because I'm a beginner. I saw someone with pdf extraction use something called a namedtuple for combining values, and appending a list which is then put into a dataframe. That method seemed simpler to me.
THX! for the video, is there a use and input box to add numbers to multiple certain cell location within the CSV file? For the file I need to create, there is a value that need to input to multiple location within the CSV. So one input multiple output in different locations within the CSV.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Hello, thank you very much for the video and for the clarity of its message. May I ask you if there is any chance to import (in to excel file) only some data leaving the GUI as is?
@@CodingIsFun Hello, thanks a lot for your quick reply. Much appreciated. btw, in your example, you consider five "element" of information (i.e : Name, City, Favorite color, spoken language and n° of children). my question is: is it possible to save in the excel file only some of them (e.g.: Name and n° of children)?
Amazing tutorial. Thanks for your work. I have a question tho. What should I do if i need some of the fields of the excel file to be filled always with the same data? I'll explain this. I have to worl with a boring CSV File in wich i have to manually fill only 2 or 3 cells, and the remaining (a total of 10 in a line) they have always the same data. A boring work of copy/paste for hundreds of lines. This will help me a lot if I could apply your teaching on my needs. Thank you
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Great video Thanks for this, I have one question y supossed that when I share the exe file needs to be with the excel and has to be in the same path right? To change this path I could implement other window with option to change the path or the file to append data?
Thanks for watching. You are right. Currently, the application is looking for an Excel file in the same folder. Yet, you can select the Excel file dynamically by inserting the 'FileBrowse' Element: pysimplegui.readthedocs.io/en/latest/call%20reference/ www.screencast.com/t/64AUEVrzN I hope it helps! Happy Coding! :)
Here are the docs regarding adding images: docs.pysimplegui.com/en/latest/documentation/module/elements/image/ I'm not sure what you mean by hosting it locally - sorry! Cheers, Sven ✌️
Hi is it possible to create a variable for a combo box? so would not have to adjust it in the code itself but on the variable only? I am new to this and still learning. Can this use by multiple users simultaneously? My worry is the possibility of overlapping. Thank you.
To store the "variable," consider creating a settings file like settings.ini to retrieve the drop-down values. This eliminates the need to modify the code. Check out this tutorial for guidance: ruclips.net/video/LzCfNanQ_9c/видео.html&feature=shares. To allow for simultaneous editing, use a storage format like Google Sheets or a database instead of a local Excel file, which can only be edited by one user. Best of luck and happy coding!
Thank you very much. For retrieving/editing data, have a look at the following short example: ruclips.net/video/RnTqlKzQhRY/видео.html I hope this helps!
amazing video, one of the most valuable 3min i spent on youtube. would you show how we read combo information from mySQL db instead of hard code it in the program? thanks
Thanks for watching the video. Happy to hear that you found the video valuable. In essence, PySimpleGUI is 'just' used to create the GUI. If you want to manipulate a MySQL database, I would suggest coding out your pure Python script first (without GUI). Once you got your CRUD (Create/Read/Update/Delete) functions in place (or whatever you want to do) when you can build the GUI using PySimpleGUI. To get started with MySQL + PySImpleGUI, check out the following post: stackoverflow.com/a/622308 Happy Coding! 🚀
Thank you for this, I'll be using this as my base code, very simple to understand and follow along... Would it be possible for you to do a tutorial extending this with a pdf file viewer at the side of the entry form, I would like to make something like this but with two panes/section, 1 section for the data entry form and the other for viewing a pdf file... thank you!
Hey there, thanks for watching and for your kind words! I'm glad you found the tutorial easy to follow. While I might not create a specific tutorial for your use case, I encourage you to check out my advanced PySimpleGUI tutorial here: ruclips.net/video/LzCfNanQ_9c/видео.html. By combining the techniques from both tutorials and experimenting on your own, you should be able to achieve your desired layout with a data entry form and a PDF viewer. Good luck, and happy coding!
@@CodingIsFun wow that was fast, thanks for taking time to reply, I've already modified the code to include the fields I needed and it's working without errors, I have 0 knowledge of python and was trying to make something like this by asking Chatgpt but was not successful, your code just works! I'll be checking out the video you mentioned hopefully I could integrate the pdf viewer part successfully too, many thanks again...
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet/documentation for a solution. Sorry that I cannot help!
Hello Man, The way you are explaining is excellent!!! Thanks a lot, Please tell me Do you have similar tutorial or code where Data Entry is My SQL intesad of excel? Thanks in advance
Thanks for watching. Yes, it is possible to perform calculations before inserting the data into Excel. You can do this by manipulating the data in the "values" dictionary or the "new_record" DataFrame. Happy Coding!
Hello! Excellent presentation! But I got a few questions. How I Can add a timestamp in a separate Excel column every time someone click on Submit? Thank you!
Hi Alex. Thanks for watching. I have created the following solution for you: gist.github.com/Sven-Bo/71251c76e3e3e7183dc6135b371f8c14 Hope you like it! Happy Coding!
I was looking for a way to get data from and Excel file to use in an online web form filling. I've done this successfully using Power Automate Desktop but now I don't have a license. Looked at AHK but without the coding skill it's beyond my scope for now. Watched your video using chatGPT to write Python automation BUT I guess this is a bit more challenging as each input field needs to be mapped in Python. How deep would this be?
@@walidmat8972, I am not sure if that is possible. I quickly checked the documentation but could not find an option to set the x and y position. But perhaps I have overlooked something. Here is the link to the official documentation: pysimplegui.readthedocs.io/
Subscribed! Thank you so much for the tutorial, I'm just a beginner in python but this really helped me building a simple database. It could be useful to upgrade the form allowing to modify the excel data once they are stored. Could you point me in the right direction? Thanks again!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
hi thanx for the tutorial i have a question the form stores the numbers as text in excel which command can i use to auto convert them to numbers in excel without showing errors?
@@CodingIsFun the form is the same as yours and it only has a number box (exactly like the name box you have) everything is working only i don't know how to convert the numberr
@@CodingIsFun great! I’d like to send an email…would you type down here? I study IT at a reputed university in Brazil. I would love to have a talk to you. Thanks. - Mateus
Hello Sven, I appreciate the video it immensely helped me navigate the pandas module. I have one question about pysimplegui. When I try to offline no console i can not execute the file. I get an error that states that my excel file is uncallable. How would I ensure my excel file is included in the offline program or even if i were to put the program onto another computer how would i ensure the spreadsheet is mapped correctly. Thank you for your help I hope to hear back soon.
Hi Colt. Thanks for watching. Happy to hear that the video was helpful. Regarding your question, please try the following (assuming you took the latest code from the GitHub repo:): Remove: current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd() Add: current_dir = Path.cwd() ..and try again. I hope it helps! Happy Coding!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thanks for the fantastic video. This is really a cool program! I have gone through all the steps, but there must be something I am missing because I cannot get the excel file to update from the GUI... The path and code is correct, but the excel document does not update with the new info... Any clues to what I have done wrong?
FANTASTIC video! In the first 3 minutes and 20 seconds you've taught the entire concept of PySimpleGUI. You're really good at this! 💖 the style, the clarity, the animations, and so much more about what you've done.
Thank you so much for your comment & this fabulous and simple to use library. I simply love it - with just a few lines of code, we can add a GUI to our program without messing around with the underlying frameworks. So clever and very well done! 😃👍
@@CodingIsFun Very nice. I have just started learning PySimpleGUI, last month. I want to build a project for my niece for garment shop. Hope I will achieve it soon with the help of experts like you. Thanks a lot. Keep it up.
This is the correct benchmark of technical teaching - I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding - thank you !
Thanks for the kind words! I am glad you enjoyed it.
Seriously I loved it. No one has this organized tutorial with documentation as implementation.... I'm in love
Thank you so much for your kind feedback! :)
Bro, seriously, you are really the god of coding to me , it was the best tutorial i have ever seen
Thank you, mate! Happy to hear that the video helped you. Happy Coding! Cheers, Sven ✌️
Thank you very much! I tried it on and it worked very well here from Start to Finish. I entered the data using Portuguese symbols and worked fine.
Glad to hear you liked it and that it is working! Thank you for commenting and watching. -Sven ✌️
I am able to create this exe file. But whn I try to input some data through the application, the data doesnt get appended in the xlsx file. Anything I am missing
WOW I am impressed. This video is friendly and right to the point. Love it. In 10 minutes I learnt more stuff than reading any book on this topic. Excellent Job!
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. Cheers, Sven ✌️
By far this is the best tutorial video I have seen, clear instructions, demonstrations in theory behind each concept and easy to follow bite size steps, learnt more in this short video then in some hour long ones. Thank you for taking the time to produce this and share your expertise with the Community
So happy to hear that you found the video helpful. Thank you very much for watching the video and taking the time to leave a comment! :)
What more can I add than what has mentioned many times before? Simply a FANTASTIC video!! Thank you for your wonderful contribution.
Loved reading your comment! Thanks for the support! 👍❤️
Love the voice/accent. Cross between a man child and very intelligent man. Love the vids too. Will sub
Hey Chris! Thanks for watching and subscribing, welcome aboard! 👍
This is a great video. I am a beginner at using python and coding. This will help me understand what a GUI is and allow me to create something nice for work. Thanks a lot!
Thank you for watching the video. I am glad to hear that the video was helpful. Happy coding! 😃👩💻
Awesome sir god bless you
You explained it simply amd effectively and more important clearly
Thank you sir 🙏🏻
Thanks for leaving a comment! Happy you enjoyed the video! 🙏
Pythons for business in a nutshell 🤯🤯 So many ideas to work with this base...thanks
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Most clear and cleaver video I've ever seen >>>>>> good job
Thank you very much! :)
@@CodingIsFun Although there is a problem i hope you can help me with , the script wont convert to .exe , whenever i tried it says (IndexError: tuple index out of range)
, dist folder is empty as well
everything is updated
i'm using Visual Studio and the script work fine with Visual Studio and from the Command prompt
I would really appreciate if you know the answer
Regards
Super impressed! Finally a clear demo of how to build a UI that writes to Excel via python. Thank you!
Hi Dennis G D! Happy to hear that you liked the video. Thanks for watching and taking the time to leave a comment! :)
One of the best tutorials I have seen. Thank you
Thank you!
I'm soooooooooooooo happy to see this. Much needed video. I was searching for this only.
Glad you found it. Hope it is helpful :)
This is top notch content ..hope you gain more subscribers
Thank you 😃🙏
i enjoy all your tutorials. this was the 4th i have followed along. i am learning so much
I am happy to hear that you have been finding the videos helpful. Thanks for taking the time to leave a comment and for watching!
Very well explained!! Thank you!
Glad you liked it. Thanks for watching. Cheers, Sven ✌️
As always, your content is pure gold!
Thank you for your kind words :)
Best tutorial on the net
Thanks for the kind words! I am glad you enjoyed it. 👍
This video is awesome. The concision, clarity and simplicity put in the explanations are impressive! Thanks and please do keep up!!!
Thank you so much for your positive feedback! I appreciate it! 😃
Hello Sven, I can just add another positive reaction to all the others you already received, WOW WOW what a great tutorial! Thanks for this amazing work and I guess the Python community should build a statue for you!
Regards, Frank
Hey Frank,
Thanks for watching and leaving such a kind comment! I really appreciate it. 🙏
I'm glad you found the tutorial helpful. Happy Coding! 🚀
Didn't know this was possible so easily. Very practical!
Thank you for watching the video, Florian. Glad it is helpful!
This is so fun, thank you so much! I'm happy I found this channel!
Happy to hear that you liked the video!
🤷♂️ Do you have any questions or need further support? Let me know in the comments 😃
Can you please make a tutorial on how to store inputs received from PyQt5 inputs to mongoDB??
@@dishangmehta4397 Thanks for watching the video & your video suggestion. Sounds like an exciting video topic. I cannot make any promises, but l will see what I can do.
@GYAAN TECH Thanks for watching the video. In the PySimpleGUI Cookbook, there is an example of how to save the input:
'Recipe - Save and Load Program Settings'
pysimplegui.readthedocs.io/en/latest/cookbook/
Regarding the multiline input box:
As mentioned in the video, please have a look at the 'Demo' folder. PySimpleGui offers the following widget:
sg.Multiline(default_text='This is the default Text should you decide not to type anything', size=(35, 3))
Combining this concept within a streamlit app [taking user input and recording into an excel spreadsheet] would be first class.
Thank you for watching the video & your suggestion.
Awesome work 😀
Thank you!
I am a novice, and I need guidance on how to install the Command Prompt. The Windows Command Prompt returns errors only. Thank you.
BTW. Great job! Straight to the point, and it is exactly what I needed. Regrettably, I am not a programmer and I have difficulties to install the tools to code and follow your instructions. Thanks again.
Thanks for watching. The actual error message would be helpful if you would like some guidance. Thanks! Cheers, Sven ✌️
Thinking about the many ways I could use this method.
Thank you so much for this. Please keep up the tremendous work.
This one's a real gem.
*I am glad you liked the video; thanks for watching and the kind words.* 😀
Super!!explained in a very simple way but very effective..so many things learnt in a such a small video!!great work sir!!
Happy to hear that. Thanks for watching and your kind words!
you just got another subscriber , this is so useful and relevant in my field of work . Just started out with python and your explanation is so clear and concise . Thank you brother.
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Good job on the video! Clear, concise and good presentation. I really like the code animations. Looking forward to watching more of your videos.
Thank you. Glad you like the video :)
Sorprendente, es un super video, breve claro, práctico y muy educativo. Muchas gracias
Thanks for the kind words! Glad to hear you found the video helpful and educational. 👍
Man I wish I'd found your channel earlier!!! This is super useful!!!
Happy to hear that you find the video useful! Thanks for watching and commenting! :)
i am python biggner,
thanks and more helpful
Glad you liked it. Thanks for watching.
Excellent video! Thanks for the help!!
Glad I could help! Thanks for watching! 👍
Bro you are great. You taught exactly what I needed. Love you man
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
Well done nice little video! Thanks for this!
Glad you enjoyed it! Thanks for watching and taking the time to leave a comment! 👍
Amazing tutorial and truly i am very much impressed for your knowledge and sharing such a beautiful content to Enthusiast Pythonist developers.
Happy to hear that you liked the video; thank you for taking the time to leave a comment and for watching the video! 👍
@@CodingIsFun sir not only liked your video, subscribed.as well
Wow you made that so easy to understand. This topic was intimidating for me being new to coding. Thank you for the vid :)
Glad to hear you liked it! Thank you for commenting and watching. 😃
This was beautifully taught.
Thank you.
Thanks for the kind words! I am glad you enjoyed it. 🤩
Wow .very nice video...thanks ..
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
This is very useful. Thanks Sven!
Thank you! Glad you like the solution!
Love it I already reply this project it work 🎉
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
Thanks a lot!
Is it possible for text fields to have text prediction, autocomplete?
Thanks for watching. You might want to check out the following GitHub issue:
github.com/PySimpleGUI/PySimpleGUI/issues/820
You explain really well. I’m feeling motivated to automate a task
Thank you for watching the video and taking the time to leave a comment. I am glad you liked the video.
What is amazing video, many thanks!
Glad you liked it. Thanks for watching and taking the time to leave a comment!
that was very well done! thanks for this! so glad i know about PySimpleGUI now!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
...wow..Very good video...thank...
Thank you! :)
Thank you❤, really appreciate your efforts
Glad you liked it. Thanks for watching.
Thanks for the video. I am going to start using this. Good work! Hope to see more tutorials.
Thanks for watching the video and taking the time to leave a comment! :)
Thanks for this great example.
An absolute pleasure, very happy to hear that you found it useful! 👍
Very beautifully explained....very informative
Thanks for the kind words! I am glad you enjoyed it.
This is seriously impressive. 👏
Thank you very much!
Xlent video.. ❤️simple and clear Sven..U shortened my learning with this video.. if possible.. please make video on update, search and delete options on this topic itself...which will enhance knowledge of ur followers. ❤️ My advanced wishes...
Thanks for your kind words & video suggestion! I appreciate it! :)
We have same opinion and waiting.
congratulations, thank you for sharing your knowledge
Thank you for watching the video and taking the time to leave a comment! 👍
Super,,, you are making our life simpler
*Hello nagendra vishwamitra, thanks for watching the video.* Glad it was helpful!
Sir, could you please give the code for pyinstaller --onefile--noconsole data_entry.py in jupyter notebook
@@nagendravishwamitra3652 The code would be the same - you could run it in a Jupyter Notebook cell, or do you get any errors?
Very Good!
There is a complete application with Save, Read, Update and Delete.
Thanks!
No, I do not have a 'complete' CRUD application.
@@CodingIsFun Great!
This is great! Thank you a lot!
My pleasure! Appreciate you taking the time to watch and leave a comment.
Thank you for the video. I was using the append with concat when I was trying Web Scraping, but it was very confusing when dealing with multiple page scrapes because I'm a beginner. I saw someone with pdf extraction use something called a namedtuple for combining values, and appending a list which is then put into a dataframe. That method seemed simpler to me.
Thank you for watching the video and taking the time to leave a comment!
Very helpful tutorial, thx a lot!
Thanks for the positive feedback! Appreciate you taking the time to leave a comment.
Awesome, thank you.
You're very welcome! Thank you for watching and for the comment!
Thanks for making this so simple to understand
Glad it was helpful! Thanks for watching the video & taking the time to leave a comment :)
This is great! I would like to know if we share the file and employees fill on their desktop if the information start updating on its own
Thanks for watching. Sorry, but I am not sure what you mean.
Great video, subscribed
Thanks for the sub! :)
I love your channel
It's very kind of you to say so, thank you! 🙏
THX! for the video, is there a use and input box to add numbers to multiple certain cell location within the CSV file? For the file I need to create, there is a value that need to input to multiple location within the CSV. So one input multiple output in different locations within the CSV.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Hello, thank you very much for the video and for the clarity of its message. May I ask you if there is any chance to import (in to excel file) only some data leaving the GUI as is?
Thanks for watching the video. Can you perhaps elaborate on what it is you're trying to achieve? Please provide some additional info. Thanks!
@@CodingIsFun Hello, thanks a lot for your quick reply. Much appreciated. btw, in your example, you consider five "element" of information (i.e : Name, City, Favorite color, spoken language and n° of children). my question is: is it possible to save in the excel file only some of them (e.g.: Name and n° of children)?
@@giovannitrivieri6722 You could remove the unwanted item/element from the "values" dict, e.g. using del values["City"] before exporting it to Excel.
Amazing tutorial. Thanks for your work. I have a question tho. What should I do if i need some of the fields of the excel file to be filled always with the same data?
I'll explain this. I have to worl with a boring CSV File in wich i have to manually fill only 2 or 3 cells, and the remaining (a total of 10 in a line) they have always the same data. A boring work of copy/paste for hundreds of lines. This will help me a lot if I could apply your teaching on my needs.
Thank you
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
thanks, i love it. the best for now
Thanks!
@@CodingIsFun why u dont use openpyxl?
@@achyarfauzan4880 No particular reason. You can also use openpyxl.
Great video Thanks for this, I have one question y supossed that when I share the exe file needs to be with the excel and has to be in the same path right? To change this path I could implement other window with option to change the path or the file to append data?
Thanks for watching. You are right. Currently, the application is looking for an Excel file in the same folder. Yet, you can select the Excel file dynamically by inserting the 'FileBrowse' Element:
pysimplegui.readthedocs.io/en/latest/call%20reference/
www.screencast.com/t/64AUEVrzN
I hope it helps! Happy Coding! :)
This is great. Is there a way to add images and host it locally?
Here are the docs regarding adding images: docs.pysimplegui.com/en/latest/documentation/module/elements/image/
I'm not sure what you mean by hosting it locally - sorry! Cheers, Sven ✌️
Hi is it possible to create a variable for a combo box? so would not have to adjust it in the code itself but on the variable only? I am new to this and still learning. Can this use by multiple users simultaneously? My worry is the possibility of overlapping. Thank you.
To store the "variable," consider creating a settings file like settings.ini to retrieve the drop-down values. This eliminates the need to modify the code. Check out this tutorial for guidance: ruclips.net/video/LzCfNanQ_9c/видео.html&feature=shares. To allow for simultaneous editing, use a storage format like Google Sheets or a database instead of a local Excel file, which can only be edited by one user. Best of luck and happy coding!
@@CodingIsFun Can I use Microsoft List? Thank you. I learned a lot from you!!!! Do you know any reference on how I can use MS List as database?
Another great video discover
Happy to hear that you enjoyed this one too! Thanks for the comments! :)
i have impressed with your tutorials .please show us save delete and edit button and report generation based on the saved data
Thank you very much.
For retrieving/editing data, have a look at the following short example:
ruclips.net/video/RnTqlKzQhRY/видео.html
I hope this helps!
amazing video, one of the most valuable 3min i spent on youtube.
would you show how we read combo information from mySQL db instead of hard code it in the program?
thanks
Thanks for watching the video. Happy to hear that you found the video valuable.
In essence, PySimpleGUI is 'just' used to create the GUI. If you want to manipulate a MySQL database, I would suggest coding out your pure Python script first (without GUI).
Once you got your CRUD (Create/Read/Update/Delete) functions in place (or whatever you want to do) when you can build the GUI using PySimpleGUI.
To get started with MySQL + PySImpleGUI, check out the following post: stackoverflow.com/a/622308
Happy Coding! 🚀
Thank you for this, I'll be using this as my base code, very simple to understand and follow along... Would it be possible for you to do a tutorial extending this with a pdf file viewer at the side of the entry form, I would like to make something like this but with two panes/section, 1 section for the data entry form and the other for viewing a pdf file... thank you!
Hey there, thanks for watching and for your kind words! I'm glad you found the tutorial easy to follow. While I might not create a specific tutorial for your use case, I encourage you to check out my advanced PySimpleGUI tutorial here: ruclips.net/video/LzCfNanQ_9c/видео.html. By combining the techniques from both tutorials and experimenting on your own, you should be able to achieve your desired layout with a data entry form and a PDF viewer. Good luck, and happy coding!
@@CodingIsFun wow that was fast, thanks for taking time to reply, I've already modified the code to include the fields I needed and it's working without errors, I have 0 knowledge of python and was trying to make something like this by asking Chatgpt but was not successful, your code just works! I'll be checking out the video you mentioned hopefully I could integrate the pdf viewer part successfully too, many thanks again...
This is great! Is there any way to add a field of day/date that would automatically update without having to input it each time?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thank you for the simple video and your code. If I want to change the color of the tab after user input is submitted, how do I do this?
Thank you for watching the video and for your question. Unfortunately, I do not know how to implement that right off the bat. I would also need to search the internet/documentation for a solution. Sorry that I cannot help!
@@CodingIsFun NP. Thank you.
Hello Man, The way you are explaining is excellent!!! Thanks a lot, Please tell me Do you have similar tutorial or code where Data Entry is My SQL intesad of excel? Thanks in advance
Thanks for watching. Nope, I do not have a tutorial on that topic.
Fantástic video. Thanks you very much. One question: what IDE you use? I'm using Visual studio code...
Thank you. In the video I used 'Atom'.
i learned a lot..thank you
Glad to hear that! Thank you for watching the video & taking the time to leave a comment 😃
Thanks for the helpful video! is it possible also to make some calculations before insert the data into the excel? How to do it? thks
Thanks for watching. Yes, it is possible to perform calculations before inserting the data into Excel. You can do this by manipulating the data in the "values" dictionary or the "new_record" DataFrame. Happy Coding!
Hello! Excellent presentation!
But I got a few questions.
How I Can add a timestamp in a separate Excel column every time someone click on Submit?
Thank you!
Hi Alex. Thanks for watching. I have created the following solution for you: gist.github.com/Sven-Bo/71251c76e3e3e7183dc6135b371f8c14
Hope you like it! Happy Coding!
Awesome. Thank you very much.
A pleasure! Thanks for watching :)
thank you for the video!
Thanks for watching the video & your comment. 😀
I was looking for a way to get data from and Excel file to use in an online web form filling. I've done this successfully using Power Automate Desktop but now I don't have a license. Looked at AHK but without the coding skill it's beyond my scope for now. Watched your video using chatGPT to write Python automation BUT I guess this is a bit more challenging as each input field needs to be mapped in Python. How deep would this be?
Excellent.
Thank you!
amazing video thanks a lot
Thanks for watching and your comment! :)
@@CodingIsFun can we set coordinates X,Y as an arguments to position an element like a text, a button or an input field ?
thanks
@@walidmat8972, I am not sure if that is possible. I quickly checked the documentation but could not find an option to set the x and y position. But perhaps I have overlooked something. Here is the link to the official documentation: pysimplegui.readthedocs.io/
@@CodingIsFun Thanks a lote 🙏
Subscribed! Thank you so much for the tutorial, I'm just a beginner in python but this really helped me building a simple database. It could be useful to upgrade the form allowing to modify the excel data once they are stored. Could you point me in the right direction? Thanks again!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
hi thanx for the tutorial i have a question the form stores the numbers as text in excel which command can i use to auto convert them to numbers in excel without showing errors?
Try to convert the input value (in the values dict) to an integer before exporting it to Excel. Happy Coding!
@@CodingIsFun can you help me please im stuck with it more than 8 hours.
@@CodingIsFun the form is the same as yours and it only has a number box (exactly like the name box you have) everything is working only i don't know how to convert the numberr
Very cool!!
Thanks! :)
Incredible! Is there a way to improve the ux?
Thanks! Sure, all customization options and elements can be found in the official PySimpleGUI documentation:
pysimplegui.readthedocs.io/en/latest/
@@CodingIsFun great! I’d like to send an email…would you type down here? I study IT at a reputed university in Brazil. I would love to have a talk to you. Thanks. - Mateus
@@mateusevangelista1282 pythonandvba.com/contact
Thank you for share knowledge.Please make same video for invoice genrater.(When we type items name it's show drop down)
Thank you for watching the video & your suggestion.
Hello Sven, I appreciate the video it immensely helped me navigate the pandas module. I have one question about pysimplegui. When I try to offline no console i can not execute the file. I get an error that states that my excel file is uncallable. How would I ensure my excel file is included in the offline program or even if i were to put the program onto another computer how would i ensure the spreadsheet is mapped correctly. Thank you for your help I hope to hear back soon.
Hi Colt. Thanks for watching. Happy to hear that the video was helpful. Regarding your question, please try the following (assuming you took the latest code from the GitHub repo:):
Remove: current_dir = Path(__file__).parent if '__file__' in locals() else Path.cwd()
Add: current_dir = Path.cwd()
..and try again. I hope it helps! Happy Coding!
Awsome,could you.also explain the code by wiritng how to avoid duplicate entries?
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
exzellent.
Glad you liked it. Thanks for watching.
Thanks for the fantastic video. This is really a cool program! I have gone through all the steps, but there must be something I am missing because I cannot get the excel file to update from the GUI... The path and code is correct, but the excel document does not update with the new info... Any clues to what I have done wrong?
Thanks for watching the video and your kind words. Do you get any error message when trying to run the program?
@@CodingIsFun No, it runs and gives the "data saved" checkbox, but no data is transmitted to excel...
@@fredriksolheim2051 Hm, that is strange. Hard to tell from a distance what the issue could be. Sorry that I cannot help here 😕
this is what I need. thanks man.
+1 subscriber from me
Great! Welcome aboard! :)