[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[libreoffice-users] Base...


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: users+unsubscribe@global.libreoffice.org
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

Follow-Ups:
Re: [libreoffice-users] Base...Robert Gro├čkopf <robert@familiegrosskopf.de>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.