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
• Tkinter Autocomplete by using Entry and Li...
Part II : Navigation and selection by arrows
• Tkinter Autocomplete using down up arrow t...
Part III : Different data sources, Pygsheets , MySQL database
• Tkinter Autocomplete options using date so...
Part IV : Displaying all product attributes on selection
• Tkinter autocomplete retrieving other matc...
Part V: Using colour names as source
• Tkinter autocomplete to browse and select ...
Source code is here
https://www.plus2net.com/python/tkint...
Connecting to google sheets and using google api authorization key
• Authorization through Google drive API to ...
https://www.plus2net.com/python/pygsh...
Connections and reading data from MySQL database using SQLAlchemy
• MySQL SELECT Query in Python using fetchal...
Article on connection string to MySQL and collecting rows
https://www.plus2net.com/python/mysql...
MySQL dump of student table
https://www.plus2net.com/sql_tutorial...
#AutocompleteDataSource #PygsheetsDataSourceAutocomplete #OptionsMySQL #MySQLAutocomplete #DataSources #plus2net #Tkinter #Python
On this page of the site you can watch the video online Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file with a duration of hours minute second in good quality, which was uploaded by the user plus2net 03 January 2022, share the link with friends and acquaintances, this video has already been watched 1,185 times on youtube and it was liked by 22 viewers. Enjoy your viewing!
