Data Merge to Uniquely-Named INTERACTIVE PDFs

In this episode of Colecandoo, I’ll demonstrate several ways to data merge to uniquely named interactive PDFs. The first method uses the data merge to single records script that I released in 2015 and can be downloaded here.


This demonstration features an InDesign file that is a survey for a package tour company. It contains form elements such as check boxes, radio buttons, a combo box, text box and a submit button. It is also a Data Merge document and contains two text fields within the first paragraph.


With my script, this should be a simple task, but as I click on the PDF export preset dropdown, I notice that I don’t have an option for interactive PDF. Why is this? Well put simply, the script works by calling upon the two ways that a Data Merge can normally be exported – to a newly merged InDesign file, or to a PDF.

As described on Colecandoo before, PDF export from Data Merge is neither a print PDF nor interactive, but it’s own style. Read the full article here.

Method One

But I said it could be done, so what’s the trick? Ultimately, we have to run my script to merge to InDesign files first, and once the folder of InDesign files is generated, use another script from Peter Kahrel, namely BatchConvert.


This script is an amazing utility created by Peter Kahrel that I have written about for InDesignSecrets. It takes a folder of InDesign files and can convert them to a variety of formats, including – for our purposes – interactive PDF. Simply point the script to the folder of InDesign files that were made initially, then point the script to a folder where the interactive files should save save to. Choose the output option as PDF interactive, and then run the script. That’s the first way.

Method Two

The second method is identical to the first method in that files are initially merged to InDesign files, and again uses the batch convert script. The difference is that rather than export to PDF interactive, files remain as InDesign files. Instead, there is a checkbox at the bottom of the user interface that allows another script to run during the batch. From here, I’m going to choose a script I’ve written for this express purpose – it will create an interactive PDF with the same name as the ID file but will save it to a folder called interactive PDFs on my desktop. So that’s the second method.


Method Three

The third method demonstrates a sneak-peek at the PRO version of the data merge to unique names script.


The interface doesn’t look too much different to the previous script, with one exception – the option to run a script during an InDesign export. From this new option in the user interface, simply select the script that I used in method two. Choose some fields for the filenames, the range, and click OK. That’s the third method.

Method Four

The last method demonstrates a sneak-peek at another alternate version of the data merge to unique names script. Unlike the other methods shown, this method is by far the most direct, as it adds “PDF interactive” directly to the user interface.


To accomplish this task, choose the save location, choose the “PDF interactive” radio button, choose some fields for the filenames, the range, and click OK. That’s the fourth method.

Sidenote about Document Fonts

One issue not addressed in the video is the issue of potential font substitution while creating the interactive PDFs. This comes about because all four techniques rely on creating an InDesign file first that is removed from the original merge file, and may not have access to the fonts used by the original merge file. I’m running Extensis Suitcase font management software so I know the fonts will always be active until I turn them off, but for those relying on other solutions such as the Document Fonts folder, beware of this issue. I’ve written about this for InDesignSecrets.

An added bonus

One thing about the PDFs made during the demonstration was that the text in the dropdown field didn’t suit the formatting of the survey. Formatting of text-related form fields can’t really be controlled in InDesign except for the point size. However, I’ve made an Acrobat Action that I can run not just to this file, but all files in a folder. This action will convert the font in the text and combo boxes to Helvetica and make them 12 point. It’s worth noting that while it’s possible to change the font to whatever is on your system, other users may not have those fonts, so be conscious about this before using the action. Helvetica, Times, Symbol and Courier are present in Adobe Acrobat.

I’ve made this Acrobat Action available from my downloads page as well.

For those after a more robust solution, perhaps consider Form Magic from ID-Extras.

So there you have it, four ways to create uniquely named interactive PDFs from Adobe InDesign. If you’re interested in purchasing the upgraded versions of the data merge to unique names scripts shown in this video, contact me directly via my contact page.

InDesign User Interface mods with Startup Scripts

In Episode 16 of my Youtube videos, I briefly showed a startup script that added several options to the contextual menu that allowed a frame to fit a given size. But it’s not the only way I’ve modified my user interface, so this episode of “Must-Haves” is dedicated to scripts that make minor modifications to the user interface.

