How to Create Certificates of Conformity in Airtable Automatically

If you manage product quality data in Airtable, you're probably copying batch numbers, specifications, and test results into Word templates every time you need to issue a Certificate of Conformity. According to ASQ research, quality documentation is the most time-consuming aspect of QMS compliance. That manual process is slow, error-prone, and creates compliance risk.

This guide shows you how to generate professional Certificate of Conformity PDFs directly from your Airtable data using TypeFlow. No coding required.

By the end, you'll have a system that:

• Creates CoCs with product specs, batch numbers, and test results from Airtable
• Pulls data from linked tables for suppliers, inspections, and compliance standards
• Generates certificates on-demand or automatically when batches are approved
• Includes authorized signatures with legally binding e-signature

Key Takeaways

• Page Designer limitations: Airtable's built-in tool can't bulk export, has limited formatting, and doesn't support linked record data or automation
• Three generation methods: Manual export, Zapier/Make workflows, or native document automation with TypeFlow
• Template-first approach: Create a Google Docs template with {{variables}} that map directly to your Airtable fields
• Linked records support: Pull test results, supplier data, and inspection records from related tables automatically
• Full automation: Trigger CoC generation when batch status changes to "Approved" or "Ready to Ship"

What Is a Certificate of Conformity

A Certificate of Conformity (CoC) is a document issued by a manufacturer or supplier confirming that a product meets specified standards, regulations, or customer requirements. It's required in most manufacturing, import/export, and supply chain operations.

Common use cases:

• Manufacturing: Confirms finished goods meet quality specifications before shipment
• Import/Export: Required by customs authorities for regulatory compliance
• Supply Chain: Provides traceability and accountability between vendors and buyers
• Medical Devices: Mandatory for regulatory approval and lot release
• Aerospace: Required for AS9100 and FAA compliance

A CoC typically includes product identification, batch/lot numbers, applicable specifications, test results, compliance declarations, and an authorized signature.

Why Airtable Page Designer Falls Short for Certificates of Conformity

While Airtable's Page Designer works for simple one-page documents, it has critical limitations for professional CoC generation.

No Bulk PDF Export

Page Designer exports one record at a time. When you need to issue CoCs for 50+ batches before a shipment, clicking through each record isn't sustainable.

Limited Linked Record Support

CoCs often need to pull test results from a separate Inspections table, supplier data from a Suppliers table, and compliance standards from a Standards table. Page Designer struggles with nested linked record data.

No Automation or E-Signature

Quality workflows require automated generation when batches are approved, plus authorized signatures for compliance. Page Designer offers neither.

Three Methods to Generate Certificate of Conformity PDFs

Method 1: Manual Export with Page Designer

Only suitable for occasional, simple certificates for individual batches. You design a layout in Page Designer, then manually export PDFs one record at a time. Not recommended for serious quality management operations.

Method 2: Zapier or Make with a PDF Tool

Connect Airtable to an external PDF generation service through Zapier or Make. This works but requires managing multiple subscriptions, troubleshooting across platforms, and dealing with webhook complexity.

Method 3: Native Document Automation with TypeFlow

Use a dedicated document automation tool that integrates directly with Airtable. Create templates in Google Docs with {{variables}}, map them to your Airtable fields, and generate CoCs in bulk or on autopilot.

This guide focuses on Method 3 - the most efficient approach for quality management workflows.

How to Set Up Your Airtable Base for Certificate of Conformity Data

Your Airtable base needs the right structure before you can generate certificates. Here's a recommended setup organized by data type.

Product and Batch Identification Fields

These fields identify what the certificate covers:

Specification and Test Result Fields

These fields document what was tested and the results:

For complex products with multiple tests, create a separate Tests or Inspections table and link it to your main Products/Batches table. TypeFlow can pull data from linked records.

Compliance and Certification Fields

These fields specify which standards the product meets:

Signatory and Date Fields

These fields appear on the signature block:

Using Linked Records for Test Results and Supplier Data

For larger operations, create separate tables and link them:

Suppliers Table:

