Custom Columns
Last updated
Was this helpful?
Last updated
Was this helpful?
The Multisource Report tool allows users to add custom columns to reports by clicking on + COLUMN.
These can be used to add information to a report beyond what is natively generated from the sources in Violet. When you save a report, any custom columns will be saved along with it.
Custom columns can be of the type:
Text
Number
User
Custom Formula
Choosing Text
, Number
, or User
will create a column where you can populate each cell individually by clicking on the cell. The values in these cells must be updated manually, and do not depend on the information in the rest of the report.
If User
is selected, double-clicking on a cell will reveal a dropdown selector where you can choose any of the users in your Violet environment.
In addition to adding columns with static values, you can also add columns that relate to existing information in the table based on formulas that you define. This lets you generate important information about parts or POs directly in the Multisource Report. These columns will update along with the information in the rest of the report table whenever it is opened.
To use this functionality, select the Custom Formula
Column Type and enter your formula. When building your formula, type an opening bracket ([
) to show a searchable list of columns and elements that you can reference in your formula.
Consider the use case where you'd like to calculate whether you have enough parts in inventory to build an assembly. The following examples describe three different methods to create and display such an "Inventory Shortage" column.
The first example uses simple subtraction to show the numeric shortage value for each part. The second example adds a conditional expression to indicate whether or not there is a shortage in a more readable format. The third example combines basic math, a conditional expression, and string manipulation into a multi-line function that outputs a readable shortage indicator with the numeric shortage value.
Custom formulas leverage math.js syntax and operators. You can find the full documentation of this syntax here: .
Note: This use case is common enough that we developed a Clear To Build report to show this type of information, with some additional functionality. See details on that .