Widget recordCount
The “Record Count” type of widget uses a specific function to process RecordSets of EveryDataStore.
This configuration of RecordCount widget should start with widget_recordcount_. At the end you you can describe the configuration with any name you want e.g. widget_recordcount_sales_count.
The parameters of widget_recordcount_ are:
|
Parameter |
Description |
|---|---|
|
backgroundcolor |
Specifies the color of the widget via the HEX color code |
|
slug |
Unique identification string of the RecordSet |
|
fields |
Unique identification string of the fields as array to process |
|
filter |
Specifies a filter criterion for RecordSetItemData in JSON object format |
|
count_option |
sum or count. default is count |
|
suffix |
Specifies the appended icon to the end of the widget |
|
prefix |
Specifies the appended icon to the beginning of the widget |
New widgets of this type can be created by adding underscore and custom definition after any of above listed configurations, and then entering desired value for the configuration.
Example Count of Sales
The “Sales” widget shows the total sales value expressed in Euros, calculated as a sum of all “Total” fields in “Invoice” RecordSetItems, that have “Paid” value in the “Status” field.
{
"slug":"f6c0bca856ee93b39fbc",
"fields": ["7936aefb7f2f51b5ea42"],
"filter": {"Value":"Paid"},
"backgroundcolor": "#0abf53 ",
"prefix": "€ ",
"suffix":" ",
"count_option":"sum"
}