Data Entry Form from Excel
I've been designing a label for a week and I am struggling with how to connect my database (excel) to my data entry form. I have field names VendorID#, ItemNum, and ItemDesc.
So, I would like to add these field names to my data entry, so when I select the VendorID#, the other two field names will also populate. Also, I have another field name that I would like to add to the data entry which is a manual entry. Overall, I would like to see all these options in one data entry form, if possible.
Right now, I have to go to the "print" and "select records" and select the records.
I will appreciate any help or inputs from the community.
I take you have linked your label to your database and so in the Template view on the column on the left you can see your database fields and can add the appropriate fields on to your label from there
For the record selection you have a couple of options, use the Select Records from the Print Screen, that it looks like you are using now, add this option onto your Data Entry Form or add a database filter/query and leave it as a separate option or add this to your Data Entry form too.
The database filter/query can be enabled in the Database Connection Setup screens as shown below and you can give the Query a "name" if you wich and change the Text Label or the question the users see to something appropriate which for the screenshot below could be something like "Enter Product Code" for example
For the Select Records option on your Data Entry Form you can add from the Data Entry Control dropdown a Record Picker (or Drop Down Record Picker) and the users can use that to choose the record they require. Once added you can go into the Properties of this and amend various items including adjusting the size of the columns in the table and the order etc. This will allow the users to see the fields you mention or often I will include and Picture>Preview of Template on the form so that the operators can see the "live" data on the screen.
Also from the Data Entry Control dropdwon you can add Text Input boxes and link these to any manual entry fields you need and you can also add additonal text or number entry boxes and link them to the number of labels (Copies) or even your Database filter if you have one.
I hope this helps0
This is great! Thank you very much!
We actually just upgraded our Bartender Professional to Automation, and so far it's working fine and meet my needs.
I have a follow-up question though. So, I designed a label with a barcode with embedded re-sort information in it. Every time a worker scans the barcode it will tell the worker if that particular pallet is on hold for pits/stems and it will show the numbers of pits/stems found in the pallet as well. My dilemma right now is, we also monitor the micros of that particular pallet(lot code) but micros results are delivered after a week or two.
1. How can I prevent the shipping personnel from sending out the pallet if there's still no micros clearance? Is there a better way of addressing the issue?
2. Is there a way I can update the printed label after a week or two like unselecting a check box of micros or something?
Sorry for all the questions I threw here. I am open to any suggestions.0
If you logged in the spreadsheet whether the micros had been received (you could add a Micros column and the uses add a Y when received or similar) and then use could add an extra filter to your database connection that
Micros equals Y
so the labels would only print is that column has the correct value0
Great! I will try this option. Thanks!0
I have a question about the record picker on my form. Is there a way I can set up the number of columns permanently?
Right now, I have several columns showing on the record picker, and I use the "Hide This Column" option every time I start using the form. But let's say if I close the bartender app for the day and open it again the next day the hidden columns I hid are back again.
Is there a way I could just permanently keep certain columns to show in the record picker? The reason I want to keep it this way is because some of the columns are irrelevant or not useful at the moment. I appreciate any input!0
Odd not seen that happening before. If you save the label after you have amended the form and columns etc it should stay as it is.
The only time I have had to readjust this is if I have relinked to a different database.0
I have seen this problem as well with the Automation Version of BT all the way up to version 2021. You create a format and then put it in the network share for all print stations. Each print station will have to have the "hide columns" done manually the first time it opens. And if anyone makes an edit to the label it starts over for every workstation.0
I would like to know how to add barcode to the temple created by Piotr with data which is added to the "manually data field"? Barcode data will be for example: 2,5.
Let's say I have excel file created for Piotr Layout. In the " manually data file" I tap weight of product. In the excel file I have 6 extra columns: weight 1, weight 2... till weight 6. How after printing save this weight data in correct columns in excel? And also if I will weight the same product second time data will be in column "weight 2". I use Bartender Automation.
Thx in advance for any help.0
For 1. the process would be the same as the manual text field as per the above:
- add the barcode to your label
- add a text input box to your Data Entry Form
- and then go into the Properties of the text box and use the Linked Data Source option and select the barcode data source in the column on the right
2. Is not as easy as all that. Not 100% sure but you may need to configure an Action to run at print time that is linked to a sequential number that increments for every record printed, but then resets for each new record. Every time it the weight is written to the Excel file by the Action putting the data into weight X column where X is the sequential number. This maybe something you need to speak to Seagull's Professional Services team to see if they can help you out.0
Please sign in to leave a comment.