Field Types


When it comes to storing data in Sales Layer, it’s possible to specify different types for each of the different fields you wish to store. By choosing the appropriate field type for each of your fields, you are helping Sales Layer to manage your data more effectively. 

The field types available are:

  • Short text - Up to 250 characters
  • Long Text - For more than 250 characters, this field also permits rich text editing
  • Numbers
  • Boolean - 0/1 - admitting zeros and ones or “null” if it is empty, although when importing it recognizes all these following terms: 0|1|y|n|yes|no|si|sí|ok|ja|verdadero|falso|true|false|oui|non|bai|Да|нет|是的|没有|はい|いいえ. It is possible to use formulas when importing and exporting, so that if it is 0/1, for instance, it will be exported as TRUE or FALSE. You only need to customize the output.
  • Image - Remember you can add multiple images by separating their file-name or URL with commas, as well as creating thumbnails
  • File - again you can add multiple files by separating them with commas.
  • Field List - Where you can specify a list of different options to be selected from a range. You have 2 options here:
    • Multi - selection ON  (you can select more than one option)
    • Multi - selection OFF ( where you can select only one option from a list)

          With both options it is possible to add new options to be selected

Field list
Field list
Activate/Deactivate Multi -selection
Activate/Deactivate Multi -selection

The option Modify allows both to edit the existent values and to translate them into the available languages in the account. In case a value is not translated, the system will show the original one. 

Besides, it is good to take into account that type list fields allow other languages, but not in multi-language mode: the content in each language is an independent list.

  • Date -  It allows convenient management of specific dates and time. This field can be customized with formulas in the output connector.
  • Web link - You only need to copy the url of a video in YouTube, for example, and it will be added to the form.
  • Table - It allows multidimensional values (because of its potential we will discuss it in depth in a separate video).
  • Related Items -  It allows establishing links with other references, either from the same table or others (products, variants, categories, points of sale, sales material, etc.). More info in the next section.

Warning: It is important that you always respect the original capitalization when importing or updating, to avoid possible problems in its future maintenance.