I've read the tutorial "Working with Lists and TinyDB" but it's still not clear how to adapt it to my needs. So I ask for help:
I want to create a database on Tinydb with three fields ("text" and not "numeric"): each element of the first two fields comes from entries contained in two different spinners and the third from a textbox (Example: Type, Subtype, from spinner and from textbox the "Explanation")
To enter data into the database, article by article, how do you recommend writing the code?
Then, to "search" the data of my interest in Tinydb, using both previous spinners at the same time (this will allow me to search for a precise, unique, memorized value) to read the third element, that of the textbox (the inserted element above with the textbox as "Explanation"), again, how do you recommend setting the code??
Thank you
what part of the code do you want it to show?
I got correctly Spinner 1 Selection, Spinner 2 selection and I have the textbox ready to write on.
If you want I can send .aia
(I have used the label just to display the content of the stored list of lists, you would work with global db and update it to tinydb EVERYTIME you make a change - as is shown in the Button1.Click event)
Dear Timai2 I think you understand exactly what I need. Now I'm not near a computer: so in a few hours I'll sit down at my desk and try your suggestion.
Meanwhile I read and study your code to understand my mistakes. (I'm a beginner eager to learn)
I feel like goats inserting data into TinyDB with button 1; and with button 2 I should get the total database list;
If so, can you suggest me how to set up the spiner1 + spinner 2 combined search to get the label of the text that I had entered via the textbox?
PS
Dear Tomai2 your suggestion for the three spinners you gave me for the other app worked great. I hope one day by continuing to follow you, to become "a little good"
I just sat in front of my computer: I have an hour free and I dive ... I'll start trying right away and I'll let you know; Tonight I will have the right time to work and totally modify my app. But with your suggestions I'm "sure" that everything will be fine
Help: dear Timai2 I started to insert, adapted, your code. However, I can't find the green "end" with two joints
I apologize but last night I could not have time to get on the computer . This morning I got up earlier and I adjusted the suggestion of Timai2 for memorizing the various voices and ... Everything works perfectly. . 1st thanks to Tomai2 . Around lunchtime I will go home and proceed to adapt the request with the two spinners; but I'm already sure I'll add to Tomai2 the 2nd thanks
@TIMAI2 Dear Timai2, I'm "arguing" with your suggestion of the "button 3", the one for the search through the two spinners to get from the label the corresponding text I entered previously with the textbox: I receive the error instead: "The operation is in list?cannot accept the arguments". I can't find my error...
. This morning I got up earlier and I adjusted the suggestion of Timai2 for memorizing the various voices and ... Everything works perfectly. . 1st thanks to Tomai2 
. Around lunchtime I will go home and proceed to adapt the request with the two spinners; but I'm already sure I'll add to Tomai2 the 2nd thanks 
