{$page}

The CFL Formula Builder is a powerful visual aide that helps complete and verify expressions. While typing a formula, the CFL checks the entry to assess the completeness, color-codes the information input, and offers suggestions as needed.

The default formatting scheme for the formula editor is:

Formulas
Adding and multiplying are useful, but most users want to do more than basic math inside of CFL. To access the full power of CFL, one should make themselves familiar with the Language's built-in functions for complex math, manipulating strings, looking up information, and more.
The built-in formulas are divided into the following categories:
* Company Functions
* Contact Functions
* DateTime Function
* Math Functions
* Part and Cost Lookup
* Price Information Lookup
* SQL Functions
* String Functions
* Table Lookup
* Transaction Functions
* Variable Lookup
There is a last category, Obsolete Functions, which users should attempt to avoid. These deprecated functions are maintained for a limited period for backwards compatibility purposes, but are likely to be removed in subsequent versions of CFL.
Functions Associated with Pricing and Products
Cyrious has functions and keywords that return info about pricing and products.
Price Information Lookup
|| Function || Parameters || Returns… ||

Error Checking
|| Function || Parameters || Returns… ||

Table Lookup
|| Function || Parameters || Returns… ||

Variable Information Lookup
|| Function || Parameters || Returns… ||

Variable Setting Functions
|| Function || Parameters || Function… ||

List Lookup
|| Function || Parameters || Returns… ||

Line Item Lookup
|| Function || Parameters || Returns… ||

Parts and Cost Lookup
|| Function || Parameters || Returns sum of the (Estimated) costs of all parts that are of the type… ||

User Defined Field Lookup Functions
UDF Values for the current Transaction (Order or Estimate), Customer, Contact, and Product can be retrieved in any CFL function. The UDF Value for a Part may be retrieved through the Part Name or the name of the variable that linked to the part.
A default value should always be given. If the UDF is not defined or the associated information not present, and no default value is given, an error message will result. For example, if you use a Customer UDF but attempt to read the value before the customer is assigned to the order you will receive an error message.
To read the value of a UDF use the following functions:
|| Function || Parameters ||

Returns the value of the UDF name. The Default value is returned if the Company is not assigned or no UDF/Variable/Part with that name exists.
To set the value of a UDF, use the following procedure:
|| Function || Parameters ||

To clear the value of a UDF, use the following procedure:
|| Function || Parameters ||

To increment the value of a Number UDF, use the following procedure:
|| Function || Parameters ||

If the Amount isn't specified, the value is incremented by one (1).
To decrement the value of a Number UDF, use the following procedure:
|| Function || Parameters ||

If the Amount isn't specified, the value is decremented by one (1).
To check if a UDF is assigned:
|| Function || Parameters ||

For Boolean values, returns true if the UDF exists and false otherwise. For Non-Boolean values, returns true if the UDF exists and is assigned, and false if it does not exist or is not assigned.
To check if a UDF is overridden:
|| Function || Parameters ||

Returns true if the UDF overridden and false if not overridden.
To retrieve the parent object of a UDF:
|| Function || Parameters ||

Returns the object assigned to the specified UDF Name. If the UDF does not exist, or no object is assigned to it, a “Null” value is returned.
To set the ID of a UDF's parent object:
|| Function || Parameters ||

Sets the value used by an object UDF to the ID specified. If the UDF does not exist a warning is logged. If the ID does not exist a message is displayed and the UDF not set. Passing an ID of zero (0) or negative one (-1) will clear the UDF.
Company Functions
With these functions, you can modify and save a Company record:
|| Function || Parameters || Notes ||

Other procedures that will automatically place a lock on a Company include:
* SetCompanyUDF
* SetCompanyUDFObjectID
* ResetCompanyUDF
* IncrementCompanyUDF
* DecrementCompanyUDF
Product Functions
With these functions, you can modify and save a Product record:
|| Function || Parameters || Notes ||

Other procedures that will automatically place a lock on a Product include:
* SetProductUDF
* SetProductUDFObjectID
* ResetProductUDF
Part Functions
With these functions, you can modify and save a Part record:
|| Function || Parameters || Notes ||

Other procedures that will automatically place a lock on a Part include:
* SetPartUDF
* SetPartUDFObjectID
* ResetPartUDF
General Functions
Cyrious generates a number of functions to evaluate mathematical expressions, manipulate strings, work with dates and times, and format information for display.
Numeric Functions
|| Function || Parameters || Description ||