This guide lists the steps to configure the destination for writeback.
To begin, create your planning sheet. Writeback may be performed for data input rows and columns as seen below, as well as for comments.
Add a new destination
Select the Writeback ribbon.
Select Add destination.
Use the Select a Connection dropdown to select your SQL connection.
Select Database Name to choose your destination.
Select your desired database.
Select Add.
Enter the schema and the table name.
Choose the decimal precision for your writeback columns.
Please note that this is a one-time action that cannot be changed and will apply to any future destinations added.
Choose your desired text length for strings. For example, you may want to increase the length for writeback if you have a Notes column with long notes added. Select Add.
Once your destination has been configured, you will see an expanded writeback menu with additional options.
Add multiple destinations by selecting Add destination again.
Note that for further destinations, it is not possible to select the decimal precision or text length.
Manage Destinations
1. Select Manage to manage writeback destinations.
You can now refresh, edit, delete, or turn off destinations.
