Filemaker Pro 13 Adv - Label printing

Hi there,

Imagine you have used 6 out of 10 labels off off your label sheet.

Now, you need to print two labels starting at label 7 off your label sheet.

I need to be able to print labels with Filemaker Pro 13 Adv with the feature of staring to print at label X.

An already made solution would be greatly appreciated.

Thanks for your help.

Cheers,
Rene
LVL 10
ReneGeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresident, Dedication Technologies, Inc.Commented:
Rene, the simplest way would probably be to create X number of blank records that are then sorted before all other and then are deleted. A simple script could be used to do this that presents a dialog where you enter the number of blanks you need, uses a Loop to create that number of blank records, sorts the found set of records (presumably you started with the 2 you wanted to print), runs the Page Setup and Print step and then deletes the blank records.

Of course if you have serialization, multiple users or some other reason why  you don't want lots of blank records being created and then immediately deleted, this might not work for you. An alternate somewhat more elaborate way would be to create a separate table, import your two addresses into that, create the blanks there and then delete everything afterwards.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ReneGeAuthor Commented:
Hi Will,

Thanks for the prompt reply.

My challenge with this solution is that the blank fields contains, images and containers, which both does not seem to have Conditional Formatting.

So therefore, the images will show on the blank labels.

One last thing, while at it, laying out a best practice of making labels with FM Pro would defiantly  be a must!

Thanks for helping and cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
Rene,

If you look on the Data tab in the Inspector palette, you'll see an option that says "Hide Object when". You can apply this to the fields you do not want to display and set the condition to Hide it if:

isempty( blankfield )

As far as best practices, I tend to use Merge fields in a text block on the layout rather than fixed fields. If you have a stack of fields, e.g. an address, you set the Vertical Alignment to Center for the text block. And, rather than having a stack of merge fields (which is fine) it's sometimes more useful to create a calculation field using the List() function and including any conditions you might want, for the fields you want to have appear. Then just put the calc field there instead of all the individual ones. Individual ones are fine to, it just depends on what you need.
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

ReneGeAuthor Commented:
Hi Will,

Sorry for the late reply.

I think I understand what you mean.

I used to be an expert in FM Pro, back when it was owned by Claris.

I now need to catch up quite fast because i have several projects to complete.

If you don't mind, would it be possible for you to provide me with an example?

Thanks and cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
Rather than try to create an example file from scratch, why don't you upload what you're working with with some sample data and I can tweak that. It will be much faster and also more specific to what you're doing.
0
ReneGeAuthor Commented:
Hi Will,

I'll create an FMpro project for lable printing to create a best preatice template.

Do you agree we collaborate to create this best practice FMpro template for label printing?

Based on your comments, I have a few ideas.

Cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
Hi Rene,

I'm happy to help tweak a template but going back to your original question around printing a partial sheet of labels, I just want to comment that that is somewhat unusual. In 27 years of doing FileMaker programming I've never needed to create something like that though it's wouldn't be terribly difficult. Most users who want a small number of labels at a time, use a Dymo label printer.

Dymo label printing costs a bit more per label but it gives you exactly what you want without any extra hoops to jump through to start at the correct position. Plus it avoids the potential risk of running a label sheet through a laser printer multiple times which I would think would significantly increase the potential for the sheet to jam (and getting labels off of a printer drum or cartridge is not easy)  

I guess I would start with the idea that "best practice" for label printing might be to use full sheet labels when you want full sheets and use a single-label Dymo type printer when you want just one or two. I'm not meaning to be snarky here, just making the point that you use different types of printers for different needs.
0
ReneGeAuthor Commented:
Hi Will,

You just reminded me that Fmpro layouts were and seems to still be subjected to a printer.

This is so Appleish!  In the PC... world all revolves to compatibility (and blue screens... ;).  In the Apple world, all revoles around adapting to it, in the sense where it would be an added bonus to have a templat that would work with whatever printer we use.

Anyway, I not only must make this work, but I'm also having a nostalgic moment.

As for the Dymo label printer, I'm not excited about it because I'm more looking in updating my FMpro skills along with creating an all in one solution.

I'll update you shortly.

Cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
Rene - Apple has been on Windows since 1993 and the majority of both users and developers are on Windows though it's obviously cross-platform which is one of it great advantages. MS Word comes with label templates too but they all vary depending on the dimensions of the page you're printing including A4 vs US Letter vs. Dymo rolls and the size and shape of each label on that page.

As far as user interface screens, FM has added a tremendous amount of flexibility that allows the same layout to be very adaptable - sliding, stretching, resizing - based on the dimensions of the display, and also allows for things like Conditional formatting which means you can change the appearance of text - font, color, size, etc. based on a calculation. Lots of options....
0
ReneGeAuthor Commented:
Hi Will,

It seams that my Filemaker expertise has sunken in the deep sea since a very long time ago.

I enjoyed working with fmpro.  That why i payed the avd version to get upto date as soon as possible.

Please forgive my présuppositions.  I just love FMPro.

In the next few days, I'll make an FMpro Labeling file and share it with you so we can make it better.

If you dont have much time, I'l  be more specific and create new questions as needed.

Thanks and cheers,
Rene
0
ReneGeAuthor Commented:
Hi mate,

Sorry again for taking so long to reply.

I got you ideas.  They make sense and I'll manage.

Thanks for your dedicated assistance.

Cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
Specific questions are good as are example files. I'll answer as promptly as I'm able.
0
ReneGeAuthor Commented:
Hi will,

I just used the isempty( blankfield ) feature. Nice!!

I realised that I'm too rusted in FMPro and I'm currently updating my skills.

In the meanwhile, thanks for your contributions.

I'll come back to you shortly.

Cheers,
Rene
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
If you want to test for a non-empty field you can also use   not isempty( someField )   "not" also works with patterncount() and some other functions. At a FileMaker DevCon a few years back, one developer had some T-shirts printed up with some of the then newer functions.  "not is empty( )"   was a popular one, but the one that sold out the quickest was "GetAsDate( )"
0
ReneGeAuthor Commented:
Hi Will,

I just completed my first label printing FMPro project.

It's not so sophisticated but it does the job.

Inspired by your comments, I've created a table  called Lables and with Relationship with the UserID field and the employees table.

The labels used here have the Avery  5371 (2 X 5).  I therefore created 10 records and added them in a Layout in list mode.  All I have to do is to enter the employee's ID in the record associated with the positions i wish it to be printed.

Then, I go the another Layout which is setup as a form view and with the Avery 5371 settings.

I finally controlled not to print objects when the the ID field is empty.

I added a few elementary scripts with that and my problem is solved.

I will soon make a bit more sophisticated label making template and if you are interested, I'll gladly share it with you.

Cheers,
Rene
0
ReneGeAuthor Commented:
PS: Sorry for my bad English here.  I was more focused of the message than on the form.

Cheers
0
Will LovingPresident, Dedication Technologies, Inc.Commented:
That sounds like it will do the trick. I would probably automate it a bit more with a script that copies the IDs from the found set of records and then presents a Custom Dialog that asks which label to start with before then populating the ID fields. The dialog could also include an Input field for the IDs if you prefer and the script would then parse them into a list, assuming they were comma or space separated.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.