Adding the columns to the "News Articles" list
Adding columns to a list is a straight forward process. For our exercise, we will create the following columns:
| Column Name | Column Type | Description |
| OneLiner |
Multiple lines of text (Plain text) |
In this colum we are going to store a brief introduction to the article. This description will be text-only. |
| Body |
Multiple lines of text (Rich text) |
This column will contain the actual body of the article and will accepd HTML. |
| SortOrder |
Number |
We are going to use this column to control the order in which the articles are displayed in a list. |
| Image |
Picture |
This will contain a picture to accompany the article. |
Note that we are going to store the title of the article in the default "Title" column.
Important: the name given to a column at this stage will be used by SQList to generate the column names for the SQL table; unlike for list names though, column can be renamed at a later stage but the names of the columns in the SQL table will maintain their original names. For more information, please read our knowledge base article How SQList Generates Table and Column Names.
2.1 From the List Settings page, Click .
2.2 Enter the name of the column ("OneLiner" in the example below) and sleect the column type; note that for "Multiple lines of text", Sharepoint allows you to specify whether to allow text only ("Plain text), rich text where text can be styled ("Rich text") or full html ("Enhanced rich text").
2.3 Follow the same steps for all columns that need to be added to the list as displayed in the screenshots below.
In the next step, we are going to create the actual articles.
