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.
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.
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.
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.