Sewing Databases?

This topic contains 8 replies, has 5 voices, and was last updated by  Rebecca Hamilton 3 months ago.

  • Author
  • August 23, 2015 at 10:55 AM #14501

    Judy Batson


    Based on a recommendation found on the Colette Sewing Blog, I purchased Tap Forms, but I have yet to figure out how to set up usable databases for my hundreds of sewing patterns. A couple questions:

    Does anyone have a template for such a database to share?

    Is it possible to scan bar codes into Tap Forms to get info from a pattern envelope?

    I’d really love to USE the Tap Form app since I bought it, but thus far, over a year later, have only tinkered with it on my laptop and haven’t figured out a way to make it handy on my iPhone for reference when I need to check if I already have the pattern or to find out what sort of fabric to buy and how much is needed.

    Thanks very much!


    September 3, 2015 at 9:59 AM #14576

    Trey Childs

    Hi Judy,

    If by barcodes you mean Universal Product Codes (UPCs), then you wouldn’t get much more than the product name. Still, you could search off of a product code to see if you have it in the database. It’s possible to get all of the UPC information available (outside of TapForms) for any codes you have and use it as an import file. This would help you identify if you already have the pattern. There is a UPC lookup website where you could enter a few codes and see if it is descriptive enough for your needs. If you decide that you need hundreds of codes processed that way, let me know.

    Any fabric info would have to be entered in or associated for each item. I would only add that kind of detail as needed.

    I’d like to know more about what you’ve tried so far and see if I can help. Have you contacted the person who posted the recommendation on the sewing blog? Perhaps you could get them to export a template for the structure they use.

    September 6, 2015 at 9:22 PM #14589

    Nan Auhll

    Can you explain the fabric info in more detail?

    I have set up the template that I like, but I would like to add all the fabrics that the pattern uses. Some times it could be more than 6.

    September 7, 2015 at 6:30 PM #14599

    Trey Childs

    So you could have several fabrics, of different types, colors, lengths, etc… For the most part, I’d guess that it’s fairly specific to the pattern. It sounds like that could be accommodated with a link to another form, one to many, and hidden from the usual display. Let’s call that form “Fabrics.” You could add as many or as few records for fabrics to a single pattern, for each pattern.

    With a fabrics form, linked to your patterns, you could specify a description, length, cost per yard, number of yards, and a calculated cost for each fabric. The sum of the fabric costs could be shown on the main pattern form, with a “tokenize” function.

    The fabrics would have to be entered manually, unless someone has a more clever idea to import records into the fabrics form and associate them to patters, one to many.

    Does this help?

    May 10, 2016 at 2:50 AM #16595

    Rebecca Hamilton

    I know this is an old question, but in case you’re still looking, here’s what I did.
    I set up a form with photo fields for the views from the envelope. Then, I created a field for each of the following: pattern company, pattern number, pattern description (i.e., shirt,skirt,dress or whatever.), fabric type, yardage, notions, winter, summer, autumn/spring. I created photo fields for the fabric I bought and intend for it, but that’s not really a pattern thing, just a way to keep track of my workflow.

    You can create fields for anything you want.

    Hope this helps.

    February 18, 2017 at 6:53 AM #21192

    Wendy Farkas

    Rebecca, would you be willing to share your template so I could have a head start in my database development?

    February 18, 2017 at 7:03 AM #21193

    Rebecca Hamilton

    Sure, I’d be happy to. I’m not in a place where I can right now. Would you mind pinging me again on Monday? I’m not likely to remember otherwise. I’ll do it then.

    February 20, 2017 at 1:22 PM #21222

    Wendy Farkas

    If it’s not too much trouble, I’d like to see what you created. Thanks.

    February 21, 2017 at 8:31 PM #21233

    Rebecca Hamilton

    Apologies. I forgot to do this yesterday. This is the template for my sewing pattern database. I use it all the time. It has 245 patterns in it. When I’m out shopping for fabric, I use it on my iPhone to know what to buy for whatever pattern I’m making. It has a number of fields in it that are idiosyncratic to me, the way I work, etc. Hope it helps you get going.

    I’m also including the databases I use to keep track of my fabric stash and various presser feet, etc, for my machines. Again, these are very individual, since they are for my use alone.

    You must be logged in to view attached files.

You must be logged in to reply to this topic.