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

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

Recommended Posts

Posted

I have created a field that we will use a barcode scanner to enter items (such as headphones, zip drive) that students check out for use in the lab. The barcode scanner enters a return after each scan and I have it all in an "items out" field. Clicking on a "Check Out" button commits the record. When you click on the "Check In" button a script is called that brings up a dialog box. Here, we would scan the items back in. I modified the dialog so there is no default button, otherwise the return signal from the barcode scanner would only be able to enter one item. This enters the barcodes as one continuous text value. I need to be able to break the barcodes apart and compare them with the "itemsout" field. The thing is, I also need to account for the fact that they probably won't be scanned in the same order. I guess I need to sort the "words" within a field How do I do this? This seems like a trivial question but it's really got me stumped. Perhaps there's a better approach . . . Thanks in advance for any help y'all can offer.

  • 4 weeks later...
Posted

Just a suggestion:

Use a related table: ITEMS

Fields : Student_id, barcode, flag ('In' or 'Out'), barcode_in, check_out_date, check_in_date.

Create a relation from student_id in the main table to the student_id in items

Write the items that students check out to the ITEMS table. Fill the fields student_id, barcode, flag (='Out') and check_out_date.

Present a portal , showing the items he / she checked out, .

Show in this portal the item and the field barcode_in.

Let them scan into field barcode_in and let them start a script by means of a button in this portal-row. if barcode = barcode_in then set field Flag to IN.

Now you can trace all movements and see the history per student as wel...

does this help?

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