Question

Resolving Null variables

Forum|Forum|4 years ago
March 16, 2022
4 replies
0 views

In our system a user can enter up to 3 studies but only one is required.
My current work around is saving any studies not entered to "N/A"

if(
isnull(ri!svcRequest.study_two),
{ a!save(ri!svcRequest.study_two, "N/A") },
{}
),
if(
isnull(ri!svcRequest.study_three),
{ a!save(ri!svcRequest.study_three, "N/A ") },
{}
),

Issues is In the follow up email it looks like this:

We were pleased to support your review by performing additional analysis on studies: cat, N/A, N/A

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

gopalk2865

Participating Frequently

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() .

mikes0011

Brainy

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
)

The Expression Guru