CRM App With Treeview and SQLite3 - Tkinter Projects 16

In this video I'll show you how to use the Treeview Widget in Tkinter to build this cool CRM Database app.

We'll use the Sqlite3 database for the project.

We'll be able to add records, update records, delete records, move records, search records, and more.

We'll also create a color changer tool that can modify the striped row colors in the treeview.

#tkinter #codemy #JohnElder

Timecodes

00:00:00​​ - Introduction
00:03:19 - CRM Treeview App
00:26:50 - Add Functionality
00:47:30 - Connect Treeview To Database
01:04:14 - Primary Key
01:15:20 - Update Record
01:24:42 - Add New Record
01:32:52 - Delete Single Record
01:40:56 - Delete All Records
01:52:05 - Delete Selected Record
02:07:15 - Color Chooser
02:19:55 - Search Database
02:33:59 - Color Config File
02:49:36 - Conclusion

[TkinterPython]

▶ Watch TTKBootstrap Playlist ✅ FREE Tkinter Widget Book
▶ See More At: ✅ Subscribe To My YouTube Channel:
▶ MASSIVE TKINTER.COM DISCOUNT ✅ Join My Facebook Group:
▶ Get The Code For This Video ✅ Watch The 200 Video Tkinter Playlist

[PascalChapier]

Many thanks for this video, I learned a lot.

If you are still looking for idea, you could add a sort function triggered when the user click in one treeview header:
- first click in one header sort the record according to the colume content in ascending direction,
- second click sort in descending direction and so on.
- Click in a different header cell will restart by ascending sort for the new column selected.
- The state is not preserved for the next program run.

[JoaoNeto-ojcn]

This data editing solution is very good, thank you very much for sharing these solutions. However, when it comes to DateEntry in the ttkboostrap package I can't get it to work. The date field does not show the record date and keeps the default date. The same happens with cleaning this field to edit a new record. What solutions can you suggest to solve this problem?
Working dates in a database is not easy, at least for me.

[moris]

Thanks, great job. If you want I have more ideas for this channel, for example some applications when we can mark a place on Google maps and put some description for example for delivery company or interest place and share online. What you think?

[makhlouflazhar]

Thanks in advance,
I would like you to give us an example of extracting a PDF file from the database by exploiting data from the database

[biotyana]

can you do the same project with ttkbootstrap

[davidsbdavid]

Hi, good job. Is there a way to get the files used in the live?

[tomkmb]

Is it possible to add numeric filtering to the columns in Tkinter?

[vladmakrov]

Nice job Sir. Thanks. Where can i find the source code?

[manfredbaum]

I do not find the code. Where is it. Excuse my bad english

[lemartien]

Invalid column index ???? When running this code I got the following error: Invalid column index. This happens in the treeview column definition. is this a problem in python interpreter I should reinstall python? I have version 3.12