How do I show and hide variables with null values so the sentence above only shows studies that are entered?
We were pleased to support your review by performing additional analysis on studies: cat Side note: this is what the email expression looks like: =pv!svcRequest.study_one & ", " & pv!svcRequest.study_two & ", " & pv!svcRequest.study_three
Discussion posts and replies are publicly visible
Hi, There could be multiple ways to implement what you are trying to do. I would suggest you to apply null check before concatenating these three variables. You can use nested If() .
You would just wrap each one of the subsequent entries in its own if() statement, it doesn't really require nesting per se. This would allow you to use either or both of "study_two" and "study_three", and inherently requires "study_one" to be filled in.
pv!svcRequest.study_one & if( a!isNullOrEmpty(pv!svcRequest.study_two), null(), ", " & pv!svcRequest.study_two ) & if( a!isNullOrEmpty(pv!svcRequest.study_three), null(), ", " & pv!svcRequest.study_three )
Awesome, I did this in the email in stead of the form, thank you for this!
Hi there,
When you're finally constructing this sentence for your email, use this code.
substitute(ri!variable, "N/A","")
This will remove the "N/A" from your code.