Mass data entry

[bauerpower]

Dear all,

I just started a few days ago set up my PI4 with nuBuilder. And I'm going to start investigating the possibilities of this tool!
Amazing with a few clicks provide are you pretty good applications.

But anyway every start is hard and after so many videos I can't see the forest because of all the trees
Here my small project about:

- Scanning (or manual entry) of shippment lables (1000-2000 a day!)
- Adding the label number and time Stamp into a table
- Underneath the entry there should be a simple "scanned record listing"
- After all scans I will run PHP script to update some shipment information.
- ... and delete the records after printing a report...

I started already working with SUBFORMS and trying plenty of other things .... but

Is SUBFORM the right approach and how to update "scanned record listing" without loosing the
focus of the next scan (cursor position)?

It is a step by step approach and I's sure I gonna rumble it (sooner or later) with a little help

1000 Thanks

Joerg

[kev1n]

I started already working with SUBFORMS and trying plenty of other things .... but

Is SUBFORM the right approach and how to update "scanned record listing" without loosing the
focus of the next scan (cursor position)?

Hi,

I'm not sure I understand what you are trying to accomplish. Could you elaborate on that a bit more?

[bauerpower]

Dear kev1n,

I try to setup the planed application with a subform (last post attachment).
But every time when I enter a new Shipment No. the cursor moved to the subform.

What I want is a mass data entry that means, the cursor is always in the shipment No. field
and waiting for scan or manual entry. After the update e.g. "05258995978719" + CR
the list underneeth list will be updated.

If the scanning of new numbers is finished the update button will be executing some code ....

I attached a short drawing ... maybe it helps to understand my process and how
I should setup in nuBuilder .

Plan.jpg

table.jpg

[kev1n]

Does "Update" save the form?

[bauerpower]

Does "Update" save the form?

Dear Kev1n,

After each scan I add the record into the „import“
Table and update the list below.

Then next scan (300-600) times.

When the scans done the update button should execute a script which
Update another table with the timestamp of the „import“ table and zap the
„Import“ table.

If there is a better way to do ....I‘m open

1000 Thanks

Joerg

[kev1n]

Can't you just set the focus on the "Shippment No" field when the form loads?

Code: Select all

$("your_shippment_no_button_id").focus()