Text calculations / skipping empty fields?
I've created a text calculation defined by 7 different fields on my database.
This works perfectly, however not all 7 fields are always in use for all records. It's the same field that sometimes is left blank because the information is not relevent for each record.
When the field is blank, the text calculation leaves the line blank. Is there anyway to create a calculation that doesn't leave the line blank, but rather skips that empty field?
By leaving it blank it creates an empty line between two lines that should be one on top of another.