Does anyone have any advice for how to create a filtered view of data I have that only keeps the oldest date of a “group” of records? I have a table where a product iD can show up multiple times but have different data for it depending on another unique field (a batch of the product). But, I need to have a view that only keeps the oldest batch. I have a date field attached to each batch. Any ideas?
Hi @Justin_Eppley ,
Are the batch date fields a Look Up in the Products table?
If so add a roll up to the date field of batches in Products and apply the MIN(values) formula to it. This should only return the oldest date of batches.
Hey Justin, I think you’ll need to:
I’ve put something together here that should solve your problem
Hi @Adam_TheTimeSavingCo thanks for the workup in Airtable. I feel like I’m woefully inexperienced so just grasping the rollup concept completely took me a bit of time but I’m not sure how to replicate your suggestions and I’m now just squinting too hard… haha
Here is what my data looks like:
Unfortunately, I’m not looking up the data from anywhere here and it seems like the solutions being put forward require a linking field (e.g., for the roll-up). Am I likely missing something blatantly obvious here? In the case of the data I’ve selected to show here, I would want to only retain record 59, as it is the same product ID (different batch) with the oldest date.
Hopefully this helps illustrate a little more of my particular setup or something will click on my end with the solutions put forward. Thanks to you both.
Hey Justin, yeah, the idea is for the product IDs to be in a table on its own, and to link the batches to the product ID it belongs to.
With reference to the image, your primary field appears to be the Product ID value, so the steps below assume that that’s the case
Let me know if you face any issues. You can also just DM me an invite link and I could do this up for you real quick
Hey @Adam_TheTimeSavingCo … thanks for spelling this out. I think this won’t be a “tenable” solution for us as we are pulling in this data via API and refreshing it every 15 minutes. I would likely need to put all those steps into a script I think in order to have it all automated. I am working on trying to figure out a workaround. I’ve been able to work with the company who provides the API to get the lab data into a call of its own (when I pull in the rest of the product data it comes with) Headaches of its own I need to figure out now… haha… thanks again.
Hm, those steps are for base set up and would only need to be done once per base. Are you creating a new base every time you do a data pull? If so, yeah, I guess you’d need to automate the steps