Page 1 of 1

input data from scanning a list of barcodes

Posted: 2016-07-29 17:48
by analogue_alec
Hello,

I'm new but wondering if this is possible?...

We are creating a database with each record having a unique barcode and a 'status' field.

We'd like to update the 'status' field of multiple records at once by scanning the barcodes into a list.

Whats the simplest of creating the rules to find and update the records from the list?

Thanks.

Re: input data from scanning a list of barcodes

Posted: 2016-08-30 09:54
by grimblefritz
A little late, perhaps, but this is doable using an AppGini custom page. Look here:

http://bigprof.com/appgini/help/advance ... cess-pages

The key thing is that this will load the database and all of the AppGini data handling functions.

Your custom page would:

1. Open and read your list
2. Iterate through the list
3. Use the AppGini sql() function to update records