CELLAND
Usage
Use this function to return a boolean AND expression between cell values
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | CLIENT | LOGICAL | .METADATA |
Syntax
1 |
|
Arguments
Condition_1
any CLIENT function returns Boolean cell value or SERVER function returns Boolean not depending from UI cells values
Condition_n
any CLIENT function returns Boolean cell value or SERVER function returns Boolean not depending from UI cells values
Notes
SERVER functions can be nested in CLIENT functions using the IF function and returning true or false (see examples).
Condition arguments can be also a SERVER functions only if their arguments are not value-parameterized on the cells of the client rendered records
Return Value
Boolean
Examples
Example 1
Formula
=CELLAND(
=CELLGT(#StorageExample.Price.METADATA; 100);
=CELLEQ(#StorageExample.Discont.METADATA; "Yes")
)
Description
Check if the cell values of the field Price in the StorageExample are greather than 100 and, meanwhile, if the cell values of the field Discount in the StorageExample is equal to "Yes"
Result
true or false
Example 2
Formula
=CELLAND(
=CELLNEQ(#StorageExample_1.Status.METADATA; 1);
=CELLEQ(
=LOOKUP(#StorageExample_2; #StorageExample_2.Email; #StorageExample_2.UserType == "Manager");
$CURRENTUSER.EMAIL
)
)
Description
Check if the cell values of the field Status in the StorageExample_1 are not equal to 1 and, meanwhile, if the current User Email (variable) matches with the result of the LOOKUP function that takes from Storage StorageExample_2 the Email where the UserType is Manager
Result
true or false
Example 3
Formula
=CELLAND(
=CONTAINSLIST(
=LIST($CURRENTUSER.GROUPNAMES);
=LIST("Group 1"; "Group 2")
);
=CELLNEQ(#StorageExample.Status.VALUE; 1);
=CELLEQ(#StorageExample.Status.VALUE; 2)
)
Description
Check if the value list Group 1, Group 2 is contained in the Groups list of the current User (variable), so if the User is in the Group 1 and Group 2, and, meanwhile, if the cell values of the field Status in the StorageExample are not equal to 1 and, meanwhile, if the cell values of the field Status in the StorageExample are equal to 2
Result*
true or false