Hi, y'all!

I've just put up a blog entry detailing the database system that I'm developing to track and analyze my production data.

http://blossommerz.com/blog/index.php?id=3365515089016235884

I'd love to hear feedback from other people on how they track data. What information do you track? How do you use it? Is a system like the one I'm creating of interest to other weavers?

Be well!

Blossom Merz

 

PS: I guess we'll have to wait for a forum bug to get worked out before people can respond. I didn't lock this topic, and I don't see any option for unlocking it...

Comments

NancyD (not verified)

 I like your layout. I was able to recreate it in Bento. This is a great data program and very inexpensive.

blossommerz (not verified)

 Hi, Nancy!

Sorry for the long delay. I've been weaving long days the last few weeks and haven't had time for online stuff much.

I use Bento, too. It's so easy to use and nice looking! I love it for simpler databases, but it just can't handle all the complexity of this one. The big difference is in the "relational" nature of the FileMaker databases. You only enter each piece of data once in the appropriate place and then link to it from other places.

For example, each Piece has its own data. When I'm filling out a Timecard, I just use a pulldown menu to select the right Piece, and all the rest of the data is linked in, too. The Piece knows what Project it's part of, so that data is linked in automatically, too.

The Timecard can even ask the related Piece a question like, "including this Timecard, what is the total number of hours that have been put into this Piece? Based on the final sale price for this Piece, how much am I making per hour?" These answers are displayed in the "Piece Totals" section on each Timecard.

If you've created weaving databases in Bento, I'd love to see some! I'm always interested in seeing what kinds of data other people track and use.

 

Submitted by Anonymous (not verified) on