To | Do this |
Enter the record creation date or time | Select Creation, then choose Date or Time from the list. |
Enter the record creation date and time (timestamp) | Select Creation, then choose Timestamp from the list. |
Enter the name of the person who creates the record | Select Creation, then choose Name from the list. |
Enter the account name that creates the record | Select Creation, then choose Account Name from the list. |
Enter the record modification date or time | Select Modification, then choose Date or Time from the list. |
Enter the record modification date and time (timestamp) | Select Modification, then choose Timestamp from the list. |
Enter the name of the person who modifies the record | Select Modification, then choose Name from the list. |
Enter the account name that modifies the record | Select Modification, then choose Account Name from the list. |
Assign a serialized number to the field in each record | Select Serial number, then: •For Generate, choose On creation to generate serial numbers when records are created. •For Generate, choose On commit to generate serial numbers when records are committed. For next value, type a starting value (like 100), then type the increment in increment by. |
Enter the value from the same field of the last active record | Select Value from last visited record. This option refers to the last record in which you performed some activity, such as clicking in a field. Note This value will be from the last record accessed in the table in which this option has been set. |
Enter data that you specify | Select Data, then type up to 255 characters. |
Enter the result of a calculation | Select Calculated value (or click Specify), then enter a calculation. See Defining calculation fields for information about the dialog box. Select Do not replace existing value for field (if any) to prevent overwriting data already present. |
Enter a value that's copied from a field in a related record | |
Prohibit a user from modifying a value that you have defined to be auto-entered | Select Prohibit modification of value. |
Turn off automatic data entry | Clear all selected checkboxes. |