About this article
Once a Data Source has been create you populate it with content consisting of Schemas and Items. This article will explain how to set up the schema of the data source. Sections in this article:
- What is a Schema?
- What are the different Shema field types?
- How to create Schemas in Data Sources?
- Content (items) of a Data Source
What is a Schema?
A schema is a set of instructions that determine what information will be stored in a particular data source column and the type of data that the information will take the form of. Within a schema, you will have the ability to create the columns of a data source that hold different types of data such as normal text, numbers, images, languages, or a reference to another data source. Data sources are structured like relational databases meaning that one data source can be referenced by one or several other data sources.
What are the different Shema field types?
When you add a Schema to a Data Source you are presented with various types of fields, each explained below:
A Text Schema allows you to add items with text string.
A Number Schema allows you to add items with numbers.
An Image Schema field allows you to upload images to Data Sources. Please go to the article: How to upload images to Data sources? to read more about images in Data Sources.
One type of data that can be specified in a schema is a
reference. Selecting reference allows the user to refer to another Data Source for the value in the current data source. The rule of thumb for using references is that, when building a data source, if you find yourself manually filling in the same fields with the same value, it is a good idea to build a new data source for that value and refer to it in other data sources.
When setting up a reference in a schema, once the
Type has been selected, you will be presented with another drop-down of the other data sources that exist in the tenant. Choose the data source to refer to, whether it is a required field and a default value for the column (not required).
Below is an example of the SignOffs data source referring to the Language data source:
How to create schema fields in a data sources?
- Select the Data Source
- Go in Schema tab
- Fill in the Schema field
- Name: Name of the column
- Type: Data type (text, number, image, language, reference)
- Required: Mandatory value when creating items
- Default value: Default value when creating items
Content (items) of a Data Source
Now that you have created your data source and its schema, you can add items to this data source.
- Select the Data Source
Open data source
- Fill in the desired/required information