Skip to main content

Reset Button for the Writeback

When you configure the Writeback Wizard in a workbook, you can add a Reset button to the sheet. Clicking it restores the workbook to its opening state, discarding all changes made since it was last opened from the navigation panel. It's the equivalent of closing the workbook without saving, then reopening it.

Opening state is not the same as last saved state. It's the state of the workbook the last time it was opened from the navigation panel. If you save changes while the workbook is still open and then click Reset, those saved changes are lost too.

The button is added through the Action Button Wizard in the Analysis tab. You need to configure the Writeback Wizard first.

Reset button position
tip

To make changes permanent before resetting, save the workbook, close it, then reopen it from the navigation panel. That reopened state becomes the new opening state.

When to reset data​

  • Clear all edits at once when you want to start over without manually removing every modified value.
  • Discard incorrect writeback entries to restore the original data before pushing anything to the ERP.
  • Return to a clean state after testing a writeback configuration before entering real data.

Create the reset button​

  1. Open a workbook with a Writeback Wizard already configured.
  2. On the Analysis tab, select Action Button Wizard.
  3. Under Type, select Nectari Action.
  4. Under Button, select Reset.
  5. Enter or select the cell where the button will appear on the sheet.
  6. (Optional) Edit the default label to give the button a more specific name.
  7. Choose a color using the color picker, or enter a HEX code directly.
  8. Review the Preview to confirm the button appearance.
  9. Click Save.

Reset data to its opening state​

  1. Click the reset button in the workbook.
  2. In the confirmation dialog, click Reset to confirm.