GetMatchingRepeatingFormsCount( )
Get the number of repeating form instances of a form that match the item values provided as search keys.
Syntax
GetMatchingRepeatingFormsCount('variable1', value1, 'variable2', value2, ...)
Parameters
Return value
Count of matching repeating form instances.
Note:
In dates,UNK
values are considered to match
any other value. For example: 'Date(01-Feb-2022)'
and 'Date(20-Feb-2022)'
are both considered as a
match of an entry with UNK-Feb-2022
date
value.
Usage Tips
- Can accept choice controls (radio controls, check box controls, and dropdowns) but can only be searched by label, not value.
- Only one option can be provided as search text for choice controls.
- Dates must be provided inside the string
'Date(dd-mmm-yyyy hh:mm:ss)'
. - You can use partial dates in the following formats:
- <dd-mmm-yyyy hh:mm>
- <dd-mmm-yyyy hh>
- <dd-mmm-yyyy>
- <mmm-yyyy>
- <yyyy>
- Times must be provided inside the string
'Time(hh:mm:ss)'
. - You can use partial times in the following formats:
- <hh:mm>
- <hh>
Example 3-57 Raise a query if there is more than one instance where AE Outcome = 'Fatal"
// Raise a query if there is more than one instance where AE Outcome = 'Fatal"
// Get current repeating instance
var ins = GetCurrentRFInstance();
var curVal = "";
// Get value of aeOut from current instance
var rfData = getRFValues('ins', [aeOut] );
if(rfData.exists && rfData.aeOut){
if((rfData.aeOut) !== "[]"){ // If the choice control has been cleared out then do not read the label
curVal = JSON.parse(rfData.aeOut)[0].label;
}
}
// check to see if there are more than 1 instance with "Yes"
return ((curVal == "Fatal") && (GetMatchingRepeatingFormsCount('aeOut', "Fatal") > 1))?false:true;
Parent topic: Repeating form functions