↓ Skip to main content
MoleLab
MoleLab
  1. Work Notes/
  2. Common Snippets/

Main Field Formula: Count Detail Rows Matching a Condition

·75 words·1 min
Ecology Common Snippets Code Snippets Field Formula Detail Table
Author
molefool
Table of Contents

Formula
#

[主表.AAII153]=CALDTROW([明细表1.ACCOUNT ALIASES]=='II-153',1)

Purpose
#

Set 主表.AAII153 to the number of detail rows that match the condition.

The condition here is: 明细表1.ACCOUNT ALIASES equals II-153.

Notes
#

  • The condition must use a double equals operator: ==.
  • If the condition is written incorrectly, the formula may not report an error and may only produce an unexpected count.
  • After configuration, verify the result with at least one matching detail row and one non-matching detail row.

Related

E9 Code Block: Validate Through an Interface Before Submit

·876 words·5 mins
Ecology E9 Code Block Interface Validation Submit Guard
The core E9 submit-guard pattern: start from the submit event, call an interface asynchronously, require a stable successful response, and decide from responsebody.