Using LibreOffice v6.0.7.3 on Linux Mint v19.3 Mate A few months ago, members kindly helped me with the format of cells in a spreadsheet. I know wsnt to convert thst informstion to Base.
My knowledge of databases is very limited. The only practical experience I had was way back in the 1980s when I used Paradox. Haven't constructed a database since and have forgotten whatever limited skill I had. So your MISSION - should you choose to accept it is to advise me whether the suggestions I make below are reasonable or ridiculous. I won't be offended if your opinion is to the latter because I need all the help I can get. I follow the career of several performers - singers, dancers and instrumentalists - through their Youtube videos and also record the number of Reactions to those performances. At present I have a spreadsheet of information applicable to the Reactors. There is a spreadsheet for each performer. It has 9 columns A. ID B. Name <text> C. Gender <text> D. Number of reactions done <number> E. First reaction <date> F. Last reaction <date> this is the most recent reaction G. Days - Formula =NOW() <cell ref> H. Weeks - = <cell ref/7> I. Months = <cell ref/4) This has worked very well but now I want to be able to gather more information using just Columns A, B, C. So, what I can gather from reading the Getting started instructions for Base, I need more than one Table. Are those listed below suitable. Table 1 - Reactors ID Name Gender Table 2-Performers ID First name Last name Table 3 - Performance ID Title (this eill be the title of a song, or a dance routine, or a piano concerto, etc. Date upload Website Table 4 - Location ID Studio Concert - open air Concert - Hall Now what do I want to achieve. Be able to generate various reports using the Tables listed above For example I create a Query in the form Print All reactions by <name of reactor> of songs sung by Angelina Jordan, showing title, date of reaction, date uploaded, location of performance. Print all songs sung by Patricia Janeckova showing title of son, date of upload, website, location. Print all concert - open air by Laura Bretan, showing date, title of performance, website Have I designed the Tables to be too complicated, too simplistic?. Could any of the tables be combined? Last questions. Is it possible in bsse to use the type of calculations used in Columns G, H, I in the spreadsheet. To save typing the salmost 200 names and details of Reactors, what is the essiest wsy to export them to BGSSE. David -- Zed "Opportunities multiply as they are seized.: Sun Tzu -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
