Airtable

Installation #

To install Airtable, follow these steps:

1. Download & unzip the file and place the airtable directory into your craft/plugins directory
2. Install plugin in the Craft Control Panel under Settings > Plugins
3. The plugin folder should be named airtable for Craft to see it.

Airtable works on Craft 2.4.x and Craft 2.5.x.

Airtable Overview #

Airtable is a human-friendly database solution that makes it super easy to manage both simple and complex, relational data.

Configuring Airtable #

<?php
return [
    // Find this on https://airtable.com/account
    'apiKey'        => '',

    // Find this on https://airtable.com/api
    'base'          => '',

    // The name of the table. Make sure the capitalization is correct
    'table'         => '',

    // Allowed field keys. This matches the field names in the table
    // If not defined, all fields defaults to string, and is required
    'allowedFields' => [
        // Defaults to required string
        'Name',
        'Notes',

        // Custom config
        [
            'type'     => 'email',
            'id'       => 'E-mail',
            'required' => true,
        ],
        [
            'type'     => 'select',
            'id'       => 'Single-select',
            'required' => false,
        ],
        [
            'type'     => 'multiselect',
            'id'       => 'Multi-select',
            'required' => false,
        ],
        [
            'type'     => 'checkbox',
            'id'       => 'Checkbox',
            'required' => true,
        ],
        [
            'type' => 'date',
            'id'   => 'Date',
        ],
        [
            'type' => 'number',
            'id'   => 'Number',
        ],
    ],
];

Using Airtable #

Example form

<form method="post" accept-charset="UTF-8">
    {{ getCsrfInput() }}
    <input type="hidden" name="action" value="airtable/save">
    <input type="hidden" name="redirect" value="airtable?success={Name}">
    <input type="hidden" name="enabled" value="1">

    {% macro errorList(errors) %}
        {% if errors %}
            <ul class="errors">
                {% for error in errors %}
                    <li>{{ error }}</li>
                {% endfor %}
            </ul>
        {% endif %}
    {% endmacro %}

    {% from _self import errorList %}

    {# Display server error #}
    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('server')) }}
    {% endif %}

    <label for="name">Name</label>
    <input id="name" type="text" name="Name"
            {%- if airtable is defined %} value="{{ airtable.Name }}"{% endif -%}>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Name')) }}
    {% endif %}

    <label for="email">E-mail</label>
    <input id="email" type="text" name="E-mail"
            {%- if airtable is defined %} value="{{ airtable['E-mail'] }}"{% endif -%}>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('E-mail')) }}
    {% endif %}

    <label for="notes">Notes</label>
    <textarea id="notes" name="Notes">
        {%- if airtable is defined %}{{ airtable.Notes }}{% endif -%}
    </textarea>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Notes')) }}
    {% endif %}

    <fieldset>
        {% set options = ['First option', 'Second option'] %}
        {% for option in options %}
            <label>
                <input type="radio" name="Single-select" value="{{ option }}"
                        {%- if airtable is defined and airtable['Single-select'] == option %} checked{% endif -%}>
                {{ option }}
            </label>
        {% endfor %}
    </fieldset>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Single-sele{ct')) }}
    {% endif %}

    <fieldset>
        {% set options = ['First option', 'Second option'] %}
        {% for option in options %}
            <label>
                <input type="checkbox" name="Multi-select[]" value="{{ option }}"
                        {%- if airtable is defined and option in airtable['Multi-select'] %} checked{% endif -%}>
                {{ option }}
            </label>
        {% endfor %}
    </fieldset>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Multi-select')) }}
    {% endif %}

    <fieldset>
        <label for="date">Date</label>
        <input id="date" type="date" name="Date"
                {%- if airtable is defined %} value="{{ airtable['Date'] }}"{% endif -%}>
    </fieldset>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Date')) }}
    {% endif %}

    <label>
        <input type="checkbox" name="Checkbox" value="1"
                {%- if airtable is defined and airtable['Checkbox'] %} checked{% endif -%}>
        Accept terms
    </label>

    {% if airtable is defined %}
        {{ errorList(airtable.getErrors('Checkbox')) }}
    {% endif %}

    <input type="submit" value="Save">
</form>

Find records in table

{% set records = craft.airtable.findRecords() %}
{% if records | length %}
    <table>
        <thead>
        <tr>
            <th>Name</th>
            <th>E-mail</th>
            <th>Date</th>
        </tr>
        </thead>
    {% for record in records %}
        {% set fields = record.getFields() %}
        <tr>
            <td>{{ fields['Name']|default('') }}</td>
            <td>{{ fields['E-mail']|default('') }}</td>
            <td>{{ fields['Date']|default('') }}</td>
        </tr>
    {% endfor %}
    </table>
{% endif %}

Find records in table with criteria

{% set records = craft.airtable.findRecords({
    'Name': 'Thomas'
}) %}
{% if records | length %}
    <table>
        <thead>
        <tr>
            <th>Name</th>
            <th>E-mail</th>
            <th>Date</th>
        </tr>
        </thead>
        {% for record in records %}
            {% set fields = record.getFields() %}
            <tr>
                <td>{{ fields['Name']|default('') }}</td>
                <td>{{ fields['E-mail']|default('') }}</td>
                <td>{{ fields['Date']|default('') }}</td>
            </tr>
        {% endfor %}
    </table>
{% endif %}

Airtable Roadmap #

Some things to do, and ideas for potential features:

• Support multiple tables
• Support attachments
• Add logging

Releases