For the automatic creation of a table in TABLE|IT you need a CSV file which contains the information for the table in a certain format so that TABLE|IT can retrieve the data from it.

 

We created an example file for you which you can download and adjust according to your own needs.

 

For ColumnName you enter the name of the individual table columns. For every column you also need to specify the data type (DataType). These are: Character, Picture, Number, Memo, Date, Decimal, YesNo, Currency, Annual Event, DateTime, InitialCaps, Lowercase, Phone, Time, Uppercase, Url. You also state the length of the column (FieldLength), meaning how many characters the column can contain at most, as well as a default value if necessary (Defaultvalue).

 

The next options are Yes/No options, a "1" means "Yes" and a "0" means "No". You can decide whether...

 

... the field should be allowed to be empty (Allow Empty)

... the field should be tracked, meaning if changes of the field content should be listed in the related history (IsTracked)

... the field should be primary (IsPrimary)

... the contents of the table should only be read but not edited (IsReadOnly)

... a pick list should be used (UsePicklist). If yes, please enter the desired pick list under PickListName.

 

Unfortunately you cannot change these settings in retrospect. That is why it is important that you proceed carefully and check if you entered everything correctly.

 

... if you want to limit the field entries to elements from the pick list (LimitToPicklist)

... if you want to allow several entries (MultiSelectPicklist)

... if you want to allow suggestions from the pick list when you enter data into the fields (TypeAheadPicklist)