Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4929 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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:

25updua.png

Any help would be great!

Thanks!

Posted

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 ]

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.