Search the Community
Showing results for tags 'if formula'.
-
I am attempting to change the background color in a report search results page using an IF function. I tried to use the following code but for some reason it does not work. I am sort of new at this so I may just be missing something obvious but I cannot find it. <script> var isi = document.getElementById("visi[@field:id#]"); if ([@calcfield:1#] > 6){isi.parentNode.parentNode.style.backgroundColor = '#58ff33';} else if([@calcfield:1#] <= 6 && [@calcfield:1#] >= 4){isi.parentNode.parentNode.style.backgroundColor = '#ffac33';} else if([@calcfield:1#] < 4){isi.parentNode.parentNode.style.backgroundColor = '#ff3b33';} </script>
-
Hello, I am quite new to Caspio and I am not sure if what I want to accomplish is possible. I have a table in which I want to add a new field/column. That new column is going to combine/concatenate few of the other columns in the same table, but I need to use an if logic to complete what I want. I did not see an IF option as a text formula. This is what I have written, but the formula is not correct:
- 2 replies
-
- table
- if formula
-
(and 1 more)
Tagged with: