[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: [libreoffice-users] Base...
- From: zed <firstname.lastname@example.org>
- Date: Wed, 5 Feb 2020 07:06:09 +1300
- To: email@example.com
Using LibreOffice v126.96.36.199 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
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
Table 3 - Performance
Title (this eill be the title of a song, or a dance routine, or a piano
Table 4 - Location
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
Have I designed the Tables to be too complicated, too simplistic?. Could any
of the tables be combined?
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.
"Opportunities multiply as they are seized.: Sun Tzu
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|Re: [libreoffice-users] Base...||Robert Großkopf <email@example.com>|
- Prev by Date: [libreoffice-users] Collabora rest communication
- Next by Date: Re: [libreoffice-users] Base...
- Previous by thread: [libreoffice-users] Collabora rest communication
- Next by thread: Re: [libreoffice-users] Base...