user26927

Calculation Help

Discussion created by user26927 on May 11, 2016
Latest reply on May 11, 2016 by erolst

Hello

 

I have the following fields on a table:

  • Bin Number
  • Shelf
  • Row
  • Position

 

The bin number corresponds to the shelf, row & position where the bin is physically located.

For Example-

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.

Outcomes