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
Nesta página do site você pode assistir ao vídeo on-line Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário plus2net 03 Janeiro 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,185 vezes e gostou 22 espectadores. Boa visualização!
