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.