File Attachment Columns

Say you plan to create the Art Gallery database and want to store previews of paintings or create the Contract Management database for organizing contracts and documents. So, you may add a File Attachment Columns comprising documents or graphic file attachments.

Please note, that the maximum size of any attached file is 100 MB. However, the number of revisions kept in the column doesn’t matter.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

General Properties:

File Attachment General.png

Properties defined by the column type:

File Attachment Column.png

Attachment Options

Column Property


Display Text

This property allows a user to display a text value that will be present in the corresponding table cell instead of the attached file name.


This property allows a user to keep and view revision history of an attached file:


Select the Keep all revisions checkbox if you want to keep data for all revisions of the same attached file;

Select the Keep the last (n) revisions check box if you want to keep the data for a specific number of revisions of the same attached file and enter a necessary value for the number of revisions in the list.

Revision History

This property allows a user to handle the history of files revisions: select the Allow See revision History checkbox if you want to view the history of file changes.

As a result the Revisions button will be displayed near the file attachment field on the View form.



You can choose one of the following file attachment type: File, Image, Signature.

When the File option is specified, the attachment will be displayed as attached document.


If the Image type is selected, attached graphic files will be displayed straight in the table. Also you can select the image List size and Form size. Also, if you want to hide names of attached images, you can check the No file name option.


In case the Signature option is chosen, you can capture a signature directly on a touch device and save the result as an image. Also you can specify List size and Form size of the signature image.


Open in New Window

This property allows a user to specify the way the file is opened: select the Open in New Window check box if you want to open file attachments in new windows.

Allow Public Access

To access a file attachment a user should follow a link generated by TeamDesk, yet a link requires a user to log in prior to downloading a file. It may cause difficulties when data are shared via email notification, because a file attachment is not accessible to persons who are not database users. To avoid this problem, you can activate the Allow Public Access option; as a result it does not require a user to login in order to access a file attachment.

Moreover, in case you need to create a lookup column displaying another lookup showing an image kept in a File Attachment column, you also have to activated the Allow Public Access option, otherwise the image will not be visible in such lookups that display other lookup columns.


When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: URL Columns