This article describes how to delete a Record in the spreadsheet-based data entry view of a Form.
You may want to delete a Record, when the data is incorrect, corrupt or duplicated. Deleting a Record means that you delete all information related to that Record, including Records added to the Subform of the Record. You may recover deleted Records using the Audit log.
To deal with duplicated Records, see Removing Duplicate Records in a Form.
ActivityInfo ensures data integrity by implementing referential integrity constraints. This means that when attempting to delete a Record, the system checks for any references to that Record from other related data. If such references exist, ActivityInfo prevents the deletion to maintain data consistency and prevent orphaned data.
To delete a Record in the spreadsheet-based data entry view of a Form, follow these steps:
- Navigate to the Database that contains the Form from which you wish to delete a Record from.
- Select the Form.
- Select the Record you wish to remove.
- Once you select a Record for deletion, ActivityInfo automatically checks if there are any related Records linked to it.
- If no related Records are found, the system prompts you with the “Are you sure you want to delete this record?” question. Click “Delete record” to remove the Record in question.
- If related Records are found, the system prompts you to securely delete the Record without compromising referential integrity.
- After confirming deletion, the Record is removed from the Table and no longer appears in the Form.
- If you wish to review the audit trail of the deleted Record, check Audit Log.