Manipulate barcode input on a form?

I’m trying to create a form that can look up members of our organization by scanning the barcode on their ID card. The last 6 digits (ID number) of the barcode don’t change, but the first three digits to change when someone is issued a new card. So I can’t look them up with the whole barcode because I wouldn’t be able to find them if they got a new card.
My plan is to use the barcode scanner to search in a linked record, but I can’t figure out a way to have the form only pull the last six digits from the barcode scanner input. I know a formula could handle this easily, but the data would need to already be in a record to do that…
Is there any way to do this within the form itself?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.