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
Question
Is there a way to identify the oldest unit in our inventory based upon serial #?
+5This topic has been closed for replies.
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,
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,
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")
if([serial] = [min serial lookup],"yellow")
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.