The modifications mentioned in this article use javascripts that are installed into the startup scripts folder. Scripts put into this folder don’t have to be double-clicked from the scripts palette, instead they are run when InDesign starts up. So let’s have a look at what features these scripts add to the user interface.


Origin unknown

This is a one-line script that instead of adding functionality, actually takes it away… If you don’t like the startup screen showing up whenever no documents are open, add this script to the startup scripts and you’ll never see it again.


By Gerald Singelmann (Cuppascript)

This script adds a new main menu item that shows all panel menu items within the one menu.


by Marijan Tompa (Tomaxxi)

This script adds three options at the bottom of the layers panel that allow a layer set to be applied upon the creation of new documents. The layer sets are also customisable.


By Theunis de Jong (Jongware)

This script adds two options to an InDesign book palette – open all documents and close all documents.


By Marc Autret, Indiscripts

This script adds an item to the file menu, particularly close all.


By Olav Martin Kvern, Silicon Publishing

This script adds the functionality of the pathfinder palette to the contextual menu. This is a great timesaver when working with shapes, so rather than having to click off of the object or objects being worked on to perform a command, simply right click to call up the desired command.


By Gabe Harbs, In-Tools

This adds an option to the color palette that allows a color to be converted to greyscale based on formulas in the script.


By Marijan Tompa (Tomaxxi)

This script adds a menu item to Adobe InDesign that allows the export PDF option in the background to be enabled or disabled. For whatever reason, I prefer to watch the progress bar of the PDF being created rather than let the task run in the background, so having this option is useful to me.

Unfortunately, this script is no longer available from Tomaxxi’s website, and it’s also not my script to give away. However, this link is an article where the script was conceived, and similar scripts are available in the comments section of the article.


by Roland Dreger, Roland Dreger GrafikDesign

Adds the “Sort and Place…” item under the place item in the file menu. Once items are selected, a UI appears prompting for the method to be sorted for the place.


by Gerald Singelmann, Cuppascript

Adds a place… option to the contextual menu… but with a major difference. Selected frames will have the resulting images imported into the frames either in the order they were selected; or if marqueed at once, then from a left-to-right, top to bottom order. It effectively does away with the placegun and allows images to be placed directly into awaiting frames.


by Gerald Singelmann, Cuppascript

Adds three options towards the bottom of the contextual menu – swap images, swap places, and load image in placecursor. Certainly a go-to script and very handy for swapping images on the same page or spread; or swapping images between frames.


by Marijan Tompa (Tomaxxi)

Adds two options at the bottom of the object styles panel that applies a given object style to placed objects. Typically, object styles can only be applied once images have been placed.

выровнять фрейм.jsx

by Eugenyus Budantsev

Translated as align the frame, this script adds four options to the bottom of the contextual menu that allows a text frame or graphic frame to resize to the margin size, page size, bleed size or baseline. Images within a graphic frame will resize to fit the frame, but this can be adjusted by editing the script and replacing the words:




Or another preferred option. See this link for the other options that can be chosen.


In a future Must-Haves video, I will demonstrate other user interface modifications that can be made that are installed in other ways.

Data Merging into the same Text Frame

From time to time, I hear the question along the lines of “how to I get Data Merge to put the next records in the same textframe during an InDesign Data Merge?” Well, if you’re expecting to do this procedure in one step, you are going to be disappointed because there is no one-click, turnkey solution to do this in Adobe InDesign itself.

That does not mean that accomplishing this task is impossible, in fact it can be done, and in Episode 16 of the Colecandoo Youtube videos, I outline several methods of how to accomplish this task, such as:

  • Merge in Microsoft Word beforehand and import into InDesign as a regular text import;
  • Merge in InDesign using the multiple record feature and use one of three scripts to re-thread the text so that it can be combined into one textframe;
  • Use a script from Ozalto that performs this task with almost no effort;
  • Venture into the rabbit-hole that is XML publishing; or
  • Consider one of the half-dozen paid plug-ins that are dedicated to the production of catalogues.

The video demonstrates several scripts that are absolutely essential for this task, as well as a bonus script that will help in everyday InDesign use:

This is a question that comes up often on various forums, and I feel that by showing how to accomplish this task through a video tutorial that it makes it easier to understand why this task needs to be done differently to Data Merge campaigns related to direct mail items or the creation of business cards.

EAN-13s on a budget


From time to time, there will be a need for any designer to add an ISBN barcode or EAN-13 to artwork that is being created. Typically, the customer supplies the number by itself and the barcode is created from that number and placed into the artwork. The question is… how does that number turn into a barcode?

This article isn’t going to be a long and technical article about how barcodes are generated and the math/programming that goes into it. Instead, it will point to some available resources for generating the odd barcode here and there, rather than fully developed software that can batch produce barcodes and integrate with databases.

Most of this post refers to EAN-13 or ISBN style barcodes, simply because since 1 January 2007, ISBNs are 13 digits long and use the EAN-13 barcode format for their barcode structure and appearance. What this in turn means is that a solution that can generate an ISBN can also generate an EAN-13, a standard used by most of the world for generating product barcodes… except if you live in the USA or Canada where UPC is used more often.

To my knowledge, no Adobe nor Quark product (nor any product from its latest rival, Affinity) ships with a barcode module as default, but Microsoft Windows users who use Corel Draw will know that it ships with a barcode module and has done so for the past 15 years (just a hint Adobe if you’re looking for ideas or innovations for the next upgrade to Creative Cloud). That’s well and good, but if you’re like me – a Mac user running the Adobe Creative Cloud, Corel Draw isn’t an option.

If you’re also not in the market for dedicated barcode software (as there are hundreds of products that are available) but would like to create a barcode with the minimum of fuss from your desktop or laptop, there are three alternatives that I would suggest:


Many of the paid plug-ins that are substitutes for the Data Merge feature of Adobe InDesign typically come with a barcode module or add-on. For example:

But if you’re a designer that isn’t after an enterprise solution for making hundreds or thousands of barcodes, but just wants one barcode for a self-publishing client or a craft brewery for their bottles, then many of these products are probably overkill.

InDesign Scripts

Because I work in InDesign most of the time, having the ability to create a book cover and barcode in the same application has advantages for me. That said, here are three scripts that are worth a try:

BookBarcode by Indiscripts – a paid script for Adobe InDesign (€39). It offers lots of customisation and allows for batch creation of ISBN barcodes. If the pennies are tight, there is a “try” version that creates a “vanilla” EAN-13 barcode without the added features and bonuses that would be required from a book publisher or brand agency.

EAN Barcode generator by Konstantin Smorodsky – free script available from the Adobe Add-ons site. Does one ISBN barcode at a time and is intended for general purpose EAN-8 or EAN-13 barcodes, but since ISBN barcodes fall into this category, this still qualifies. Does not put the human-readable ISBN above the barcode though.

ID Barcode by Nick Morgan and Bruno Herfst – free script that supports EAN-13, ISBN, ISSN, ISMN; some customisation of fonts, includes human-readable ISBN above the barcode, EAN-2 and EAN-5 supplemental barcode.


To my surprise, there are several websites that can create CMYK, text-as-curves, vector graphic barcodes that are worthy of consideration. Again, the internet has these sites in abundance, but of the sites that stood out were:

Terry Burton’s online barcode generator – This site creates a vast array of barcodes, yet alone EAN-13/ISBN. Options are limited per barcode, but if functionality is your thing, definitely a worthwhile website. – Generates a vector PDF ISBN barcode. No customisation but contains human-readable ISBN above the barcode and all type is set in OCR-B. There are also other useful tools on the website for book publishers.

GS1 (EAN-13 barcode generator) – The Swiss site of the GS1 organization has a feature that creates EAN-13s. Again, no fancy bells or whistles but it does the job.

Free Barcode Generator – Another no-nonsense barcode creator with some options but without the fanciness of the scripts or plug-ins.

Free ≠ yours to do with what you will

The last 7 links have mentioned free resources, but remember that the creators of these resources have the same bills and overheads that you do. If their script has saved you time and effort, and their website has a way of making a donation, seriously consider making a payment to these developers who go out of their way to not only make these resources, but allow you to use them without charging a hefty sum.



%d bloggers like this: