Data entry form advice Folgen

0
Avatar
adrian mihalko

I would like to ask for advice for printing price labels.

The goal is to be able to select product from a database or enter data manually when nothing is selected (or edit/manually override data/text of entry which was selected). 

The label is simple:

  • product name (connected to database SHOPITEM/PRODUCT)
  • barcode (SHOPITEM/EAN)
  • price (manual entry)

Database looks like this:

Data Entry Form:

As you can see there is a Record Selector,

Name input field underneath is connected to product name field on the label.

Price input field is connected to the price field on the label.

 

This is working pretty well. I select a record, then I see Name input field is getting updated on the form. If I need to change the name I can do that.

I have 2 problems here:

1, When I launch data entry form first entry is always selected. It is possible to not select anything after launch? I added a Clear button to the form, which fixes the issue, but I always need to press it.

2, For some reason If I modify the text in the Name field and I try to select entry from data selector the Name field doesn't get updated.

3 Kommentare

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

1. Amend the default Data Entry options for your Record Picker to No records and that should sort this

 

2. It must be something in your config I think. I would suggest leaving off the select records area from your 2nd Data Entry Form and configure this form to open for Each Record. You may want to add a Preview of Template onto the form from the image dropdown as that maybe useful for the operators

0
Avatar
adrian mihalko
Aktionen für Kommentare Permalink

Thanks Pete, question 1 is resolved.

For question 2, may I more describe the problem?

I created a screen record where you can see what is my problem:

https://youtu.be/hqdEr-Exqrk

Setup look like this:

On the label template, product name text field is linked to database source: 

On the form, the manual override text input box is linked to the product name text field on the label.

It gets updated correctly when I choose any record from the record selector, but after I enter something manually, it doesn't get updated anymore (when I decide to select something from record selector again). Sorry for the complicated description, from the video it is easier to understand.

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

As soon as you change the record selection for a 2nd time you cause to BarTender to perform a lookup into the database and pull out the values for the linked fields. 

As I mentioned above, once you have selected your records and proceed to the 2nd Data Entry why do you need to reselect them again? I assume this is to override the entries for each of those individually and if that is the case you do not use the record selector a second time. As per my second screenshot give the 2nd Entry Form a Frequency of Each Record and so it will then open multiple times one for each record chosen.  

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.