Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file

01:09 Using google sheets data as options for Autocomplete 08:23 Using MySql student table names as options for autocomplete We can collect data from different sources to create the list. This list is used to pickup the matching options for the Autocomplete based on the user input. This list can be prepared by taking sources from google sheets. How to connect and collect data from google sheet is here The same list can be created by using data from MySQL table, here we are reading names of our student table and the names we are selecting based on the matching string. This part is common to previous part of the tutorial but only the data source is changed from static list to MySQL records. Part I : Design , adding options and selection https://youtu.be/HulO1qiEn78 Part II : Navigation and selection by arrows https://youtu.be/QYeYi4LBpIU Part III : Different data sources, Pygsheets , MySQL database https://youtu.be/uKj4Py_At3w Part IV : Displaying all product attributes on selection https://youtu.be/c8DRdVDGV40 Part V: Using colour names as source https://youtu.be/RBKNM_uzGwg Source code is here https://www.plus2net.com/python/tkinter-autocomplete-source.php Connecting to google sheets and using google api authorization key https://youtu.be/LYAKsaUiDJI https://www.plus2net.com/python/pygsheets.php Connections and reading data from MySQL database using SQLAlchemy https://youtu.be/1V8Uf4XaQU4 Article on connection string to MySQL and collecting rows https://www.plus2net.com/python/mysql-sqlalchemy.php MySQL dump of student table https://www.plus2net.com/sql_tutorial/sql_student_dump.php #AutocompleteDataSource #PygsheetsDataSourceAutocomplete #OptionsMySQL #MySQLAutocomplete #DataSources #plus2net #Tkinter #Python

Видео Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file автора Молодые питонисты-виртуозы