how to change back ground color for entire column data in quick base reports

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

if i have Q1 ,Q2,Q3 columns data but i need to change background colour the entire column data for Q1

Photo of Naga

Naga

  • 0 Points

Posted 5 years ago

  • 0
  • 1
This is not easy to do in native QuickBase and likely not worth the effort.  You would need to have a formula field to change the numeric value to text, get the decimal placed correct, and then use a span type html formatting to change the background color.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
It is a snap to do with the image onload technique and will become that much easier to do once QuickBase adds the native capability to inject user supplied JavaScript!

Rainbows

https://haversineconsulting.quickbase.com/db/bi5jupdpm?a=q&qid=1


Pastie Database

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=303
Very pretty.  Good to know its possible to do.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
I have some great looking unicorn and narwhal themes if you are interested.
Photo of Naga

Naga

  • 0 Points
here your using whether we need to do formula text or we need to write css file where we can write and how to link this css file with report
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
There is no CSS file used. Using the image onload technique the styles are manipulated with jQuery methods - specifically the $(<selector>).css() method is used to style the columns.
Photo of Naga

Naga

  • 0 Points
so we need to write one JS file seperately but  how to link this js page to our report
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
You use the image onload technique as described at length in this entry:

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294

People keep asking a series of highly related column manipulation questions. My suggestion is to understand and get to use the image onload technique in one situation and gain some experience with it. I don't have time to repeatedly explain every minor detail on each permutation of scenarios.