Is there a way to identify the oldest unit in our inventory based upon serial #?

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
In a QuickBase Inventory Management app, we want to add an icon or indicator to identify the oldest unit based upon the serial number.  

When a parts customer calls for a specific part number we search for a specific part number, and we usually have several items of that part number on the shelf.   We want to sell the oldest unit according to the serial number. 

Is there a way that QuickBase can somehow indicate which unit is the oldest?

Thanks, 

Jim
Photo of JimLieder

JimLieder

  • 344 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Do your serial numbers grow with the newer units?  If so, you can sort them accordingly to display the oldest on the top.  

Depending on how your system is set up, if you have a "Parent" item for all those individual items in inventory, you can summarize the 'smallest' serial number, and display that on the parent.  Or use that value to highlight said record.

Its hard to tell exactly what direction you'll need to go, unless you have more information for us about the current application structure and flow.

Cheers,
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Just to elaborate on Mathew's answer, if you then lookup the smallest serial back down to the units table, then you can use simple row highlighting 

if([serial] = [min serial lookup],"yellow")
Photo of JimLieder

JimLieder

  • 344 Points 250 badge 2x thumb
Thank you Matt and Mark.  Both answers are helpful and I'll try it out.