Simple App (Windows OS or Andriod OS)
Budget: $30 – $250 USD
Sortation APP:
Can be Windows OS or Andriod OS based.
App connects to an airtable sheet
Sheet contains the following columns
Order ID
Item ID
of Items in Order
Ready?
Bin
Ready to Ship?
The process of the app will work the following way:
Operator will scan an Item( item ID)
Program will find the Item ID in the airtable sheet
Program will then find the ‘# of Items in Order’ and ‘Order ID’
Program will take ‘# of Items in Order’ (ex: 4) and attempt to find that many( in this example 4) unique numbers in the ‘Item ID’ that contain the same ‘Order ID’
if the program find the right amount (4 in this example), it marks the ‘Ready?’ column with a YES for all the items that contain the same ORDER ID then assigns it a bin number(1-100).
The program also looks for a “NO” in the ‘Ready?’ column of any of the rows that contain the ‘ORDER ID’.
IF found any NO in of the rows containing the ‘ORDER ID”, then it gets assigned ‘NO BIN’ in the ‘BIN’ column.
then assigns it a bin number(1-100).
The Bin number will go in the ‘Bin’ Column
the bin number ONLY gets entered in the rows that contains the ‘Item ID’ that the operator scanned. NOT all the items in the order
Once all items for that order have been placed in a bin. A pop up happens, saying “THIS ORDER IS READY TO SHIP. CONFIRM YOU REMOVED ITEMS FROM BIN” with a button that says CONFIRMED
Once that button is pressed, all the bins in the Bin get an update in the ‘Ready to Ship?’ column with a “Y”
** NOTE: ONLY 1 Order ID can be assigned a bin at a time**
IF the program does NOT find the total amount of unique ITEM ID that match the “# of Items in Order”, then the item gets a NO in the ‘Ready?’ Column and it gets Assigned “NO BIN”
When an item gets assigned a Bin or a No Bin, a popup happens and the Bin # or NO BIN appears. User has to press ok button to get out of the screen
If program doesn’t find the item in the airtable, it gets assigned an ERROR BIN
Here is an example of the Airtable: https://airtable.com/shr6Ew92Jufz7VbJa/tbl7pKuONCRIjNnqf
Can be Windows OS or Andriod OS based.
App connects to an airtable sheet
Sheet contains the following columns
Order ID
Item ID
of Items in Order
Ready?
Bin
Ready to Ship?
The process of the app will work the following way:
Operator will scan an Item( item ID)
Program will find the Item ID in the airtable sheet
Program will then find the ‘# of Items in Order’ and ‘Order ID’
Program will take ‘# of Items in Order’ (ex: 4) and attempt to find that many( in this example 4) unique numbers in the ‘Item ID’ that contain the same ‘Order ID’
if the program find the right amount (4 in this example), it marks the ‘Ready?’ column with a YES for all the items that contain the same ORDER ID then assigns it a bin number(1-100).
The program also looks for a “NO” in the ‘Ready?’ column of any of the rows that contain the ‘ORDER ID’.
IF found any NO in of the rows containing the ‘ORDER ID”, then it gets assigned ‘NO BIN’ in the ‘BIN’ column.
then assigns it a bin number(1-100).
The Bin number will go in the ‘Bin’ Column
the bin number ONLY gets entered in the rows that contains the ‘Item ID’ that the operator scanned. NOT all the items in the order
Once all items for that order have been placed in a bin. A pop up happens, saying “THIS ORDER IS READY TO SHIP. CONFIRM YOU REMOVED ITEMS FROM BIN” with a button that says CONFIRMED
Once that button is pressed, all the bins in the Bin get an update in the ‘Ready to Ship?’ column with a “Y”
** NOTE: ONLY 1 Order ID can be assigned a bin at a time**
IF the program does NOT find the total amount of unique ITEM ID that match the “# of Items in Order”, then the item gets a NO in the ‘Ready?’ Column and it gets Assigned “NO BIN”
When an item gets assigned a Bin or a No Bin, a popup happens and the Bin # or NO BIN appears. User has to press ok button to get out of the screen
If program doesn’t find the item in the airtable, it gets assigned an ERROR BIN
Here is an example of the Airtable: https://airtable.com/shr6Ew92Jufz7VbJa/tbl7pKuONCRIjNnqf