Skip to main content

Hi, I’m writing a program in Node.js using AIrtable API that fetches the record from Airtable and sends it to WhatsApp. The problem I’m facing is that for example, there are three columns





COL1 | COL2 | COL3



I’m trying to achieve that if any of the columns are empty, it skips that one and moves on to the another.


But when I execute col1 == null || col1 == undefined it returns false. This statement returns true only for the last column.



Also when I execute col1.length it returns 1 but for the last column, it returns Cannot read properties of undefined (reading 'length')



I don’t understand why the empty cells/ column before the last one doesn’t return undefined.

What is the field type of each column?


Can you see the actual value of the field?


Is it possible that the field looks empty but actually has a value?


For example, could the field have a single space character?


All the fields have long text as their type and no I checked all the fields are same as the last one.


But only the last one returns undefined rest of them returns length as 1.


All the fields have long text as their type and no I checked all the fields are same as the last one.


But only the last one returns undefined rest of them returns length as 1.


Are any of them lookup fields?


Do any of them have rich text formatting turned on?


Are any of them lookup fields?


Do any of them have rich text formatting turned on?


No to both questions


No to both questions


What are the actual values? Have you used console.log to see their values?



If you use scripting from within the base, what are the actual values?


Yes I have



Col 1 and Col2 log return a blank and length 1


Col 3 returns undefined.


Yes I have



Col 1 and Col2 log return a blank and length 1


Col 3 returns undefined.




What do you mean by “a blank”? What is the data type? (Blank is not a data type.) Is it a blank string? Is it an array? Is it a string with a single white space character, such as a space, a tab, or a new line?




What do you mean by “a blank”? What is the data type? (Blank is not a data type.) Is it a blank string? Is it an array? Is it a string with a single white space character, such as a space, a tab, or a new line?





It really looks like the value is a text string with a single space character.


It really looks like the value is a text string with a single space character.


Idk why, but I duplicated the table and records, works fine now, Thank you for your time and assistance.


Reply