How do I represent "is not blank" in a formula?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
In the formula below, I have double quotes to represent "is blank"

I thought I could use "<>" to represent "is not blank" but it's not working. I've made that part of the formula bold below.

The two If statements work independently and I'm trying to put the Case around it. Thoughts on how I represent "is not blank" here? Thank you!





Case([Rating], "",



If([Premieres]= "Yes", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[(Premieres "&[Event Date in Full] &", "&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating/>\n<podCastPath/>\n</event>", [Premieres]= "No", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[("&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating/>\n<podCastPath/>\n</event>"),



"<>",



If([Premieres]= "Yes", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[(Premieres "&[Event Date in Full] &", "&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating>" & [Rating] & "</rating>\n<podCastPath/>\n</event>", [Premieres]= "No", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[("&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating>" & [Rating] & "</rating>\n<podCastPath/>\n</event>"))

Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
If there was a field called [My text field]  on Record #ID 31 and it was blank or was full of spaces which look like blanks to Users as they don't have X-ray vision then

IF(Trim([My text field])="",true)

would return true.


I like to use Trim, just in case the field has some spaces in it.

if you wanted to test for not blank, then this would return true of the field was not blank

IF(Trim([My text field])<>"",true)
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
Thanks, but I'm really just looking for what to replace what I already have in my formula that isn't working.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
try this

IF([Rating] = "",

If([Premieres]= "Yes", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[(Premieres "&[Event Date in Full] &", "&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating/>\n<podCastPath/>\n</event>", [Premieres]= "No", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[("&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating/>\n<podCastPath/>\n</event>"),

If([Premieres]= "Yes", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[(Premieres "&[Event Date in Full] &", "&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating>" & [Rating] & "</rating>\n<podCastPath/>\n</event>", [Premieres]= "No", "<event>\n<title><![CDATA[" & [Title] & "]]></title>\n<date><![CDATA[("&[Experience Type] & " &ndash; "& [Duration] & ")]]></date>\n<description><![CDATA[" & [Overview] & "]]></description>\n<eventPath text=\"" & [CTA] & "\"><![CDATA[" & [link] & "]]></eventPath>\n<imagePath><![CDATA[" & [imagePath] & "]]></imagePath>\n<videoPath/>\n<rating>" & [Rating] & "</rating>\n<podCastPath/>\n</event>"))
Photo of Karen

Karen

  • 222 Points 100 badge 2x thumb
That worked!!! Thank you so very much!! I didn't realize you could nest IF statement that way. THANKS AGAIN!!!