Tracking tasks and versions


#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 :slight_smile:
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? :slight_smile: thanks


#2

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)


#3

thank you!
I have to try to understand :slight_smile:
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…