Help

Re: Fix for INVALID_VALUE_FOR_COLUMN for single line text column

4829 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Case_Larsen
4 - Data Explorer
4 - Data Explorer

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.

12 Replies 12
Elmawkaa_Admin
5 - Automation Enthusiast
5 - Automation Enthusiast

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());
});

Same error here.

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

kirkbross
5 - Automation Enthusiast
5 - Automation Enthusiast

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