How to exclude Null values

Hi there,

Would you be able to share a screenshot of the filter you're employing?

Are you applying it within the Airtable Search Module, or in the filter that follows it?

It's a bit challenging for me to grasp the situation fully without a visual reference.

Best,
Richard

Hi Richard.

Thanks for your time.

You'll find the screenshot below.

I'm trying to add a default date for when an Airtable cell is empty.

Am I correct in understanding that when I initiate a call from callin.io to Airtable, I should be using Airtable's coding?

Regards,

Jesper

Skærmbillede 2022-06-30 kl. 08.14.25.jpg2254×1906 315 KB

This looks like a great workflow - congrats!

But I have to answer your question with a “no”. You cannot use AirTable’s coding in callin.io; rather, you need to use variables.
I guess one result from the “Search Records” Modules contains the variable “StartedDate”? You need to put it in there as you do with the GoogleSheets value “InsertDate” (it has to look the same). Please remove {} and ‘’.

Dates might be hard to come by sometimes, so let’s see how this works, and if not, please send another screenshot.

Best,
Richard

Hello again,

Does this appear better? (See the first screenshot)

My apologies for not being more specific about the code. I was referring to the formula code within the Airtable Search Records module. (See the second screenshot)

Best regards,

Jesper

Skærmbillede 2022-06-30 kl. 09.41.03.jpg2418×1918 326 KB

Skærmbillede 2022-06-30 kl. 09.42.07.jpg2454×1904 297 KB

The first option appears to be better!

However, there seems to be something missing in the Ifempty(…)>addDays(…) statement. I suspect an if statement is required, or perhaps a complete change to that part. Could you clarify which scenarios should pass this filter and which should not? The current description only states "if insert date is within 1 month." Does this mean 1 month from the current date, or 1 month from the StartedDate?

You can utilize the "run this module only" option and check if you receive any results by using the search record module.