I am trying to create a calculated field in smart connect that says - if the source field is blank - return empty string.
I must have a small error somewhere - been staring at it too long - what is wrong with this simple calculation?
if _Invoices = " "
then return empty.string
else return "_Invoices"
end if
Smart Connect returns an error: system.empty is not accessible in this context because it is considered "friend"