Have spent many hrs with multiple AI's, and I cant get simple cell highlighting to work in IG ( with css and javascript ), am i missing something?
Even Gemini AI abandoned trying to get it to work, eg: https://gemini.google.com/share/b517547246e4
( am trying not to use the report highlighting tools, as they take ages to apply for multiple columns, and are pretty clunky )
All im trying to achieve:
In oracle apex version 24.2
I have an interactive grid report on the following table:
Database Table: EBA_DEMO_CHART_GRADES, columns SCHOOLA, SCHOOLB and SCHOOLC which have grades between 0 and 100.
Please help with instructions to use inline CSS in the page, and javascript to color the cells behind the grade according to the number in the cell. If the number is above 90 it is green, between 80 and 90 yellow, between 60 and 80 amber, otherwise red.
Table definition:
CREATE TABLE "EBA_DEMO_CHART_GRADES"
( "ID" NUMBER,
"COURSE" VARCHAR2(10),
"SCHOOLA" NUMBER,
"SCHOOLB" NUMBER NOT NULL ENABLE,
"SCHOOLC" NUMBER,
"CREATED" TIMESTAMP (6) WITH TIME ZONE,
"CREATED_BY" VARCHAR2(255),
"UPDATED" TIMESTAMP (6) WITH TIME ZONE,
"UPDATED_BY" VARCHAR2(255)
) ;
Sample data:
Id,COURSE,SCHOOLA,SCHOOLB,SCHOOLC,CREATED,CREATED_BY,UPDATED,UPDATED_BY
1,English,93,53,71,,,,
2,Physics,61,55,65,,,,
3,English,70,50,90,,,,
4,Math,50,70,45,,,,
5,English,30,67,90,,,,
6,English,85,56,67,,,,
7,Math,70,45,59,,,,
8,Math,62,53,66,,,,
9,English,77,50,60,,,,
10,English,90,54,69,,,,
11,Physics,60,40,64,,,,
12,English,88,28,67,,,,
13,Math,71,56,45,,,,
14,Math,63,58,64,,,,
15,English,59,54,65,,,,