DriveWorks Solo 15: Define Tables [send feedback...]

Introduction

When creating an automation project, it is likely that you've got existing data in databases or spreadsheets that you want to reuse. Unlike DriveWorks Pro, DriveWorks Solo only supports static tables of data, however you can copy and paste data from your databases and spreadsheets into a static table.


Tables

To Add a New Table

Click the "Add" button on the command bar to launch the new table wizard, fill in the name, and click Finish.

Once the table has been created, the table editor will switch into Edit mode.

Table
Editor

In edit mode you can cut/copy/paste data to external systems, and fill in values in a similar way to a traditional spreadsheet. When you are done, you can use the "OK" button to return to the table list.

To Edit a Table

  • Select the table to edit.
  • Click the "View/Edit" button on the command bar.
  • The table editor goes into edit mode just as it did when the table was originally added.

To Rename a Table

  • Select the table to rename.
  • Click the "Rename" button on the command bar.
  • Enter a new name.
  • Press Return to confirm the rename operation.

Renaming a table will scan all rules and replace any occurrence of the old name with the new name.

If DriveWorks detects that this could cause a delay, then the following message will be displayed.

To Delete a Table

  • Select the table to delete.
  • Click the "Delete" button on the command bar.

Using Fractions

When fractions are required in a table, that are to be used in further calculations, include a column where the decimal equivalent of the fraction can be looked up and used in any calculation.

For example:

A Combo Box is required to be populated with a list of sizes using the fraction format. When a size is selected from the combo box, 2.5 is to be added to the value to obtain the overall length.

  1. Create a table with the sizes to be selected from the combo box in one column and the decimal equivalent in the next column
  2. Add a combo box to the user form and use the ListAll function to list all the values from the first column
  3. Create a variable to Lookup the selected size and report the decimal equivalent, and then add 2.5 to this value.

Table of Contents