• Supplier Name
• Supplier Code
• Contact Email
• Certifications

Tests/Inspections Table:

• Test Parameter
• Specification
• Measured Value
• Pass/Fail
• Inspector Name

Batches Table:

• Batch Number
• Product (Link to Products)
• Supplier (Link to Suppliers)
• Test Results (Link to Tests)
• CoC Status

In your template, access linked fields with dot notation: {{Product.Part_Number}}, {{Supplier.Name}}, {{Tests.Measured_Value}}.

How to Design Your Certificate of Conformity Template

TypeFlow supports both Google Docs templates and Template Builder. For CoCs with test result tables and complex formatting, Google Docs often provides more control.

Standard CoC Layout and Required Sections

A professional Certificate of Conformity typically includes:

1. Header - Company logo, document title, certificate number
2. Product Identification - Product name, part number, batch/lot number, quantity
3. Specification Block - Applicable standards, test methods, acceptance criteria
4. Test Results - Measured values, pass/fail status (often in a table)
5. Compliance Declaration - Statement confirming conformity to requirements
6. Signature Block - Authorized signatory name, title, date, signature

Adding Airtable Field Variables

Use placeholders that match your Airtable field names:

CERTIFICATE OF CONFORMITY

Certificate No: {{Certificate_Number}}
Issue Date: {{Issue_Date}}

PRODUCT IDENTIFICATION
Product Name: {{Product_Name}}
Part Number: {{Part_Number}}
Batch/Lot Number: {{Batch_Number}}
Quantity: {{Quantity}} {{Unit_of_Measure}}
Manufacturing Date: {{Manufacturing_Date}}

APPLICABLE STANDARDS
{{Applicable_Standards}}

DECLARATION OF CONFORMITY
We hereby certify that the above-referenced product has been
manufactured and tested in accordance with the applicable
standards and conforms to all specified requirements.

This certificate is valid until {{Expiration_Date}}.

AUTHORIZED BY
_______________________
{{Authorized_Signatory}}
{{Signatory_Title}}
Date: {{Issue_Date}}

Including Test Results in a Table

For products with multiple test parameters, use a table with {{loop_0}} to repeat rows for each linked test record:

TEST RESULTS

| Parameter | Specification | Measured | Result |
| {{loop_0}}{{Test_Parameter}} | {{Specification}} | {{Measured_Value}} | {{Test_Result}} |

The row with {{loop_0}} repeats for each linked record in your Tests field.

Template Builder (Visual Editor)

Template Builder is TypeFlow's visual HTML editor - an alternative to Google Docs when you want precise control over your certificate layout.

Why use Template Builder for CoCs:

• Drag-and-drop layout control
• Consistent formatting across all certificates
• No Google account required
• Pre-built compliance document blocks
• Easy logo and certification mark placement

To use Template Builder:

1. Start a new flow in TypeFlow
2. Choose "Template Builder" instead of Google Docs
3. Add text blocks with your CoC sections
4. Insert variables from the Fields panel
5. Add a table for test results
6. Include signature block at the bottom

Connect TypeFlow to Your Airtable Base

If not already done, connect TypeFlow to your Airtable base:

1. Sign in to your TypeFlow account

2. Visit this link to integrate Airtable with TypeFlow: Integrate Airtable with TypeFlow

3. Select "Connect to Airtable"

4. Authorize TypeFlow to access your Airtable account

5. Select the base and table you want to use (in this case, your Batches or Products table)

Configure Your Certificate of Conformity Workflow

Once connected, configure your flow in TypeFlow:

1. Sign in to your TypeFlow account

2. Click "Start a new automation workflow"

3. Select "Google Docs"

4. Pick your CoC template

Now connect TypeFlow to your Airtable base:

1. Select your Airtable base from the dropdown menu

2. Choose the specific table where you want to generate your PDF (in your case the Batches or Products table)

3. Set up the attachment field where generated CoC PDFs will be saved

Pro Tip: Number Formatting

If you need to adjust the number formatting for measurements or specifications on your CoC, you can adjust your locale settings. It will format values according to your regional standards (decimal separators, etc.).

