Back to Table of Contents

Editing Data & Audit Trail

Row editor - use with caution

Select the row you want to edit as described in Viewing Data.

Depending on your permissions you may or may not be able to edit data in the Row editor pictured above. If you do not have permission for the row editor, when you double click on a row, you will immediately be taken to the next step.

If you do have permission, you can edit data in the row editor as shown above. When you have finished, click Save.

Note, this feature is not complete! The row editor is convenient for quick editing, but it does not have all the features of the full web capture and so mistakes can be made. In particular:

  • Dynamic lists do not work - all the options are displayed and they are not restricted
  • Multimedia questiosn are not displayed
  • Locked/Visible/Enabled flags are ignored
  • Skip and validation logic is not available so you can violate the logic and validation you have defined in your form properties
  • Calculations are not performed

Edit in web form

Depending on your permissions, you may be taken straight to this view or you may need to press Open from the Row editor mode.

From here, enter data as you would in standard data capture mode as explained in Capturing / Entering Data

Audit trail

Whenever you edit data, all previous versions are kept so that you can make an audit trail if you need to.

The most recent version of your data will always be in the table form_data and in the exported table so that it can be viewed in the Dashboard. But all previous versions of the data are available in the table form_data_version. This table stores that form_data_id which will stay with the data over its entire history, but will give it a new unique form_data_version_id. The table also stores who created that version of the data as well as who modified it.

Some additional information is available in How openXdata stores your data