LogoLogo
  • GETTING STARTED
    • Violet Documentation
    • What is Violet?
    • Platform Overview
  • Integrations
    • Connect self-hosted software
  • FEATURES
    • Dashboards
      • Customization
      • FAQ
    • Data Explorer
      • FAQ
    • Automations
      • Jira to Smartsheet
        • Auto-update Jira data using formulas
      • Solidworks PDM to Fusion
      • Teamcenter to Datum
      • Teamcenter to ION
      • Teamcenter to Netsuite
      • FAQ
    • Reports
      • Multisource
        • Custom Columns
        • FAQ
      • Clear To Build
      • Build Velocity
    • Requirements
      • View: Table vs. Graph
      • Structure: Hierarchy vs. System
      • Systems
      • Import via CSV
      • Custom Fields
      • Verifications
      • Satisfaction
    • Parameters
    • Scripts
      • Creating and running scripts
      • Violet Variables
      • Live scripts
      • History and notifications
      • FAQ and Examples
    • SysML
    • Change Orders [Beta]
    • Schedules [Beta]
    • Workflows [Beta]
  • RESOURCES
    • Administrative
      • Invite your team
      • Permissions
      • Single Sign-On
      • On-Premises Deployment
        • Azure Deployment
        • AWS Deployment
        • Nutanix AHV Deployment
    • Security & Compliance
      • ITAR/EAR Compliance
      • SOC 2 Certification
      • NIST/CMMC Compliance
      • Data Retention, Backup and Recovery
      • Legal Stuff
    • Videos and Tutorials
    • FAQ
    • Pricing
  • APPS
    • A
      • Acumatica (Coming Soon)
      • AllSpice (Coming Soon)
      • Altium 365
        • Connect Altium 365 in Violet
      • Altium Designer
      • Aras
      • Arena
      • Asana
        • [Optional] Connect using a PAT
      • AutoPCB (Coming Soon)
    • B
      • Basecamp (Coming Soon)
      • Bild (Coming Soon)
      • BILL
      • Bitbucket
        • [Optional] Connect Bitbucket with API Token
      • Box
      • Brex
        • [Optional] Connect to Brex using an API Token
    • C
      • Cameo
      • Capella (Coming Soon)
      • ChatGPT (Coming Soon)
      • ClickUp
      • Cofactr
      • Confluence
      • Costpoint (Coming Soon)
      • Coupa (Coming Soon)
      • Creo (Coming Soon)
    • D
      • DOORS (Coming Soon)
      • Datum
      • Docusign (Coming Soon)
      • Drafter (Coming Soon)
      • Dropbox (Coming Soon)
      • Duro
    • E
      • Enterprise Architect (Coming Soon)
      • Epicor (Coming Soon)
      • Epsilon3
    • F
      • Factor
      • FactoryLogix (Coming Soon)
      • Flow
      • Fleetio (Coming Soon)
      • Fulcrum
      • Fusion - by Autodesk
      • Fusion - by Stoke Space
    • G
      • Gitea
      • GitHub
        • [Optional] Connect with an API Token
      • GitLab
        • Generate a GitLab API Token
        • Connect self-hosted GitLab
      • GENESYS
      • Google Drive
      • Google Sheets
    • I
      • Innoslate (Coming Soon)
      • InvenTree
      • ION
        • Connect ION in Violet
    • J
      • Jama
        • Connect self-hosted Jama
        • [Optional] Connect with Jama Client ID & Secret
      • Jira
        • Self-hosted Jira
        • [Optional] Connect via Jira API Token
      • Julia
      • JITX (Coming Soon)
    • K
      • Kiwi TCMS (Coming Soon)
    • L
      • LeoTrack (Coming Soon)
      • Linear
      • LN (Coming Soon)
      • Lucidchart
      • Lucidscale
      • Lucidspark
      • Luminary Cloud (Coming Soon)
    • M
      • Manufacturo
      • Mathcad (Coming Soon)
      • MATLAB
      • Microsoft 365
      • Microsoft Teams (Coming Soon)
      • Microsoft Project (Coming Soon)
      • Monday.com
        • [Optional] Connect to Monday.com with an API Token
    • N
      • NetSuite
        • Configure NetSuite to connect
        • Connect NetSuite in Violet
        • Configuring NetSuite data syncs
      • Nuclino
      • Notion (Coming Soon)
      • NX (Coming Soon)
    • O
      • Octopart
        • Connect Octopart in Violet
      • Odoo (Coming Soon)
      • Onshape
      • Opcenter (Coming Soon)
      • OpenBOM
    • P
      • Parasoft (Coming Soon)
      • Pathfinder
      • Polarion (Coming Soon)
      • Precoro
      • Procurify
      • Puzzle
      • Python
    • Q
      • QuickBooks
    • R
      • Ramp
    • S
      • SAP ME (Coming Soon)
      • SAP S/4 HANA (Coming Soon)
      • SatCatalog
      • Sedaro
        • Using Violet data in Sedaro
      • SimScale
      • Simulink (Coming Soon)
      • Slack
      • Smartsheet
        • Smartsheet Gov
      • Solidworks PDM
      • Solumina (Coming Soon)
      • StartProto
      • Syndeia (Coming Soon)
      • SysML
      • Syteline (Coming Soon)
    • T
      • Teamcenter
        • Configure Teamcenter to connect
        • Connect Teamcenter in Violet
        • Set up Teamcenter integration
        • Data fetched from Teamcenter
        • Teamcenter FAQ
      • Teamcenter X (Coming Soon)
      • TestRail
      • Trello
      • Tulip (Coming Soon)
    • V
      • Valispace
      • Visure (Coming Soon)
      • VOLTA (Coming Soon)
    • W
      • Wasp (Coming Soon)
      • Wayfinder
      • Windchill
      • Wrike
    • X
      • Xero
      • Xray (Coming Soon)
  • Z
    • Zuken E3 (Coming Soon)
Powered by GitBook
On this page
  • Static Values
  • Custom Formulas
  • Custom Formula Examples

Was this helpful?

  1. FEATURES
  2. Reports
  3. Multisource

Custom Columns

PreviousMultisourceNextFAQ

Last updated 28 days ago

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

Static Values

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.

Custom Formulas

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.

Custom Formula Examples

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.

Basic Math

Conditional Expressions

Multi-Line Functions

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 .

math.js documentation
here