Hide Columns That Are Null

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter larckco

    (@larckco)

    67 counties in this email form, only want to show those columns with data in them.

    ‘[cfdb-datatable form=”Florida QSO Party” hide=”call,ALACHUA-SAT=null,ALACHUA-SUN=null,BAKER-SAT=null,BAKER-SUN=null,BAY-SAT=null,BAY-SUN=null,BRADFORD-SAT=null,BRADFORD-SUN=null,BREVARD-SAT=null,BREVARD-SUN=null,BROWARD-SAT=null,BROWARD-SUN=null,CALHOUN-SAT=null,CALHOUN-SUN=null,CHARLOTTE-SAT=null,CHARLOTTE-SUN=null,CITRUS-SAT=null,CITRUS-SUN=null,CLAY-SAT=null,CLAY-SUN=null,COLLIER-SAT=null,COLLIER-SUN=null,COLUMBIA-SAT=null,COLUMBIA-SUN=null,MIAMI-DADE-SAT=null,MIAMI-DADE-SUN=null,DESOTO-SAT=null,DESOTO-SUN=null,DIXIE-SAT=null,DIXIE-SUN=null,DUVAL-SAT=null,DUVAL-SUN=null,ESCAMBIA-SAT=null,ESCAMBIA-SUN=null,FLAGLER-SAT=null,FLAGLER-SUN=null,FRANKLIN-SAT=null,FRANKLIN-SUN=null,GADSDEN-SAT=null,GADSDEN-SUN=null,GILCHRIST-SAT=null,GILCHRIST-SUN=null,GLADES-SAT=null,GLADES-SUN=null,GULF-SAT=null,GULF-SUN=null,HAMILTON-SAT=null,HAMILTON-SUN=null,HARDEE-SAT=null,HARDEE-SUN=null,HENDRY-SAT=null,HENDRY-SUN=null,HERNANDO-SAT=null,HERNANDO-SUN=null,HIGHLANDS-SAT=null,HIGHLANDS-SUN=null,HILLSBOROUGH-SAT=null,HILLSBOROUGH-SUN=null,HOLMES-SAT=null,HOLMES-SUN=null,INDIAN-RIVER-SAT=null,INDIAN-RIVER-SUN=null,JACKSON-SAT=null,JACKSON-SUN=null,JEFFERSON-SAT=null,JEFFERSON-SUN=null,LAFAYETTE-SAT=null,LAFAYETTE-SUN=null,LAKE-SAT=null,LAKE-SUN=null,LEE-SAT=null,LEE-SUN=null,LEON-SAT=null,LEON-SUN=null,LEVY-SAT=null,LEVY-SUN=null,LIBERTY-SAT=null,LIBERTY-SUN=null,MADISON-SAT=null,MADISON-SUN=null,MANATEE-SAT=null,MANATEE-SUN=null,MARION-SAT=null,MARION-SUN=null,MARTIN-SAT=null,MARTIN-SUN=null,MONROE-SAT=null,MONROE-SUN=null,NASSAU-SAT=null,NASSAU-SUN=null,OKALOOSA-SAT=null,OKALOOSA-SUN=null,OKEECHOBEE-SAT=null,OKEECHOBEE-SUN=null,ORANGE-SAT=null,ORANGE-SUN=null,OSCEOLA-SAT=null,OSCEOLA-SUN=null,PALM-BEACH-SAT=null,PALM-BEACH-SUN=null,PASCO-SAT=null,PASCO-SUN=null,PINELLAS-SAT=null,PINELLAS-SUN=null,POLK-SAT=null,POLK-SUN=null,PUTNAM-SAT=null,PUTNAM-SUN=null,SANTA-ROSA-SAT=null,SANTA-ROSA-SUN=null,SARASOTA-SAT=null,SARASOTA-SUN=null,SEMINOLE-SAT=null,SEMINOLE-SUN=null,ST.-JOHNS-SAT=null,ST.-JOHNS-SUN=null,ST.-LUCIE-SAT=null,ST.-LUCIE-SUN=null,SUMTER-SAT=null, SUMTER-SUN=null,SUWANNEE-SAT=null,SUWANNEE-SUN=null,TAYLOR-SAT=null,TAYLOR-SUN=null,UNION-SAT=null,UNION-SUN=null,VOLUSIA-SAT=null,VOLUSIA-SUN=null,WAKULLA-SAT=null,WAKULLA-SUN=null,WALTON-SAT=null,WALTON-SUN=null,WASHINGTON-SAT=null,WASHINGTON-SUN
    “]’

    Plugin Author Michael Simpson

    (@msimpson)

    The plugin doesn’t support this directly.

    “hide” is just for listing columns to not show. It is not for evaluating if all the rows in the data set are null. When the short code runs, it doesn’t know which columns have data or not across the entire set of data rows. It processes a row at a time and outputs it and wouldn’t know until the last row whether a certain column was null for all rows.

    Accomplishing this would require writing a transform class in PHP that would track each column as it is read in addEntry(), then remove those columns for which no data is seen in getTransformedData()

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Hide Columns That Are Null’ is closed to new replies.