Not Null
I am writing a formula Rich Text field that is getting a bit complicated. I am combining 4 text fields together, making the contents bold and italicized. Original formula:"<i><b>" & [CT - Q1 Comme...
Forum Discussion
The List Function separates non null elements with a separator. ie it will not add extra spaces or dashes or commas (whatever your separator is, if there is nothing to separate.
Here is an example if how it is used
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=e2&rl=hdi
Here is an example if how it is used
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=e2&rl=hdi
- Thank you, I am able to get them together but can't get them on separate lines:
"<i><b>" & List("\n", [SA - Q1 Comments],[SA - Q2 Comments], [SA - Q3 Comments],[SA - Q4 Comments], [SA - Q5 Comments], [SA - Q6 Comments], [SA - Q7 Comments], [SA - Q8 Comments], [SA - Q9 Comments], [SA - Q10 Comments], [SA - Q11 Comments], [SA - Q12 Comments]) - I was able to get it using "<br>" rather than the "\n
- The <br> is when you have a Rich Text field type
The \n is for a regular text field type. - I love learning new things :)
