Hi all!
I have a table that has a text formula. The text formula combines multiple fields (question and answers) and separates them using <br>. This is how i have it:
<b>question1</b> answer1
<br>
<b>question2</b> answer2
<br>
<b>question3</b> answer3
<br>
For some records, some of the fields are empty so this is how it results:
<b>question1</b> answer1
<br>
<b></b>
<br>
<b>question2</b> answer2
<br>
In my table, the empty space would show and it would take so much space:
Is there a code that I could use to hide the <b></b><br> if the <b></b> was empty for this column/field?