Skip to content

Latest commit

 

History

History
93 lines (73 loc) · 2.78 KB

example-cfg-advanced-cell-formatting.md

File metadata and controls

93 lines (73 loc) · 2.78 KB
Raw

Examples - Advanced Cell Content Formatting & Modification

Choosing one of the available formatting helpers

In addition to the following described method there is also now the option to choose from predefined format styles for each cell in a column. This is simply done by adding the fmt property to your column and choosing one of the available formatters. As of now there are not many, but as these are essentially hidden modify: scripts I have some hopes that people will share their coolest formattings - making it available to everyone through flex-table-card .

A list of all formatters can be found at the [configuration reference])(https://github.com/custom-cards/flex-table-card/blob/master/docs/config-ref.md).

type: custom:flex-table-card
title: Battery Levels (Top 10)
clickable: true
max_rows: 30
sort_by: state+
entities:
  include: sensor.*_battery_level(_[0-9]+)?
columns:
  - data: name
    name: NodeID

  - name: Battery Level (%)
    data: state
    fmt: number           <----- convinient text to number conversion
    suffix: '%'
    align: right

  - data: last_updated
    name: Hours Passed
    fmt: hours_passed     <----- how many hours have passed

Take full control of your cells

Monitoring and identifying nodes, which are not communicating anymore with the Z-Wave controller, can be extracted and also sorted according to their last sent/received message with the following config:

type: 'custom:flex-table-card'

# restrict the number of rows to display to 25 
# happens AFTER any sorting, formatting, modification
max_rows: 25

# sort data by 'receivedTS' in descending order
#sort_by: sentTS-
sort_by: receivedTS-

title: Durations Since Last Message (recv. & sent by node)

# make every cell/row 'clickable': show entity-popup for more entity details
clickable: true   

entities:
  exclude:
    - zwave.unknown_device_*
    - zstick_gen5
  include: zwave.*

columns:
  # 1st + 2nd column are <NodeID> + <NodeName>, remember to set 'name' for a 
  # human-readable / fancy header content
  - name: NodeID
  	data: node_id
  - name: Name
    data: name

  # 'receivedTS' and 'sentTS' are strings like: '2020-12-24 00:40:57:758'
  # using 'modify' and a JavaScript expression the strings can be converted to
  # hours using 'Date.parse' and friends
  - data: receivedTS
    modify: Math.round((Date.now() - Date.parse(x)) / 36000.) / 100.
    name: Recv. Age (h)
  - data: sentTS
    modify: Math.round((Date.now() - Date.parse(x)) / 36000.) / 100.
    name: Sent Age (h)

Using modify virtually any operation on cell data is possible. Clearly the trade-off is the increased configuration uglyness, which buys us well parsed and based on this parsed, then generated data.

<example table cell content formatting>

Return to main README.md