Forum Discussion
- JIMLIEDER1Qrew CadetHere's an answer that was posted a few years ago that will help:
https://community.quickbase.com/quickbase/topics/coloring-alternate-row- JessicaHaskinsQrew CadetOops sorry I realized I just renamed the record ID. I tried the formula, but it doesn't display correctly, because the report is filtered based on a condition. So it shows up like this
- JessicaHaskinsQrew CadetThanks Jim, but I deleted my record ID # field, so I can't use the formula
If(Rem([Record ID#], 2)=0, "#EvenColor", "#OddColor") - JIMLIEDER1Qrew CadetEvery table needs a Record ID# field. You have probably just renamed it to something else.
Look at your list of fields in the table, and you'll see one field with the gold key icon. You can use that field name instead of Record ID# - GaryBoydQrew Assistant CaptainI would also like to know the answer to this. Running formulas to display selected records, so odds/ evens color solution will not work. Thanks.
- _anomDiebolt_Qrew EliteThere are class "od" and "ev" on the odd and even rows of a table report you can use for selectors.
Using IOL on the report you can set even rows to have a gray background with code similar to this:$("table.searchResults tr.ev").css({backgroundColor: "#f2f2f2"});
- GaryBoydQrew Assistant CaptainThanks - using your techniques of oil and bol seems to open up a lot of options.
- _anomDiebolt_Qrew Eliteand staying native closes down options.