Make Airtable 422 INVALID_VALUE_FOR_COLUMN: match the value to the field type

Description and use

Airtable 422 INVALID_VALUE_FOR_COLUMN errors happen when Make sends data that doesn’t match the field type. Fix by checking the Airtable field type and converting the value in Make (parseNumber, formatDate, boolean, split, record IDs).

Problem

Airtable 422 INVALID_VALUE_FOR_COLUMN errors occur when Make sends data that does not match the field type, such as text into a number field or a string "true" into a checkbox.

Outcome

After converting values to match Airtable field types, the 422 INVALID_VALUE_FOR_COLUMN errors disappear and records are created or updated successfully.

Workflow

• Open the failed run in History and click the Airtable module’s bubble to view the input bundle sent to Airtable.
• Identify the field name or ID mentioned in the error message.
• Check the field type in Airtable (Number, Checkbox, Date, Single select, Multiple select, Linked record).
• Convert the value in Make’s mapping: use parseNumber() for numbers, formatDate() for dates, boolean for checkboxes, split() for multiple selects, and record IDs for linked records.
• If a source field may be empty, map it with ifempty() or omit it; to clear a field in Update a Record use the erase function.
• Run the module again with "Run this module only" using the same input to verify success.

Evidence

An Airtable 422 in Make means Airtable understood the address but rejected the data. With INVALID_VALUE_FOR_COLUMN the value you mapped does not fit the field type

Source

Open the failed run in History, click the Airtable module's bubble and read the input bundle. That is what Airtable received, not what the mapping panel shows.

Source

Check its type in Airtable, then convert in the mapping: parseNumber() for numbers, formatDate() for dates, a boolean for checkboxes, split() for multiple selects.

Source