Page 1 of 1

Mass data entry

Posted: Fri Oct 02, 2020 2:48 pm
by 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 :P
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

Re: Mass data entry

Posted: Fri Oct 02, 2020 2:56 pm
by kev1n
bauerpower wrote:
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?

Re: Mass data entry

Posted: Fri Oct 02, 2020 4:46 pm
by 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

Re: Mass data entry

Posted: Fri Oct 02, 2020 9:35 pm
by kev1n
Does "Update" save the form?

Re: Mass data entry

Posted: Sat Oct 03, 2020 7:33 am
by bauerpower
kev1n wrote: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

Re: Mass data entry

Posted: Sat Oct 03, 2020 7:50 am
by 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()