4. Map Airtable fields to your template variables

Pro Tip: Accessing Linked Records

No need to add rollup fields to access test results or supplier data from linked tables! TypeFlow supports navigation through up to 3 levels of nested linked records. Just 2 clicks to access any field from a linked table.

1. Select the linked record field from the dropdown (e.g., Tests, Supplier)
2. Click the breadcrumb that appears below the field
3. Select the field you want to access (e.g., Measured Value, Supplier Name)

For deeper navigation like Batch → Product → Supplier → Certification, just keep clicking through the breadcrumbs!

5. For test results stored in a linked table, select your linked Tests field to populate the {{loop_0}} rows

6. Optionally set a custom filename format like COC-{{Batch_Number}}-{{Issue_Date}}

How to Generate Certificates of Conformity

Once your flow is configured, you have three ways to generate CoCs depending on your workflow needs.

Option 1: Manual Generation with Button Field

Add a button field to your Batches table for quick one-click generation:

1. In Airtable, create a new Button field called "Generate CoC"
2. Set the action to "Open URL"
3. In TypeFlow, copy the generation URL from your flow settings
4. Paste the URL in the button configuration

Click the button on any batch record to generate its Certificate of Conformity instantly. The PDF saves to your attachment field within seconds.

Best for: QA inspectors generating CoCs after completing inspections, one-off generation for urgent shipments, or testing your flow before setting up automation.

Option 2: Bulk Generation with TypeFlow Extension

When you have dozens or hundreds of batches ready to ship, generating CoCs one by one isn't practical. The TypeFlow extension supports bulk generation.

1. Install the TypeFlow extension from Airtable's extension marketplace
2. Enter your API key (found in your flow settings)
3. Filter your view to "Ready for CoC" batches
4. Select the records you want to generate PDFs for
5. Click Generate

The extension creates PDFs for all selected records and saves them to your configured attachment field. Generate hundreds of CoCs in one action.

Best for: End-of-shift processing, shipment preparation, or generating CoCs for an entire production run.

Option 3: Automated Generation with Airtable Automations

Full automation removes manual steps entirely. Use Airtable Automations to trigger CoC generation automatically when batches are approved - no clicks required.

According to Gartner research, 80% of executives believe automation can be applied to any business decision. CoC generation is a prime candidate.

In this example, we'll trigger the automation when a batch status changes to "Approved."

1. Go to Automation in Airtable

2. Click on "Add a trigger" and choose When a Record matches a condition

3. Select the table you want to trigger the automation on (in this case the Batches table)

4. Select the field you want to trigger the automation on (in this case the Status field)

5. Select the condition you want to trigger the automation on (in this case "is")

6. Select the value you want to trigger the automation on (in this case "Approved")

7. Now choose a record that matches the condition

8. Click on Add an advanced logic or action

9. Pick Run Script. A new popup appears.

10. Go back to TypeFlow and select Automation in Airtable. Copy the script.

11. Paste the script in the popup.

12. In the left-side of the popup, configure the variable input record_id. Select Airtable Record ID from the dropdown.

13. Test your script and verify it works. Most errors come from the record_id variable not being configured correctly (see step 12).

Best for: High-volume operations, triggering generation when Status = "Approved", or when QA Inspector completes testing.

Sending Certificates to Customers Automatically

Once your CoC is generated, you can automatically email it to customers. TypeFlow includes integrated email delivery - no external tools required.

1. Open your flow and click the Email tab
2. Toggle Enable Email Delivery to ON
3. Set the Recipient to your Customer Email field from Airtable
4. Configure subject and body with {{variables}} from your record

After each generation, the CoC is automatically sent to your customer as a PDF attachment. This works with all three generation methods - email sends in the background without blocking document generation.

Adding E-Signatures to Your Certificates of Conformity

Many industries require authorized signatures on CoCs. TypeFlow includes built-in e-signature that is legally compliant under eIDAS and the ESIGN Act.

Single Authorized Signatory Workflow

Most CoCs require one QA manager or authorized person to sign:

Step 1: Add signature placeholders to your template:

