Generate n8n forms from Airtable and BaseRow tables

by Jimleuk ✓ · 2,982 views · created 2024-12-03 · Engineering

What this workflow does

This workflow has 26 nodes and runs when someone submits an n8n form (“Airtable to n8n Form”) (plus 1 other trigger). Along the way it connects Airtable. It also calls api.baserow.io over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Airtable to n8n Form”) (plus 1 other trigger).

1. Get Base Schema (Airtable): get schema (base)
2. Baserow List Fields (HTTP Request): calls an HTTP API
3. Filter: keeps only the items that match a condition
4. Covert to n8n Form Fields (Code): runs custom JavaScript code
5. Fields to List (Split Out): splits a list into separate items
6. Filter: keeps only the items that match a condition
7. Covert to n8n Form Fields (Code): runs custom JavaScript code
8. Combine Fields (Aggregate): combines items into one
9. Filter: keeps only the items that match a condition
10. Render Form (n8n Form): shows the next form page

…plus 14 more steps. See the full node list below.

Services it uses

Airtable

HTTP calls to: api.baserow.io

Before you upgrade to n8n 3.0

Nodes used (8)

• Airtablen8n-nodes-base.airtable
• n8n Form Triggern8n-nodes-base.formTrigger
• Filtern8n-nodes-base.filter
• Aggregaten8n-nodes-base.aggregate
• n8n Formn8n-nodes-base.form
• Coden8n-nodes-base.code
• Split Outn8n-nodes-base.splitOut
• HTTP Requestn8n-nodes-base.httpRequest

From the author

This n8n template showcases a cool feature of n8n Forms where the form itself can be defined dynamically using the form fields schema. It may be debateable how useful this template actually is since both Airtable and Baserow provide form interfaces already…

View the original on n8n.io → Check your own copy