Forum Discussion

JimLieder2's avatar
JimLieder2
Qrew Cadet
8 years ago

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

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
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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,
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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")
  • JimLieder2's avatar
    JimLieder2
    Qrew Cadet
    8 years ago
    Thank you Matt and Mark.  Both answers are helpful and I'll try it out.