JunlgeDocs | IfEmpty function

In JungleDocs you can use the IfEmpty function to return certain fields if one is empty. In this tutorial you will learn how to do this.

IfEmpty(arg1; arg2) – returns arg2, if arg1 has empty (blank value in SharePoint) value.

arg1, arg2 can be any expression – from field name, record set to constant values and other formulas.

For example:

IfEmpty(Title; "Item has no title") - Will return text "Item has no title", if Title field is empty.

Note: If you want to use IfEmpty function in excel repeating, you should only use this function instead of column title. Using both =FieldName and IfEmpty(FieldName; "If it is empty") might cause errors in Excel sheets.

Still need help? Contact Us Contact Us