Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

  • Newbies
Posted

Is there a way in MF to auto advance to the next field once data has been entered. I'm am working on an inventory app and we use barcode scanners to inventory the parts on our trucks. I have 2 fields in the count table. Part number and qty. When I scan a part number the scanner includes a to advance to the qty field. I want the qty field to default to 1 and move to the next part number field (next record). This way we can just go thru the truck scanning everything and not have to worry about stopping and entering a qty. I can then run a summary report for the qty of each part.

Thanks

Jason

Posted

1) Qty field set File>Define Database>Qty field>Options->Auto Enter->Data to "1" (w/out quotes)

2) Right click the Qty field on the layout you are using, Left Click Field Behavior, Uncheck "In Browse Mode".

3) If you will later need to enter the Qty field in Browse Mode make the field a button and attach a script "Go To Field[Qty}" when then the field is clicked. Or simply use a different layout to edit than for scanning entry.

Posted

Alternatively, after #1 in sbg2's post, create a list layout with just the part number field on it. If you default to QTY=1, then you don't need it on the layout, and you can have a very simple layout for the truck scanning without affecting other parts of the interface.

This topic is 6918 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.