If a value exists, take the value, otherwise ignore

I have a scenario that looks up values in a Notion database and creates Airtable items.

One of the fields to populate in the new Airtable item is an image, which is taken from Notion.

However, I want the Airtable item to still be created even if there isn’t an image in Notion.

I think I can achieve this with some kind of “ifempty()” formula in the image field in Notion, so if there is no image, Make doesn’t even attempt to create that field, but I haven’t been able to get it to work.

Screenshot 2023-10-20 at 21.22.10

Any tips much appreciated.

Hi Alastair,

I believe the following IML function will provide you with what you need.

E.g ifempty(x;) will return x if x exists, else it will return nothing and not create the field.