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.

Cyrious has functions and keywords that return info about pricing and products.

Price Information Lookup

Table Lookup

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:

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:

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

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

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:

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

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:

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

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:

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.

With these functions, you can modify and save a Company record:

Other procedures that will automatically place a lock on a Company include:

• SetCompanyUDF
• SetCompanyUDFObjectID
• ResetCompanyUDF
• IncrementCompanyUDF
• DecrementCompanyUDF

With these functions, you can modify and save a Product record:

Other procedures that will automatically place a lock on a Product include:

• SetProductUDF
• SetProductUDFObjectID
• ResetProductUDF

With these functions, you can modify and save a Part record:

Other procedures that will automatically place a lock on a Part include:

• SetPartUDF
• SetPartUDFObjectID
• ResetPartUDF

Cyrious generates a number of functions to evaluate mathematical expressions, manipulate strings, work with dates and times, and format information for display.

Since Microsoft has changed the date and time format used in the new .NET architecture, it is strongly recommended that all date and time manipulation be accomplished using CFL functions and not numeric operators.

String Formatting functions are advanced tools to assist in the creation of strings for product layouts. HTML Formatting functions are designed to simplify the generation of HTML code by wrapping a string value with the appropriate HTML tags.

SQL functions are advanced tools to assist in retrieving values directly from the database. SQL functions are ran asynchronously in the background during calculations. When a SQL function is called, the TemporaryValue parameter value is immediately returned and SelectSQL statement is handed to a background thread. Once the SelectSQL statement has finished executing, the line item is recalculated using the value of the first column of the first row of records returned from the SQL statement. The value is stored in the line item and a flag is set to prevent the SQL statement from executing again.

* SQL Functions will be available in versions 04.50.1103.1801 and later.

Example of a Select SQL statement:
SELECT AccountNumber FROM Account WHERE CompanyName = TransHeader.CustomerName

Example of a Update SQL statement:
UPDATE Account SET AccountNumber = 0 WHERE CompanyName = TransHeader.CustomerName

Variable Property functions are used to read and write additional properties on a variables.

CFL has several functions are not general purpose (as those above) but specific to layout of pages and signs on a roll or sheet. Though the calculation can be (and has been) done using the general formulas, these occur so often that CFL has special functions to manage them.
These are complex functions that perform many calculations and set many variables.

• See CFL Function - CalculateLayoutOnRoll
• See CFL Function - CalculateLayoutOnSheet

Deprecated functions are those that are currently supported for backwards compatibility, but may not be supported in the future. Users should avoid using these obsolete functions and should convert any formulas using these functions. Deprecated functions are normally removed from the CFL after one or two major releases, so using them is risky.