Newbies spgarris Posted May 27, 2011 Newbies Posted May 27, 2011 Hey! This is my first time posting here, so I'm still trying to get the hang of this. I just started learning FileMaker (my first database program) and I'm trying out simple scripts to perform actions to make my work a bit more efficient. Basically I am writing a database to track part numbers and serial numbers of certain products that get sold daily. Basically I have on text field for input, that after I scan a barcode it determines whether the scanned input is a part number or serial number. It then takes the inputted text and moves it to either the Part Number Field or the Serial Number Field. After that it clears the InputField. What I would like it to do is then move my cursor back to the InputField so I can immediately scan the next barcode (without creating a new record). But every time I try it, it goes to the next field. I have the script triggering OnObjectSave as the scanner adds a Enter Keystroke after the scan. Here is the script I am using: Any help would be great! Thanks!
comment Posted May 27, 2011 Posted May 27, 2011 How about; If [ Length ( Runners::InputField ) = 9 ] Set Field [ Runners::PartNumber ; Runners::InputField ] Else If [ Length ( Runners::InputField ) = 12 ] Set Field [ Runners::SerialNumber ; Runners::InputField ] Else Beep End If Clear [ Select; Runners::InputField ]
Recommended Posts
This topic is 4929 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now