So I am trying to make a table where we have all the different products we sell on a weekly basis. At the end of the week I want to input the number of each product sold under that products field. That’s the easy part I think. But how do I enter new numbers each week while not erasing the old ones while simultaneously adding the numbers I put in every week to a master table that just shows the number of products sold by each rep.
Hi @Derek_Dimmick, and welcome to the community!
The records representing each product’s sales are for a given period; it’s not like an inventory table, right? If so, you simply create new records for every new period, thus sustaining the counts for each product and each week.
Thank you for your response. I’m trying to follow along. When I think I understand, I try it on my table then I get even more confused. I’ve read the articles on the rollup, grouping, linking and a lot of others. I am still so confused.
What I’m trying to do should really be simple. I have about 15 reps that sell a number of different products. We count the products/sales weekly and keep track of it as such. However I want to be able to input the numbers/sales for each week for each product by each rep. Then those numbers essentially stay there only because I want to keep track of the monthly numbers and YTD numbers as we progress.
Thanks Bill. Here are some screen shots. The one titled MedSup Board is laid out the way I want it. However the MedSup #'s can be laid out anyway to get the best possible solution. Maybe I don’t even need 2 tables. The only reason I do is because the MedSup board will be shown on a TV, so the whole team doesn’t need to see the other table. Hope this helps.
Yep - makes sense.
Given data like this in MedSup #'s…
You want to reveal analytics something like this in MedSub Board, right?
How’d I Do This?
The key to this is the link from the board to the detail records and the rollup fields. It is almost certainly not the most elegant way to do this, but I’m not the uber-skilled roll-up expert on this forum. I just happen to me bored waiting for family and I saw this question and had only a little time to play with this.
Sorting and grouping are used to make it all purdy.
Yes, almost everything you can imagine is possible. Is it possible in Airtable? That’s a deeper question. But one thing is certain, if you are unable to mimic the approach I showed, you probably need some training. I recommend reaching out in this thread to ask if there are any experts who can provide hands-on training to help you implement your vision.