Can Caspio Create Cell Shading Or Background Styles From Excel?

[ETFIA]

Is it possible to configure a report view to display table rows of data that have background table shading either based on a set criteria of the cell data, or copying from an excel data source file?

For example, green shaded cellsi in excel data source are green in Caspio output, or Caspio programming can set cell shading based on cell values? Ie. if value > 1 then green shading, otherwise no shading.

Any guidance I appreciated, could not see this in the support files.

Thanks,

Anthony

[MayMusic]

You can include the field in an HTML Block using the insert icon (http://howto.caspio.com/datapages/form-elements/html-blocks.html). For instance if the Status is Closed the show the text in red:

<script>
function mycolor(){
if ("[@field:Status]" == "Closed") {
var str = "[@field:Status]";
document.write(str.fontcolor("red"));
}
else document.write(str);
}
mycolor();
</script>

[MayMusic]

I just found this article which might help: http://howto.caspio.com/customization/dynamically-change-the-background-of-a-results-page-record.html

[NailDyanC]

Hi, just to update this post. You may check this updated howto article about dynamically change the background of a results page record : https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-dynamically-change-the-background-of-a-results-page/