Personality form without a table?

Creating and using forms

Personality form without a table?

Postby Caters » Tue Jul 26, 2016 9:05 am

I am wanting to make a personality form in Base.

I am wanting it to be like this:
Basics(category):

Questions(full response(like for name, general appearance, etc.) and multiple choice(like weight category) and mixture(like illness and if so what illness)

Physical(category):

Mostly full response. Some multiple choice(like for example muscularity index(a scale from -3 to 3 to generalize appearance))

Social:

Mostly full response but some multiple choice and mixture(relationship, children, job if any etc.).

Other(might categorize this later):

Like social but includes things like habits, hobbies, and other less important stuff.

Anyway I am wanting to do this without a table if possible(since you can't have multiple choice above yes/no in a table and I want that).

I already have a table with the most important characteristics but I can't make a table that would potentially have hundreds of questions.

This is for my characters. Now I realize I could program this in something like Python or JavaScript but I want to know if there is a way to do it in OpenOffice. If not then I will code it. You can look at the signature to see what I am using.
OpenOffice 4.1.2 on Windows 10
Caters
 
Posts: 16
Joined: Tue Jul 26, 2016 8:46 am

Re: Personality form without a table?

Postby UnklDonald418 » Tue Jul 26, 2016 6:58 pm

It sounds like what you are attempting definitely would be in the realm of a database. It also sounds like you have some misconceptions about what can be stored in a database table.
(since you can't have multiple choice above yes/no in a table and I want that).
I can't make a table that would potentially have hundreds of questions.

Actually just about anything that can be digitized can be stored in a database table (and probably is somewhere). However, this would not be an easy project.
You might start by reading more about databases.
Here is a link to the Apache OO documentation library
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/OOo3.3_User_Guide_Chapters
in particular
https://wiki.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf
and more up to date user guides can be found at.
http://www.libreoffice.org/get-help/documentation/
There is also a good tutorial on database design at
https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1326
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Personality form without a table?

Postby UnklDonald418 » Tue Jul 26, 2016 10:32 pm

Upon further consideration you might be able to accomplish that with as few as 3 related tables.
already have a table with the most important characteristics

would be one table.
Another table
that would potentially have hundreds of questions

this would contain all the possible questions and a Primary Key field that would be used to link to a
third table that would contain responses to the questions and also include links to each of the other tables. There would be a one to many relationship from your existing table to the responses table, and a one to one relationship between the responses table and the questions table.
The tricky part would be designing a form that could display all that information, but a table or two on the form might work.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1326
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests