System generated columns in iSheets

By default, every iSheet includes four system generated fields, which are automatically populated columns which cannot be manually updated. There is one exception detailed below. System generated columns are listed at the bottom of the Manage columns page:

These system-generated fields include the following:

• Created by - The name of the user who created the item. This is a user lookup column.
• Created date - The date and time when the item was created. This is a date and time column.
• Modified by - The name of the user who last modified the item. This is a user lookup column.
• Modified date - The date and time when the item was last modified.  This is a date and time column.

If Enable modified date override is ON for the iSheet, any user with edit rights to an iSheet item can edit the default Modified date.

Although the values in these fields cannot be edited, except for the modified date exception detailed above, the properties of these fields can be configured like other columns, including:

• Choosing whether to include these columns in views
• Allowing these columns to be searched
• Changing the column's name
• Changing the column’s width
• Any other changes applicable to the particular type of column, such as changing the date format for the Creation date or changing the field display to an email address or username for Created by.

System generated fields appear at the bottom of iSheet items when viewing or editing record details. If an iSheet has sections configured, system-generated columns are displayed at the bottom in a Section labeled Default when viewing or editing the record:

There are additional system-generated columns for file and folder metadata iSheets, discussed in subsequent articles.