LIST
Usage
Use this function to return a list of values
Category | Function | Type | Where to use | Argument statement |
---|---|---|---|---|
FUNCTION | SERVER ROW | VALUES LIST | .VALUE |
Syntax
1 |
|
Arguments
Value_1
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned values list
Value_n
any cell value (#Storage_Name.Field_Name.VALUE
or .OLDVALUE
), constant, System Variables or function-returned values list
Notes
=LIST(-1) returns empty list.
=LIST() return full list.
You can use it also to restrict the lookup dropdown items list (in Lookup Restriction section) or to segment the storage table rows
Return Value
List
Examples
Example 1
Formula
=LIST($CURRENTUSER.GROUPNAMES; "Domain Admin"; "Designer")
Description
Return the Groups list of the current User (variable), Domain Admin and Designer
Result
List of current User Groups, Domain Admin and Designer
Example 2
Formula
=IF(#StorageExample.Status.OLDVALUE == "Draft";
=LIST("Draft"; "Submitted");
"Completed"
)
Description
We performed this formula in a Lookup Restriction of a field to restrict the lookup dropdown items list. Formula checks if the cell old values of the field Status in the StorageExample are equal to Draft; if the condition's result is true returns a list of Draft, Submitted, else Completed
Result
Draft, Submitted or Completed
Example 3
Formula
=LIST("Department 1"; "Department 2";
=LOOKUPLIST(
#StorageExample;
#StorageExample.Department;
#StorageExample.Sector == "Production"
)
)
Description
Return list with values Department 1, Department 2 and the list returned taking from Storage Storage_Example the Department where Sector is equal to Production (LOOKUPLIST function)
Result
Department 1, Department 2 and all the Department of the StorageExample that have Production as sector