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

说明与用途

Airtable 422 INVALID_VALUE_FOR_COLUMN 错误发生在 Make 发送与字段类型不匹配的数据时。通过检查 Airtable 字段类型并在 Make 中转换值（parseNumber、formatDate、boolean、split、record IDs）来修复。

问题

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.

结果

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

工作流

• 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.

证据

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

来源

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.

来源

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

来源