Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Manipulate barcode input on a form?

Topic Labels: Views
179 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

0 Replies 0