AUTHORIZED BY

Signature: {{e-signature.signature_1}}
Name: {{e-signature.text_1}}
Title: {{e-signature.text_2}}
Date: {{e-signature.date_1}}

Step 2: In TypeFlow, enable e-signature in your flow settings:

Step 3: Configure the signer. Map the email to your Signatory Email field from Airtable:

Step 4: When the CoC generates, the signatory receives an email to sign:

Step 5: The signer reviews the document and completes the signature fields:

After signing, the completed PDF with audit trail saves to Airtable automatically.

Multi-Signer QA Approval Workflow

For organizations requiring multiple approvals (e.g., QA Inspector + QA Manager):

Step 1: Add signature placeholders for each signer:

QA INSPECTOR

Signature: {{e-signature.signature_1}}
Name: {{e-signature.text_1}}
Date: {{e-signature.date_1}}

QA MANAGER APPROVAL

Signature: {{e-signature.signature_2}}
Name: {{e-signature.text_2}}
Date: {{e-signature.date_2}}

Step 2: Configure signers and choose Sequential signing mode. This ensures Inspector signs first, then Manager receives their notification:

Step 3: Certificate is only complete when both have signed.

Certificate of Completion

The signed PDF includes a Certificate of Completion with:

• Timestamps for each signing action
• IP addresses and geographic location
• Browser and device information
• SHA-256 document hash for integrity verification

This audit trail meets FDA 21 CFR Part 11 requirements for electronic records and signatures.

Industry-Specific CoC Requirements

ISO 9001 / ISO 14001 Compliance

For ISO-certified operations, your CoC should include:

• Reference to the applicable ISO standard
• Scope of certification
• Traceability to raw materials (via linked records)
• Authorized signatory from QMS-approved list

CE Marking (European Union)

CE-marked products require:

• Declaration that product meets EU directives
• Reference to harmonized standards used
• Notified Body number (if applicable)
• Technical documentation reference

FDA / 21 CFR Part 11 (Pharmaceuticals)

For FDA-regulated products:

• Lot/batch genealogy (linked records)
• Complete test results with specifications
• Electronic signature with audit trail (TypeFlow e-signature meets this requirement)
• Expiration date if applicable

Automotive (IATF 16949)

For automotive suppliers:

• PPAP reference if applicable
• Material certifications (linked records)
• Dimensional inspection results
• Process capability data

Best Practices for High-Volume CoC Generation

Use Clear Field Naming Conventions

Match your Airtable field names to template variables exactly:

Create a "Ready for CoC" View

Filter only records ready for certificate generation:

• Status = "Approved"
• All test results = "Pass"
• CoC Attachment is empty

Track CoC Generation Status

Add a "CoC Status" single select field with options:

• Pending
• Generated
• Signed
• Sent to Customer

Use Airtable Automations to update this field based on TypeFlow actions.

Use Autonumber for Certificate IDs

Ensures unique, sequential certificate numbers without manual entry. Format: COC-2026-{{autonumber}}

Troubleshoot Common Issues

Variables Not Populating

Causes:

• Typo in variable name (check spelling and underscores)
• Field not mapped in TypeFlow
• Empty field in Airtable

Fix: Compare your template variables against your Airtable field names. They must match exactly.

Linked Record Data Not Appearing

Causes:

• Linked field not configured in mapping
• No linked records in Airtable
• Wrong table selected

Fix: In TypeFlow mapping, click "Configure" on the linked field to expand and map nested fields.

E-Signature Not Sending

Causes:

• Signatory email field is empty
• Email field not mapped correctly
• E-signature not enabled in flow settings

Fix: Verify the email field has a valid address and is correctly mapped in the E-Signature tab.

Generate Production-Ready Certificates of Conformity in Minutes

Transform CoC generation from a manual bottleneck into an automated system that runs reliably. Stop copying data into documents manually, stop clicking through Page Designer one record at a time, and stop worrying about compliance errors.

With TypeFlow, you set up your template once and generate professional, compliant certificates for every batch - whether you have 10 or 1,000.