File Attachment Columns
Imagine you’re planning to create an Art Gallery database and need to store previews of paintings or a Contract Management database for organizing contracts and documents. In such cases, you can add File Attachment Columns to include documents or graphic file attachments.
Please note that the maximum size for any attached file is 100 MB. However, the number of revisions kept in the column doesn’t matter.
If a column contains data that doesn’t appear or behave as you desire, you can edit the column’s General Properties.
Properties defined by the column type:
- Display Text
- This property allows a user to display a text value in the corresponding table cell instead of the attached file name.
- This property enables a user to keep and view the revision history of an attached file:
- Keep the last (n) revisions checkbox allows you to retain data for a specific number of revisions of the same attached file and enter the necessary value for the number of revisions in the list;
- Keep all revisions checkbox preserves data for all revisions of the same attached file.
- Revision History
- This property allows a user to manage the history of file revisions. Select the "Allow See Revision History" checkbox if you want to view the history of file changes.
- You can choose one of the following file attachment types: File, Image, Signature.
- File: the attachment will be displayed as an attached document;
- Image: attached graphic files will be displayed directly in the table;
- Signature: allows to capture a signature directly on a touch device and save the result as an image.
The following maximum size options are available for List Style and Form Style:
- No file name
- allows to hide names of attached images.
- Open in New Window
- This property allows a user to specify how the file is opened. Select the "Open in New Window" checkbox 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. However, a link requires a user to log in before downloading a file, which may cause difficulties when data are shared via email notifications 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, which allows access to a file attachment without requiring a user to log in.
- When the Help text property is filled in, a question mark is displayed near the field name on the View/Edit form. Hovering over this question mark will display a pop-up with a tip or a help text message.