Create a Custom Table

Creating a Custom Table

1. First, check you are in Rayven Workspace and have selected your desired solution.
2. Select Tables from the left-hand panel and click 'Add a new table'. 
3. Choose a Name for your table. If you add your table to a dashboard, this name will appear as the widget title.
4. If you want, add a Description for the table.
5. Decide whether to configure data per device or tag:
   • Link label: Each table row will be a record of data saved against a device as configured in device management. 
   • Link device: Each table row will be a record of data saved against a value tag. 
6. Click Save to finish creating the table and start configuring the table columns.

Configuring your custom table

Now that you have created a custom table, you will see the custom table code on the screen. This code is needed when adding a formula to the workflow to look up a table value.

To configure your custom table: 

1. Click Add a New Column.
2. Select a Data Type from the drop-down menu:
   • Integer,
   • Decimal,
   • String,
   • Date (enters data via a calendar widget),
   • Time,
   • Multi-choice (enters data via a drop-down menu),
   • Workflow node (takes values from a field in a JSON payload),
   • Reference field (for calculations referencing multiple columns in the same custom table).
3. Under Display Name, enter the name of the column you want to appear in the dashboard.
4. The Column Name is required when configuring reference calculations. It can't contain spaces.
5. You can choose to set a Default Value for the column.
6. You can also set Pre- and Post- Symbols such as $ or %.
7. Link to Dashboard can be used to set a dashboard to open when you click a column. 
8. You can select an Aggregate Function to apply to all values in a column. Choose from the average, sum, and count.
9. Checking Hide Column ensures the column will not be visible from a dashboard.