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?
