Fix for INVALID_VALUE_FOR_COLUMN for single line text column

[Case_Larsen]

This behavior started a couple weeks ago. Using Airtable’s airtable JS API v0.5.8, I used to be able to call update() successfully on table where the value for column to be updated was a javascript number.

Now it returns the error INVALID_VALUE_FOR_COLUMN. When I convert the number to a string before passing it into the update() call, it works.

Just a workaround FYI for others. It seems like is some stronger API checking going on on the Airtable server API side.

[Elmawkaa_Admin]

It works when you use the {typecast: true} parameter
example:

base(‘Deal’).create({
“Quantity”: 720,
“PaymentMethod”: “Cash”,
}, {typecast: true}, function(err, record) {
if (err) {
console.error(err);
return;
}
console.log(record.getId());
});

[Jose_Vitor_Lope]

Same error here.

Solved by adding "typecast": true and changing SingleLineText type to LongText

[kirkbross]

Case_Larsen:

'Field SingleLineText cannot accept the provided value

I wish this said: Field SingleLineText cannot accept the provide value… because e.g. its type ‘Object’ is incompatible with the ‘String’ type of the field. (or something like that).