Latest Contributions by BugPie

Hello out there! Looking for some guidance and hints on how to format a list. Specifically I'm looking to evaluate 5 different fields and then color the text for that line item based on the value. Where I get hung up is trying to evaluate more than 1 field and then applying to color to only that field in the line item layout. I Don't want all text to be a color just the value from that field, if that makes sense.   Seems like a long If then statement but I can't wrap my head around the structure.  I have a 5 fields for completion that has an integer between 0 and 100 and null.   In my list I have each of these five fields as well as some other fields and text.  Hoping to color the text for the field if 0-33 = red, 34 - 66 = yellow and 67 - 99 = green, all else black.  var comp1 = $datapoint.pc_1 var comp2 = $datapoint.pc_2 var comp3 = $datapoint.pc_3 var comp4 = $datapoint.pc_4 var comp5 = $datapoint.pc_5 ... View more

I have a Data Expression in a Dashboard that is used to create a table. Works great, was built by someone else. I have one change I need to make but have been unable to get the syntax correct. I'm trying to get the table to return the date as a date only, no time.   The bottom half of the code is attached here. I left out the variables and portal item stuff. How do I get Date only in the return?  ... View more

Looking for an example of how to apply the advanced formatting of a Dashboard list that evaluates a string field for a comma. IF the comma exists then I need to return the background cell as red.  I've been able to get formatting working to evaluate date fields for how many days out from today but I can't seem to get anything working for my comma example. This is what I came up with based on what has worked for me in the past but the table does not get formatted and stays in the original formatting.  var gpm = $datapoint["mystringfield"]; var hasComma = Find(mystringfield, ","); var isGreaterThanMinusOne = hasComma > -1,"#D94534"; return { cells: { number: { displayText: $datapoint["number"], textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, gpm: { displayText: $datapoint["mystringfield"], textColor: '', backgroundColor: isGreaterThanMinusOne, textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, creationdate: { displayText: $datapoint["datefield"], textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, } } ... View more