I have the following fields on a table:
- Bin Number
The bin number corresponds to the shelf, row & position where the bin is physically located.
Bin A11 is on SHELF A, ROW 1 POSITION 1
BIN A21 is on SHELF A, ROW 2 POSITION 1
BIN A22 IS ON SHELF A, ROW 2, POSITION 2
Is there a way to make the shelf, row and position fields calculation fields that will get the information from the bin number field?
Shelf would always correspond to the 1st character in the bin number field.
Row would always correspond to the 2nd character in the bin number field.
Position would always correspond to the 3rd (last) character in the bin field.
The bin number field will only be 3 characters always.
I don't know if this should be a calculation or script.