Step 2: Connect Airtable Base Schema

This step fetches the Airtable base schema so downstream nodes can find or create the proper tables.

1. In Airtable Base Schema Fetch, set Resource to base and Operation to getSchema.
2. Set the Base value to [YOUR_ID].
3. Credential Required: Connect your airtableTokenApi credentials in Airtable Base Schema Fetch.
4. Ensure Format Submission Payload is connected to Airtable Base Schema Fetch in the flow.

Step 3: Set Up Submission Payload & Index Resolution

This step standardizes the incoming Webflow payload and identifies the Airtable "Form Index" table if it exists.

1. In Format Submission Payload, set Mode to raw and Include to none.
2. Set JSON Output to the exact expression:
   ={ "wf_id": "{{ $json._id }}", "wf_formId": "{{ $json.formId }}", "wf_formName": "{{ $json.name }}", "wf_requestDateTime": "{{ $json.d }}", "wf_data": {{ JSON.stringify(JSON.stringify($('Incoming Webflow Hook').item.json.data)) }} }
3. In Resolve Index Table ID, keep the provided JavaScript to set at_baseId, at_formIndexTableId, and at_currentFormTableId.
4. In Check Index Table Presence, leave the condition as:
   ={{ $json.at_formIndexTableId }} contains =tbl.

Check Index Table Presence routes to Lookup Form Index Record if the index table exists; otherwise it routes to Create Index Reference Table.

Step 4: Configure Index Lookup and Conditional Table Creation

This step checks the Form Index table for an existing mapping and decides whether a new data table is needed.

1. In Lookup Form Index Record, set Operation to search and Filter By Formula to ={FormId}='{{ $json.wf_formId }}'.
2. Set the Base field to ={{ $('Resolve Index Table ID').item.json.at_baseId }} and Table to ={{ $json.at_formIndexTableId }}.
3. Credential Required: Connect your airtableTokenApi credentials in Lookup Form Index Record.
4. Keep the Assign Form Table ID JavaScript as-is to read TableId from the lookup result.
5. In Validate Form Table Exists, keep the condition that checks:
   ={{ $json.at_currentFormTableId }} exists.

Step 5: Configure Airtable Table Creation & Index Updates

When no form data table exists, the workflow creates the "Form Index" table (if missing), creates a new form data table, and stores references.

1. In Create Index Reference Table, set URL to =https://api.airtable.com/v0/meta/bases/{{ $('Check Index Table Presence').item.json.at_baseId }}/tables and keep Method as POST.
2. Set JSON Body to the provided schema definition for the Form Index table.
3. Credential Required: Connect your airtableTokenApi credentials in Create Index Reference Table (OAuth2 is optional if used).
4. In Generate Form Data Table, set URL to =https://api.airtable.com/v0/meta/bases/{{ $('Resolve Index Table ID').item.json.at_baseId }}/tables and keep Method as POST.
5. Set JSON Body to the provided schema definition and use the table name expression:
   {{ $('Resolve Index Table ID').item.json.wf_formName }}
6. Credential Required: Connect your airtableTokenApi credentials in Generate Form Data Table (OAuth2 is optional if used).
7. Keep Store New Table ID JavaScript unchanged so it stores at_currentFormTableId and optionally at_formIndexTableId.
8. In Append Index Table Record, map fields using the expressions:
   FormId → {{ $('Resolve Index Table ID').item.json.wf_formId }},
   TableId → {{ $json.at_currentFormTableId }},
   FormName → {{ $('Resolve Index Table ID').item.json.wf_formName }},
   TableName → {{ $('Resolve Index Table ID').item.json.wf_formName }}
9. Credential Required: Connect your airtableTokenApi credentials in Append Index Table Record.

Step 6: Configure the Form Submission Output

This step writes the final Webflow submission record into the appropriate form-specific Airtable table.

1. In Add Form Submission Record, set Base to ={{ $('Resolve Index Table ID').item.json.at_baseId }}.
2. Set Table to ={{ $('Resolve Index Table ID').item.json.at_currentFormTableId }}.
3. Map the fields as follows:
   Id → {{ $('Resolve Index Table ID').item.json.wf_id }}
FormId → {{ $('Resolve Index Table ID').item.json.wf_formId }}
FormName → {{ $('Resolve Index Table ID').item.json.wf_formName }}
FormContent → {{ $('Resolve Index Table ID').item.json.wf_data }}
FormCreationDate → {{ $('Resolve Index Table ID').item.json.wf_requestDateTime }}
4. Credential Required: Connect your airtableTokenApi credentials in Add Form Submission Record.

Step 7: Test and Activate Your Workflow

Validate the workflow end-to-end using a test submission before activating it for production.

1. Click Execute Workflow and submit a test form in Webflow to trigger Incoming Webflow Hook.
2. Confirm that Append Index Table Record adds a new row in the "Form Index" table when a new form is encountered.
3. Verify that Add Form Submission Record creates a record in the correct form-specific Airtable table.
4. Once successful, toggle the workflow to Active for production use.