Skip to main content
Question

Not Null

  • October 20, 2018
  • 0 replies
  • 102 views
Forum|alt.badge.img+7
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 Comments] & "<br>" & [CT - Q2 Comments] & "<br>" & [CT - Q3 Comments] & "<br>" & [CT - Q4 Comments]

Then I saw when some of the comments are blank, there was extra space (I assume this is the breaks even though there is no text.  So I feel like I need to adjust the formula to contain nested If/And statements:
If [CT - Q1 Comments] = Blank and [CT - Q2 Comments], [CT - Q3 Comments], [CT - Q4 Comments] are Not Blank then "<i><b>" & [CT - Q2 Comments] & "<br>" & [CT - Q3 Comments] & "<br>" & [CT - Q4 Comments]

I believe this is going to end up being a pretty long formula since I would need to have every variation of each comment being blank.

I believe since these are text fields I would want [CT - Q1 Comments] = null however I don't know how to say [CT - Q2 Comments] Is not null.  I tried the not IsNull( ) but it didn't like that.

Any suggestions?

      This topic has been closed for replies.

      • SuryaExpert
      • Registered
      • October 20, 2018
      Consider using the List command to concatenate text. It ignores the delimiter and the accompanying field if it is null.
      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
      Terms & ConditionsAccessibility statement