Return single text values in list from comma separated field

dwold

I am trying to display text that has multiple responses and populate them in a list individually. In the example below my goal is to have something shown below but single responses in each target, not all 5 listed for every one

Goal is to get Targets to read:

Target: Relocation_Assistance

Target: Relocation_Assistance_for_People_with_Access_and_Functional_Needs

Target: Community_Sheltering

Target: Community_Sheltering_for_People_with_Access_and_Functional_Needs

Target: Community_Sheltering_Animals

There may be only on "target" so if that is the case, I'd like the list to retunr that single text sting. Right now my list is doing this:

Here's what I currently have in my Advanced Formatting section:

 

var result = "";
if (!IsEmpty($datapoint.target)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target: </i></span>` +$datapoint.target;
}
if (!IsEmpty($datapoint.target_goal)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Goal: </i></span>` +$datapoint.target_goal;
}
if (!IsEmpty($datapoint.target_value)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Value: </i></span>` +$datapoint.target_value;
}
if (!IsEmpty($datapoint.gap_value)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Value: </i></span>` +$datapoint.gap_value;
}
if (!IsEmpty($datapoint.gap_percent)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>` +$datapoint.gap_percent+'%';
}
if (!IsEmpty($datapoint.target)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target: </i></span>` +$datapoint.target;
}
if (!IsEmpty($datapoint.target_goal_1)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Goal: </i></span>` +$datapoint.target_goal_1;
}
if (!IsEmpty($datapoint.target_value_1)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Value: </i></span>` +$datapoint.target_value_1;
}
if (!IsEmpty($datapoint.gap_value_1)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Value: </i></span>` +$datapoint.gap_value_1;
}
if (!IsEmpty($datapoint.gap_percent_1)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>` +$datapoint.gap_percent_1+'%';
}
if (!IsEmpty($datapoint.target)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target: </i></span>` +$datapoint.target;
}
if (!IsEmpty($datapoint.target_goal_2)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Goal: </i></span>` +$datapoint.target_goal_2;
}
if (!IsEmpty($datapoint.target_value_2)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Value: </i></span>` +$datapoint.target_value_2;
}
if (!IsEmpty($datapoint.gap_value_2)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Value: </i></span>` +$datapoint.gap_value_2;
}
if (!IsEmpty($datapoint.gap_percent_2)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>` +$datapoint.gap_percent_2+'%';
}
if (!IsEmpty($datapoint.target)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target: </i></span>` +$datapoint.target;
}
if (!IsEmpty($datapoint.target_goal_3)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Goal: </i></span>` +$datapoint.target_goal_3;
}
if (!IsEmpty($datapoint.target_value_3)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Value: </i></span>` +$datapoint.target_value_3;
}
if (!IsEmpty($datapoint.gap_value_3)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Value: </i></span>` +$datapoint.gap_value_3;
}
if (!IsEmpty($datapoint.gap_percent_3)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>` +$datapoint.gap_percent_3+'%';
}
if (!IsEmpty($datapoint.target)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target: </i></span>` +$datapoint.target;
}
if (!IsEmpty($datapoint.target_goal_4)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Goal: </i></span>` +$datapoint.target_goal_4;
}
if (!IsEmpty($datapoint.target_value_4)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Target Value: </i></span>` +$datapoint.target_value_4;
}
if (!IsEmpty($datapoint.gap_value_4)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Value: </i></span>` +$datapoint.gap_value_4;
}
if (!IsEmpty($datapoint.gap_percent_4)) {
    result += "<br><br>" + `<span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number): </i></span>` +$datapoint.gap_percent_4+'%';
}

return {
  textColor: '',
  backgroundColor: '',
  separatorColor:'',
  selectionColor: '',
  selectionTextColor: '',
   attributes: {
     result
   }
}

 

This isn't correct but would I do something along the lines of:

var target_one = ([$datapoint.target] , 0)

var target_two = ([$datapoint.target] , 1)

var target_three = ([$datapoint.target] , 2)

 

@KenBuja I saw you commented on another post about using the OrderBy but I'm not sure if that would work in this situation?

kenbuja

If I understand how your fields are set up, give this a try:

**Edited to fix an error (i.e. "$datapoint[tg]" instead of "$datapoint.tg")**

var result = "";
if (!IsEmpty($datapoint.target)) {
  var targetArray = Split($datapoint.target, ",")
  for (var i in targetArray) {
    result += `<br><br><span style="color:#ffffbe"><i>Target: </i></span> ${Trim(targetArray[i])}`;
    
    var tg = iif(i > 0, `target_goal_${i}`, 'target_goal')
    if (!IsEmpty($datapoint[tg])) result += `<br><br><span style="color:#ffffbe"><i>Target Goal: </i></span>${$datapoint[tg]}`;
    var tv = iif(i > 0, `target_value_${i}`, 'target_value')
    if (!IsEmpty($datapoint[tv])) result += `<br><br><span style="color:#ffffbe"><i>Target Value: </i></span>${$datapoint[tv]}`;
    var gv = iif(i > 0, `gap_value_${i}`, 'gap_value')
    if (!IsEmpty($datapoint[gv])) result += `<br><br><span style="color:#ffffbe"><i>Gap Value: </i></span>${$datapoint[gv]}`;    
    var gp = iif(i > 0, `gap_percent_${i}`, 'gap_percent')
    if (!IsEmpty($datapoint[gp])) result += `<br><br><span style="color:#ffffbe"><i>Gap Percent (rounded to the nearest whole number) </i></span>${$datapoint[gp]}`;
  } 
}

return {
  textColor: '',
  backgroundColor: '',
  separatorColor:'',
  selectionColor: '',
  selectionTextColor: '',
   attributes: {
     result
   }
}