Skip to main content

RowCount

Specs​

LabelValue
Version2.5.0 (updated on 2025-04-14)
DeveloperLabii Inc.
TypeColumn
Support ConfigurationYes
Support Readonly viewYes
Support Edit viewNo
Support Form viewNo
Support Default valueNo
Support ImportNo
Allow multipleYes

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
  • Stop condition - The formula will stop calculation when the condition is met. It must return a true or false value. This field does not support other column data, you can only use the variable data to reference the current record data.
  • Should auto update when readonly - If checked, this widget will perform a live calculation when readonly.

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.
    "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.