How to use data from Airtable to fill out fields in a document

A while ago I built a workflow to publish a booklet with Airtable and MS Office.

If your document is simple enough, you could probably:

1. Export from Airtable to a CSV file.
2. Have MS Word do a mail merge from the CSV file.

If your document or data is very complex or has long text fields or lots of fancy formatting, the workflow gets more involved but it is still possible.

On the other hand, if your onboarding document is very simple, could you get by with the Page Designer block?

I wish there was a way to scan a document into a page block and then let Airtable fill in the field data. I have tons of documents that other depts send me that I have to fill in. I have been converting them to word documents and downloading the data to CSV and then mail merging it…Time consuming and duplicate work for me.

@andrea_delgiudice
Wow, that sounds like a ton of work. I don’t have a solution for you right now, but it is an interesting use case that I would like to know more about.

Have you converted most of the forms to Word mail-merge documents already, or is there a constant influx of slightly different forms with slightly different fields in slightly different places on the page?

How do you receive the forms? Physical paper? Photo of a physical paper? PDF? Some other format?

Instead of designing the document in a separate application, design it in Page Designer. One of its primary purposes is to let you create documents that are meant to be filled in with field data.

When making your document, you’ll primarily use the Text object to create your static text, and insert field names wherever you want field data to appear, like this:

With the output looking like this for a single record (I made the design size small so it’s easier to insert here):

Here’s my $0.02 on this challenge…

There isn’t; Airtable is an unlikely candidate to get you where you want to go. In fact, the more you try to involve Airtable as a solution, the less likely you will be able to reach your goal in a practical way.

This is an indicator that your organzation hasn’t given its internal information processes any deep thought. And perhaps they have, but they also struggle to find a pathway to streamline your part of the process.

Before considering any strategy that may help, let’s start by understanding what you are currently converting from into Word to process this data. The very idea that Word-to-CSV is a good thing is troubling unless, of course, the data you are converting from is some sort of grid format exported by some other system or tool and Word provides you the only reasonable manual pathway forward.

Thanks! I hadn’t tinkered with page designer yet, but this is precisely the right functionality.

Agreed, but in certain situations it could be an adequate solution.

@Justin_Barrett
Yes, which is why I suggested the Page Designer block in my original post.
I’m happy that the Page Design block works for the original poster.

To clarify, the situations where it makes sense to use a Word Mail Merge instead of Page Design block:

• There is no budget for a Pro subscription but you already have MS Word
• You need more complex formatting than the Page Design block provides
• You need to end up with user-editable documents to make slight tweaks to edge cases
• You need additional document automation that Word provides (but Page Designer does not provide)

Good points. Sorry that I didn’t see your original suggestion of using Page Designer above.

Unfortunately, Airtable's Page Designer is very limited (and can’t be automated in any way), so here are 4 popular solutions for generating documents from Airtable that can do what you’re looking to do:

1. DocuMint — the original document creation app for Airtable. Creates PDF files.

2. DocsAutomator — creates Google Docs documents or PDF files. 

3. Make’s integrations — which can be integrated with any document-creation app of your choosing, even something as simple as custom Microsoft Word documents.
   
   If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one way that you can instantly trigger a Make automation from Airtable.

4. Fillout’s advanced forms for Airtable — which offers hundreds of features that Airtable’s forms don’t offer, such as the ability to automatically generate custom PDF files from a form submission.
   
   I show off this feature on this Airtable podcast episode:

   Using Fillout to create an eSignature approval process with PDF file creation.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with this or anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld