Skip to main content

Tracking tasks and versions

  • August 29, 2017
  • 2 replies
  • 28 views
Z
Forum|alt.badge.img+1

I don’t see through how I should set this database up:
I have and Etsy shop, I create printables. I want to track - what have I done with these - created, description written, cover created, uploaded… etc. this is not complicated :slightly_smiling_face:
But I also want to know what I should do. different versions of:

  • sizes
  • paper to print (A4 or A5 etc)
  • versions in the insert itself - like grid, lines, blank…

As an example, I have a Day on 2 page insert with grid, then I want to create it in A5, personal, A6 and pocket size. With the possibility to print on A4, A5, personal paper.

Any idea? :slightly_smiling_face: thanks

    2 replies

    Y
    Forum|alt.badge.img+14
    • Y_K
    • Known Participant
    • August 29, 2017

    Can you elaborate more maybe with a link to examples on your website?

    It looks like you’re trying to list all possible combinations of size / paper / version that you can do? Assuming you are, here is what I would do:

    Create a table: Sizes, with columns Size Name, Notes etc.
    Size Name has rows: A5, Personal, A6, Pocket Size

    Create a table: Grid, with column Grid Name
    Grid Name has rows: Grid, Lines, Blank…

    Create a table: Papers, with column Paper Name
    Paper Name has rows: A4, A5, …

    Then, you create a table called Task, with columns: (the first 3 columns link to the 3 tables above)
    Size Name
    Grid Name
    Paper Name
    Created Time
    Description Written
    Cover created (tick box)
    Uploaded (tick box)

    Then you can just filter / sort this last table to view your tasks (assuming my assumption is correct)

    Z
    Forum|alt.badge.img+1
    • Zsuzsa_Kiss
    • Author
    • Participating Frequently
    • August 29, 2017

    Can you elaborate more maybe with a link to examples on your website?

    It looks like you’re trying to list all possible combinations of size / paper / version that you can do? Assuming you are, here is what I would do:

    Create a table: Sizes, with columns Size Name, Notes etc.
    Size Name has rows: A5, Personal, A6, Pocket Size

    Create a table: Grid, with column Grid Name
    Grid Name has rows: Grid, Lines, Blank…

    Create a table: Papers, with column Paper Name
    Paper Name has rows: A4, A5, …

    Then, you create a table called Task, with columns: (the first 3 columns link to the 3 tables above)
    Size Name
    Grid Name
    Paper Name
    Created Time
    Description Written
    Cover created (tick box)
    Uploaded (tick box)

    Then you can just filter / sort this last table to view your tasks (assuming my assumption is correct)


    thank you!
    I have to try to understand :slightly_smiling_face:
    you say, the tasks table will generate me all the combinations?
    my etsy shop: https://www.etsy.com/shop/PlanCademy - but there are only a few things uploaded…

    Terms & ConditionsAccessibility statement