Description
Returns the value of the 'fieldname' for the first row in the set of records specified by the fetch-xml.
e.g Returns the estimated revenue for the supplied fetchxml.
Signature
FindValueFD('formuladetailname', 'fieldname', 'defaultvalue', 'nolock', 'params')
Example 1
FindValueFD('OpenOpportunities', 'estimatedrevenue', '0')
Example 2
FindValueFD('OpenOpportunities', 'estimatedrevenue', '0', true)
Example 3
FindValueFD('OpenOpportunities', 'estimatedrevenue', '0', true, SetParams[account.name])
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| formuladetailname | xxxx | xxxx | xxxx |
| fieldname | xxxx | xxxx | xxxx |
| defaultvalue | xxxx | xxxx | xxxx |