## Using Formulas with Channels

Sales Layer possesses a helpful tool for data transformation which can be used to modify the values of certain fields when importing or exporting information via channels.

There are more than 50 different formulas which allow for modifications such as: transforming text, performing mathematical calculations, applying conditions based on a field’s value, and many others.

Field keys are the way each field from a table is identified when performing a function.

To be able to extract specific values from fields containing images or files, we make use of suffixes.

Empty fields in a channel (the ones which are not linked to any field in the database) can be thought of as text fields which export the result of the formula they contain.

Find out the list of the main formulas you can use in Sales Layer.

IF statements allow us to perform different actions based on the value of a field or other factors.

The MATH Formula allows us to perform mathematical calculations.

Find out some of the examples and explanations of the syntax.

There are two types of functions to apply in the data import and export formulas depending on the result we want to obtain.

One of the most useful formulas in Sales Layer is the Replace From Table, a key when it comes to working with connectors and extracting content from one table to another.

There are several specific formulas for manipulating and extracting data from “table” type fields in Sales Layer.

"Get Cell Value" and "Print Table Field" as specific formulas for data extraction in table type fields.

Some of the specific formulas for inserting and/or modifying data in table-type fields, such as the one used for inserting data in table-type fields or the one that removes the previous content.

Find out how to use the INSERT_IN_TABLE for multi-record import.

This formula is designed to completely remove rows or columns from a table type field.

Some additional notes regarding the use of formulas in connectors.