Quick Base Discussions

Expand all | Collapse all

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

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

    Posted 04-04-2017 02:27
    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


  • 2.  RE: Is there a way to identify the oldest unit in our inventory based upon serial #?

    Top
    Contributor
    Posted 04-04-2017 02:39
    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,


  • 3.  RE: Is there a way to identify the oldest unit in our inventory based upon serial #?

    Posted 04-04-2017 02:54
    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")


  • 4.  RE: Is there a way to identify the oldest unit in our inventory based upon serial #?

    Posted 04-04-2017 21:45
    Thank you Matt and Mark.  Both answers are helpful and I'll try it out.