saveWorksheet()

Table Properties for information on making a table editable.

Saves the data currently loaded in Data Worksheet Embedded Tables associated with the Dashboard. This allows you to store data that a User has manually entered using a Dashboard Embedded Table or Form component that writes to a Data Worksheet Embedded Table. See Table Properties for information on making a Table editable.

You do not need to use this function to save Table data if ‘Write Back to Storage’ is enabled in Table Properties.

Example

The script below can be placed in the onClick handler of a Submit button. See Add Component Script for more information.

// Apply user modifications to the Data Worksheet Embedded Table:
Table1.applyChanges();

// Save the Data Worksheet, included the modified Embedded Table:
saveWorksheet();

// Refresh the Dashboard with saved data from the Data Worksheet:
refreshAfterSubmit = true;

See applyChanges() and refreshAfterSubmit for more information about these functions.