FM - How to render "File cannot be found" differently in a Container calc field - 2nd Try
Posted on 2012-09-17
I have a calculated field rendered as a container that shows if a pdf document has been created for that field. I have brought this into a portal, so one can not only see the current record, but see which records do NOT have a file scanned in yet. As you know, a calc container field that has no file for that record will show:
"The file cannot be found: xxxxxxxx.pdf"
However, this gets too busy when repeated over numerous portal rows. I'd rather it just simply show the RecID. How would I do that? I've tried conditional formatting, but this field does not register as empty, nor does PatternCount work to find 1 instance of "The file cannot be found." Am I stuck with finding a file manager add on? Thank you.