AnsweredAssumed Answered

case nothing is true leave blank....

Question asked by taryn on May 29, 2018
Latest reply on May 29, 2018 by beverly

So this is my first time trying to write case functions from If.... I'd like it to end with nothing in the field if there is no data... I think I know where I am going wrong but I'm really not sure cause i can't seem to fix it.  as right now when it runs and there is "nothing" true in the fields i still end up with just the punctuation. I'd rather it end with just leaving everything blank....I'm not very confident that I'm writing this currently at all but for the most part its doing what i want other than leaving behind the spaces and "." and "," that I want put in if the fields have info....(i apologize I'm not very good at clarifying what I need things to do)

 

If (Get(RecordNumber) = 1; YI_Xtag_Header  & "¶";"")&"@EventsTime:" & YI_no00 & EventName & "¶" & "@EventsDescription:" & EventPrintDescrpition  & " " &

Case (PreRegistrationRequired = "1" ; "Pre-Registration Required. "; ContactName & " ";

ContactName = "" ; Venues::VenueName & ", "  & Venues::Address & ". ") &

 

Case (IsEmpty (EventCost); "" ; EventCost & ". " ) &

 

Case (IsEmpty (ContactPhone); Venues::Phone & " " ; ContactPhone & " ") &

 

Case (IsEmpty (ContactEMail) ; Venues::Email & " " ; ContactEMail & " ") &

 

Case ( IsEmpty ( ContactWebsite ) ; Venues::Web ; ContactWebsite) &

 

Case ( IsEmpty ( EventRepeatTime ); "" ; EventRepeatTime)

Outcomes