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