Skip to main content

Create pdf and store it as attachment


Forum|alt.badge.img

I would like to generate a PDF out of a record (to easily visualize the data) and attach the record as an attachment. I would like to do this for all the records in my base.

Any ideas on how to do this using either a script or Zapier/Integromat, possible using Formstack (does not have to use formstack though)? Would love any insight - I am capable of coding in JavaScript and can leverage that if necessary.

22 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • 15 replies
  • August 11, 2020

Hi there!

Happy to help you with this. Our Page Designer block would be perfect for this use case. You can display a record on a page in any template you create. You can include different fields on the page and each page displays one record. When you’re done, you can print out your records or turn them into PDFs to then attach to your record in an attachment field.

You can watch a video explaining this block in more detail here: https://support.airtable.com/hc/en-us/articles/115013405168-Page-designer-block-overview

Hope this helps!


Justin_Barrett
Forum|alt.badge.img+20

I do something like this for my business invoices. I build an HTML version of the invoice (pieces made in various linked tables, all rolled up into the main invoice and assembled via some helper formulas), and click a field button to trigger a script that calls an Integromat webhook, passing the record ID. The Integromat scenario pulls the HTML from the Airtable record, sends it to CloudConvert to convert it to a PDF file, then saves the PDF into an attachment field in Airtable.


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8801 replies
  • August 11, 2020
If you'd like to automate the process of creating a PDF document from Airtable, here are some of your best options:
 
1. One of the most popular PDF creation tools for Airtable is DocuMint's document automations for Airtable. DocuMint has an Airtable extension and also offers full Make support.
 
2. Another popular tool is Docs Automator, which integrates with Google Docs.
 
3. Plumsail Documents another app that has an Airtable extension and also offers full Make support.
 
4. Formstack Documents also has an Airtable extension and also offers full Make support.
 
5. However, you can choose ANY document creation app that you would like, and automate the PDF creation process by using Make’s automations & integrations. You can even use good old fashioned Microsoft Word or Microsoft Excel.
 
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.
 
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

  • New Participant
  • 1 reply
  • October 23, 2021
Carly_Taylor wrote:

Hi there!

Happy to help you with this. Our Page Designer block would be perfect for this use case. You can display a record on a page in any template you create. You can include different fields on the page and each page displays one record. When you’re done, you can print out your records or turn them into PDFs to then attach to your record in an attachment field.

You can watch a video explaining this block in more detail here: https://support.airtable.com/hc/en-us/articles/115013405168-Page-designer-block-overview

Hope this helps!


Hello i just want a detail about the Puneet question. Page designer can make a pdf right but it cant do it automaticaly right? i find the way to export the pdt with the printer function but is it impossible do export pdt automaticaly when a record is done? I will be very happy if this way exist but can you confirm it? Thanks Carly


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8801 replies
  • October 23, 2021
loic_DR wrote:

Hello i just want a detail about the Puneet question. Page designer can make a pdf right but it cant do it automaticaly right? i find the way to export the pdt with the printer function but is it impossible do export pdt automaticaly when a record is done? I will be very happy if this way exist but can you confirm it? Thanks Carly


You can also use DocuMint to do this as well (with or without Make.)


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • October 23, 2021
loic_DR wrote:

Hello i just want a detail about the Puneet question. Page designer can make a pdf right but it cant do it automaticaly right? i find the way to export the pdt with the printer function but is it impossible do export pdt automaticaly when a record is done? I will be very happy if this way exist but can you confirm it? Thanks Carly


Correct. Getting a report from Page Designer into an attachment field is a multi-step process.

In order to get a fully automated system, you currently must use at least one third party service.


Hannah_Wiginton
Forum|alt.badge.img+18
loic_DR wrote:

Hello i just want a detail about the Puneet question. Page designer can make a pdf right but it cant do it automaticaly right? i find the way to export the pdt with the printer function but is it impossible do export pdt automaticaly when a record is done? I will be very happy if this way exist but can you confirm it? Thanks Carly


On2Air has a Google Docs integration that allows you to automatically generate documents using your Airtable data, then exports it as a PDF attachment back to your Airtable base.

Here’s an example use-case - How to Create a Sales Contract PDF in Google Docs

and more info about the Google Docs function


Forum|alt.badge.img+9
  • Inspiring
  • 24 replies
  • April 25, 2022
Justin_Barrett wrote:

I do something like this for my business invoices. I build an HTML version of the invoice (pieces made in various linked tables, all rolled up into the main invoice and assembled via some helper formulas), and click a field button to trigger a script that calls an Integromat webhook, passing the record ID. The Integromat scenario pulls the HTML from the Airtable record, sends it to CloudConvert to convert it to a PDF file, then saves the PDF into an attachment field in Airtable.


The HTML solution is clever. Bypass document services entirely.


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • April 25, 2022
Jeff_Haskin wrote:

The HTML solution is clever. Bypass document services entirely.


It doesn’t completely bypass document services. Currently there is no “one-click” solution to creating a pdf attachment that doesn’t involve at least one third party service.

In Justin’s case, he uses a combination of Integromat and CloudConvert. There are also other services. I tend to use PDFShift and I wrote the app Low Tech PDF that use PDFShift to create pdf attachments with one click.


Justin_Barrett
Forum|alt.badge.img+20
kuovonne wrote:

It doesn’t completely bypass document services. Currently there is no “one-click” solution to creating a pdf attachment that doesn’t involve at least one third party service.

In Justin’s case, he uses a combination of Integromat and CloudConvert. There are also other services. I tend to use PDFShift and I wrote the app Low Tech PDF that use PDFShift to create pdf attachments with one click.


To clarify, I no longer use Integromat/Make (for anything). I now call CloudConvert’s API from an Airtable automation and save the resulting PDF directly to an attachment field.

Re: bypassing document services, I think that @Jeff_Haskin was referring to a service like Google or Documint where a document would be created—directly or via a template—before exporting as a PDF file. That said, the line is a bit fuzzy in this case as HTML might be considered a form of document, and therefore CloudConvert might be considered a document service, even though the original HTML “document” is never saved anywhere.


  • Participating Frequently
  • 5 replies
  • August 15, 2022

Hey there,

For anyone looking, another great solution you might want to take a look at is Plumsail Documents. You can upload any DOCX template and use it to create documents from record data in Airtable. The integration is based on Zapier.

How to auto generate contracts from Airtable data in Zapier — Plumsail Documents

It is a paid solution, but you can take a free 30-day trial on their website.


Tanel_Tahepold
Forum|alt.badge.img+1

Hello,

One option is the PDF Generator API extension which allows you to build document templates and merge them with data you have on Airtable. Templates are hosted in the cloud, so there is no need to store Docx or HTML files. 

Disclaimer: I'm the founder of PDF Generator API


Forum|alt.badge.img+2
  • New Participant
  • 2 replies
  • February 1, 2024
kuovonne wrote:

Correct. Getting a report from Page Designer into an attachment field is a multi-step process.

In order to get a fully automated system, you currently must use at least one third party service.


Is this still the case that to get a fully automated service using Page Designer that you still need a third party? We are only allowed  to use airtable extensions in our company.


JavierGO
Forum|alt.badge.img+7
  • Participating Frequently
  • 16 replies
  • February 2, 2024

Looking for this option too, to generate a pdf automatically in airtable.

Have things changed since your 2020-2022 replies?


Forum|alt.badge.img+16
Tanel_Tahepold wrote:

Hello,

One option is the PDF Generator API extension which allows you to build document templates and merge them with data you have on Airtable. Templates are hosted in the cloud, so there is no need to store Docx or HTML files. 

Disclaimer: I'm the founder of PDF Generator API


@Tanel_Tahepold Is there a way to trigger the document to be generated and attached to the record without a human pressing a 'Generate" button? 


Tanel_Tahepold
Forum|alt.badge.img+1
Leslie_Burke wrote:

@Tanel_Tahepold Is there a way to trigger the document to be generated and attached to the record without a human pressing a 'Generate" button? 


It is possible to use the Scripting functionality in Airtable, but it requires some JavaScript know-how. You can check our example code on GitHub.

  1. https://github.com/pdfgeneratorapi/airtable-scripting/blob/main/index.js
  2. https://support.pdfgeneratorapi.com/en/article/how-to-integrate-with-airtable-1h5xdjw/#2-scripting

Forum|alt.badge.img+2
  • New Participant
  • 1 reply
  • August 14, 2024

Hi, i'm fairly new here, but is there some way we can add this to the Airtbale feature request list? Because this would really help my proces.


Forum|alt.badge.img+4
  • New Participant
  • 2 replies
  • August 22, 2024

I have used www.craftmypdf.com and I have created good documents with the API between both tools. 

Here there is a link with the step by step process:

https://craftmypdf.com/blog/how-to-automatically-create-pdf-event-passes-with-airtable/


Forum|alt.badge.img+4
  • Participating Frequently
  • 12 replies
  • September 3, 2024
Leslie_Burke wrote:

@Tanel_Tahepold Is there a way to trigger the document to be generated and attached to the record without a human pressing a 'Generate" button? 


Hi! Yes, it's possible to do this with a script and a document generation extension. First, install and configure the document generation extension. Then, go to "Automations," set up a trigger, and add the "Run script" action. Here's an example using the Plumsail Documents extension for Airtable  https://plumsail.com/blog/airtable-document-automation-in-interface


Forum|alt.badge.img+4
  • Participating Frequently
  • 12 replies
  • September 3, 2024
JavierGO wrote:

Looking for this option too, to generate a pdf automatically in airtable.

Have things changed since your 2020-2022 replies?


Hi! Yes, there are several extensions for Airtable that can generate documents, which can be automated with a script and a trigger in Airtable Automations. Article Create and manage documents in Airtable Interfaces and Automations explains how to do it using the Plumsail Documents extension as an example.


Forum|alt.badge.img+8
  • Participating Frequently
  • 68 replies
  • October 7, 2024

If you're looking for a solution, Typeflow can help you quickly generate PDFs from Airtable data using Google Docs templates. It's straightforward and efficient.

Feel free to give it a try, and I'd love to hear your feedback! I'm also offering a lifetime plan for early users at just $100. Ping me if you're interested or have any questions.


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • April 4, 2025

You can use Templated (https://templated.io/) for automating PDF generation.


Here’s a tutorial to that:
https://templated.io/blog/automate-instagram-post-using-google-sheets-and-make/