Barcode scan
I am using a bar code reader to insert a number into a field
I would like to add a new record on each read. Using the Create table command
My problem is that once it is created I would like to go to the next new create record.
If I have 50 items to scan I would just like to scan without going back to the table each time
8 replies
-
@John,
I do not have anything I can (easily) scan... So I cannot prove this out... You should be able to add logic into you barcode after update trigger to close the current record and create a new record. This will leave you with one empty record that needs to be removed when you are done scanning.
-
In table view i it works( create Scan).SCode when i put this command in tgger after update but not in form view. I see it does craete a record but in the form the old record remaines .
-
@John, while in form view.. do a closeRecord() .. then create ... .. let me try it without a barcode scan..
-
Here ya go.. My table name is Master.
It the barcode after update trigger.. .and you may have to tab off the field.
closeRecord();
let m:= create Master;
popupRecord(m.Id); -
Since you have to tab off the field.. Why not put that logic above into a BUTTON.. "Scan Next" ...
-
That works, however after the record is created I would like to have a foeld selected were the code would go in. Right now an empty record appears but I need to click on the field. After the reord is created what command can I use to tab into the field? Thanks for your help.
-
closeRecord();
let m := (create Scan);
popupRecord(m.Id);
(select Scan).SCodeThe last line select a field is were I would like my system to click into but that command does not seem to allow this. I have only one field in the table, I want to open the table and make this field active. In other words open form view click on the field and type a number. The scanner is like a keyboard and will enter the number.
-
@John
Understand. Unfortunately at this time there is no way to autofocus a field. There is a change request (1213) to provide this... There is also a change request (1330) to provide the ability to set a field tab order.
As a Ninox license holder, you can request access to the Ninox Beta Team (email support@ninox.de) where the change request database is located.
Content aside
- 5 yrs agoLast active
- 8Replies
- 2700Views