topic Re: Remove gaps in list from hidden fields in ArcGIS Dashboards Questions

Remove gaps in list from hidden fields

dwold — Wed, 21 Feb 2024 16:07:01 GMT

I am hiding fields that have Null values in a list. The good news is the fields are hidden, the bad news is it creates a gap or holds that empty row in the list creating large gaps between some of the data. Is there a way to remove the gaps in the list?

var org_status = IIf(IsEmpty($datapoint.built_lost_maintained), 'hidden', 'visible') var Built = IIf(IsEmpty($datapoint.explain_built), 'hidden', 'visible') var Lost = IIf(IsEmpty($datapoint.explain_lost), 'hidden', 'visible') var Maintain = IIf(IsEmpty($datapoint.explain_maintained), 'hidden', 'visible') return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { org: org_status, explainBuilt: Built, explainLost: Lost, explainMaintain: Maintain } }

Line item template:

@jcarlson

@KenBuja

Re: Remove gaps in list from hidden fields

jcarlson — Wed, 21 Feb 2024 16:21:47 GMT

A line item template will skip the entire line if the whole thing is blank. Since your expression just changes the visibility tag, there's still HTML in there taking up space.

An alternative would be to put the entire div into your expression, like this:

var org_status = Iif( IsEmpty($datapoint.built_lost_maintained), '', `<div><u><em>Has your organization built, lost, or maintained target capacity:</em></u>${$datapoint.built_lost_maintained}</div>` )

Then in your line item template, just put {expression/org} to insert the entire HTML element.

Re: Remove gaps in list from hidden fields

dwold — Wed, 21 Feb 2024 17:16:29 GMT

@jcarlson worked great. Thank you!!!

Re: Remove gaps in list from hidden fields

dwold — Thu, 22 Feb 2024 16:02:30 GMT

@jcarlson I thought I had it working but for some reason, it still creates a gap for empty value. Do you see anything in my code I am missing?

//var phone = IIf(IsEmpty($datapoint.phone), '', `<div><span style="color:#ffffbe"><i>Phone: </i></span>${$datapoint.Phone}</div>`) var family = IIf(IsEmpty($datapoint.family_of_service), '', `<div><span style="color:#ffffbe"><i>Family of Service: </i></span>${$datapoint.family_of_service}</div>`) var staff = IIf(IsEmpty($datapoint.staffing_assignment), '', `<div><span style="color:#ffffbe"><i>How many personnel would you assign to this role: </i></span>${$datapoint.staffing_assignment}</div>`) var staff2 = IIf(IsEmpty($datapoint.staffing_assignment_2), '', `<div><span style="color:#ffffbe"><i>How many are currently assigned: </i></span>${$datapoint.staffing_assignment_2}</div>`) var staff3 = IIf(IsEmpty($datapoint.staffing_assignment_3), '', `<div><span style="color:#ffffbe"><i>Minimum staff to accomplish core capabilty: </i></span>${$datapoint.staffing_assignment_3}</div>`) var org_status = IIf(IsEmpty($datapoint.built_lost_maintained), '', `<div><span style="color:#ffffbe"><i>Has your organization built, lost, or maintained target capacity: </i></span>${$datapoint.built_lost_maintained}</div>`) var built = IIf(IsEmpty($datapoint.explain_built), '', `<div><span style="color:#ffffbe"><i>Explain built: </i></span>${$datapoint.explain_built}</div>`) var lost = IIf(IsEmpty($datapoint.explain_lost), '', `<div><span style="color:#ffffbe"><i>Explain lost: </i></span>${$datapoint.explain_lost}</div>`) var maintain = IIf(IsEmpty($datapoint.explain_maintained), '', `<div><span style="color:#ffffbe"><i>Explain maintained: </i></span>${$datapoint.explain_maintained}</div>`) return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { //phone, family, staff, staff2, staff3, org_status, built, lost, maintain } }

Re: Remove gaps in list from hidden fields

jcarlson — Thu, 22 Feb 2024 16:11:47 GMT

Strange... When I tested something similar, I didn't see that.

Another way to handle this is with an Array and a Filter and a single output string using Concatenate.

var string_arr = [ Iif(IsEmpty($datapoint.family_of_service), '', 'html string here'), etc, etc ] // create inverse of IsEmpty function for filter function NotEmpty(val) { return !IsEmpty(val) } // filter your html strings string_arr = Filter(string_arr, NotEmpty) // return non-empty divs separated by line breaks return Concatenate(string_arr, '<br>')

Re: Remove gaps in list from hidden fields

dwold — Thu, 22 Feb 2024 16:35:33 GMT

@jcarlson thank you so much. I really appreciate the help! I also tried this with some success but instead of no gaps, it is all one single line despite using the TextFormatting.NewLine. Do you see anything I could change to get separate rows for each field? 😀

Re: Remove gaps in list from hidden fields

jcarlson — Thu, 22 Feb 2024 16:38:33 GMT

That could work too. I honestly don't like using TextFormatting.NewLine, I don't always see it being recognized in different contexts. Try replacing that with "<br>" or "\n", see if that works?

Re: Remove gaps in list from hidden fields

dwold — Thu, 22 Feb 2024 16:48:39 GMT

@jcarlson you're the best, thanks!