Lookup Values from a Custom Table

Lookup Values from a Custom Table

You can use the Formula node to look up a value from a custom table. The template for a lookup is: 

<<custom_table_ID.reference_column_name.target_column_name.field_name>>

Where custom_table_ID is the table code name, reference_column_name is the key in the table you want to find, target_column_name is the value you want returned from the table, and field_name is the workflow value that matches the table's key. 

To find the table code name:

1. Check you are in Rayven Workspace and have selected your desired solution.
2. Select Tables in the left-hand panel to open the list of solution tables.
3. Click 'Edit table' on the applicable row.
   
4. You will see the table code name in the editing window.
5. Custom table calculations can reference another column in the same table. To configure this calculation type, select 'Reference' as the data type when adding a new column.