Hello All,
I am trying to create a app where if an person scans a value in Datacardvalue4 ("PT0054-SERIAL NUMBER"), I want the text box to populate the text "Front".
Also the datacardvalue4 ("PT0055-SERIAL NUMBER") then the text would be "Rear".
Also the serial number changes for every part and the PT0054/PT0055 Will be common. So can someobody help me write a lookup function where it looks for just the first 5 digits and if the condition is met then populate the text box as Front/Rear.
