Creating a self populating check list

Discuss the database features

Creating a self populating check list

Postby julesverne » Tue Aug 08, 2017 10:24 pm

Hello, I'm fairly new to OpenOffice and was wondering if I could get some help creating some forms for work. I am trying to create checklists for solar electrical systems, ideally I'd like to be able to open a document and select multiple terms from a list (for example: fuses, breakers, glands, continuity test, batteries, etc.), and then have those automatically populate a form with the terms and a description of what that term entails. For example if someone selected fuses, glands, and continuity test, they would get a form like:

____ Fuses: make sure fuses are the proper amperage
____ Glands: installed in the proper location and tightened securely
____ Continuity Test: Make sure wire leads have proper continuity and polarity does not cross

Thank you in advance!
OpenOffice 4.1.3 on Windows 10
julesverne
 
Posts: 3
Joined: Tue Aug 08, 2017 10:06 pm

Re: Creating a self populating check list

Postby jrkrideau » Tue Aug 08, 2017 11:15 pm

I'd suggest taking this over to the Base forum. It seems very clear that the best tool for the job is a data base.
LibreOffice 5.1.4.2 Ubuntu 17.04 "Zesty Zapus"
jrkrideau
Volunteer
 
Posts: 3375
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Creating a self populating check list

Postby julesverne » Wed Aug 09, 2017 9:28 pm

Will do, appreciate it
OpenOffice 4.1.3 on Windows 10
julesverne
 
Posts: 3
Joined: Tue Aug 08, 2017 10:06 pm

Re: Creating a self populating check list

Postby Villeroy » Fri Aug 11, 2017 1:03 pm

Database design has nothing to do with OpenOffice. It is the same art you have to master for any type of relational database.

So you mentioned 3 attributes to store. There might be a lot more. I can think of
who? some technichian
where? some project, client, location which required the logged action
when? possibly an (automatic) time stamp
bundles of what? actions could be bundled, e.g. bundle A implies actions x, y and z

Not considering all the items that need to be stored leads to trouble. A relational database is difficult to change once you started populating the structure with real data.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24650
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Creating a self populating check list

Postby UnklDonald418 » Sat Aug 12, 2017 11:01 pm

I uploaded a simplified demonstration database with a 4 tables and 3 forms based on my understanding of what you want to accomplish.
It should give you an idea of how a database might be used to solve your problem.
Attachments
Demo11WorkOrder.odb
(30.63 KiB) Downloaded 21 times
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 587
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 5 guests