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

• 0
• Question
• Updated 3 years ago
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>"))

• 222 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,548 Points
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)
• 222 Points
Thanks, but I'm really just looking for what to replace what I already have in my formula that isn't working.

QuickBaseCoach App Dev./Training, Champion

• 67,548 Points
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>"))
• 222 Points
That worked!!! Thank you so very much!! I didn't realize you could nest IF statement that way. THANKS AGAIN!!!