This is a bit of a follow up to this post:
I now have the comma separated lists working with blank values removed. However, for entries where no appropriate company exists for that entry, I would like to return "Not Available" instead of simply leaving the value blank.
Here's what it currently looks like:
The blank spot next to "System Installer" is what I would like to have say "Not Available" if there are no matches.
Currently, the field is set up like so (this is the same way for Supplier/Owners):
This works perfectly when there are existing values for this entry in the map series. However, for entries that do not have a matching ROLE_ID I can't figure out how to return "Not Available" instead of just leaving it blank.
I don't feel like I'm explaining this particularly well either, so please feel free to ask more pointed questions to help figure out the root of the issue.