Simple Box Numbering 关注

0
Avatar
Legacy Poster

Hi there,

 

we are looking at purchasing BarTender, so ive been tasked with playing with the trial versions for the last few days

 

Our labels currently are very simple, and easy to set up and look right, but we rarely have the same number of labels outputted.

 

Ive worked out how to write a simple sequence in excel from for example 1-100 so when i import it as a database, i get 100 labels saying 1 of 100, 2 of 100, 3 of 100 etc. etc.

 

it works and is easy, whats not easy is having to add another new sequence in excel for other amounts, everytime a new order comes in, I could end up with an excel sheet with 1000's of number lists, and it requires closing of the software and restarting it

 

So put simply is there a way that I can add box numbering eg Box No: 1 of 100 without having to use and modify a database each time the box count changes

 

is there a way that Label x to y in the componants panel can be set to do this and the data just be modified within bartender?

 

Im sure there must be, I just cant figure it out

 

Thanks in advance

2 评论

0
Avatar
Legacy Poster
评论操作 固定链接

Yes.

 

But I'm having a hard time exactly seeing what modification you're trying to make. Can you attach the file you have, a sample database that is *working*, and then a sample database how you'd like it? From there we can see what scripting or settings need to change in order to get your box count right.

 

I assume not every job is 100 boxes, and it changes based on the data file?

0
Avatar
Legacy Poster
评论操作 固定链接

Hi nRyder,

 

I think Ive made it sound much more complicated than it needs to be. Since posting the topic, ive found a very simple way to get round my problem. As 99% of our labels are the same just with different customer info and amounts.

 

What ive done is used a serial number number box for my initial box numbers starting at 1, then a normal text box for total amount so you can just type in the total amount in to the textbox eg 250

 

then print 251 copies [yes 251, label 251 of 250 would be for the despatch job card] and jobs a good un.

 

I will attatch my attempt for you to see, ive used a locked base layer of unchangable data, and left a layer open for editing for each new job. Im pretty pleased with the results, there may be better ways of doing it but ive only been using the software for 6 hours and Im normally a graphic designer and have no idea what excel or vb script is. I did set a excel database up but it was more hassle than it was worth especially having to change the amounts, sometimes it would affect other test labels i had created.

 

cheer

请先登录再写评论。