RowCount

Streamline the process of displaying row counts within a user interface

Specs

Label	Value
Version	2.1.0 (updated on 2024-02-27)
Developer	Labii Inc.
Type	Column
Support Configuration	Yes
Support Readonly view	Yes
Support Edit view	No
Support Form view	No
Support Default value	No
Support Import	No
Allow multiple	Yes

Overview

The RowCount widget is a versatile tool designed to streamline the process of displaying row counts within a user interface. Specifically tailored for displaying row counts, this widget operates efficiently by returning the count of rows based on a provided query. By seamlessly integrating into various applications, it offers developers a convenient solution for showcasing the quantity of rows within a dataset or database table, enhancing user experience and facilitating data analysis with clarity and precision.

Use case

• Return the number of bio specimens generated from a host.

Configuration

To enable the widget's functionality, it requires the following settings.

• Table - Select a table to limit the query. If you want to search across different tables, leave it empty.

• Query - You can use the query string after the '?' from the advanced search, or you can use one or more filter sids. Variables that can be replaced: {{SID}} - The SID of the current record. {{UID}} - The UID of the current record. {{NAME}} - The name of the current record. Examples: 1. name=test 2. filter__sid=xxx

• Should auto update - If checked, this widget will perform a live calculation.

Example

{
    "table": {"sid":"xxx", "name":"xxx"}, # the table to limit the query
    "query": "name__icontains=test", # (requried)
    # paste the query
    # Some variables can be added to the link. The widget will replace it for you:
    # {{SID}}, the sid of the current record.
    # {{UID}}, the uid of the current record.
    # {{NAME}}, the name of the current record.
    "should_auto_update": false, # default to false. 
    # If true, the widget will perform live calculation
    # If false, the user have to click reload to update the value
    "format": {}, # the number in the wNumb format. 
    # Learn more at https://refreshless.com/wnumb/
}

Views

See the interface of the widget in the following views.

Readonly view

Readonly view display the values of the column.

Press the Update button to refresh the count value.

Edit view

The Edit view is the interface that allows you to modify the value.

Edit view is not supported for this widget.

Form view

The Form view is the field integrated into the add form for collecting values when creating a new record.

Form view is not supported for this widget.

Data

Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.

Data format

Any data return from the formula.

Default value

The Default Value field within the column allows you to specify the default value when a record is created.

Default value is not supported for this widget.

Import value

The Import Value is the value you need to include in your Excel table for it to be imported into Labii.

Import value is not supported for this widget.