Hi, @Lean_Junio,
Yes, typecast also works when updating records.
Airtable’s API documentation for the “update” command states:
Automatic data conversion for update actions can be enabled via typecast parameter. See create record for details.
I verified this using the airtable.js library. Here’s my Node.js script:
'use strict';
var Airtable = require('airtable');
var apiKey = 'replace this string with an authentic API key';
var baseID = 'replace this string with an authentic Base ID';
var recordID = 'replace this string with an authentic record ID';
var base = new Airtable({apiKey: apiKey}).base(baseID);
base('SMS').update([
{
id: recordID,
fields: {
'my text field': '45'
}
}
], {typecast: false}, function(err, records) {
if (err) {
console.error(err);
return;
}
console.log('Success!');
});
(By the way: you can improve the formatting of code blocks here on the forum by indenting the code by four spaces.)
I replaced the strings which start “replace this value” with authentic values and ran the script. The code reached the console.error statement and printed the following error:
AirtableError {
error: 'INVALID_VALUE_FOR_COLUMN',
message: 'Field "my text field" cannot accept the provided value',
statusCode: 422
}
That’s because in my Base, the field named “my text field” is a text field. Airtable rejected my attempt to set it to a string value (even though the string describes a number).
But once I enabled type coercion by changing {typecast: false} to {typecast: true}, then the script reached the console.log statement and printed:
Success!
…and the value of the targeted cell was updated to the number 45 (because Airtable coerced the string value into a number value).
