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.
• List of attributes - Where you can specify a list of different options to be selected from a range. You have 2 options here:
  • Multi - selection ON : the list appears with checkboxes and you can select multiple options. The maximum permitted is 100 options per field. If you choose this option, you can enter all the values for an item separated by commas and they will then appear in the list of options to choose.
  • Multi - selection OFF : if you deactivate the multi-selection, you will only be able to choose one option from the entire list. In this case the field allows a maximum of 1000 options.

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

Please note that when working in the Excel view, in a list type field you won't be able to see all available options that you have created in it, so if you want to include one of the defined value you must click on the field, put a comma plus a space and now you can write the new desired options (in the exact way as they are shown in the drop-down menu: respecting capital letters, accents, spaces, etc.).

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.