Depending on the workflow you want to implement in Phacet, you will have to manipulate multiple type of data : files, texts, labels, urls, images, numbers, etc.

Columns allow you to organize precisely the information available for any record, so you can easily visualize, manage and interact with your data.

A Column stores specific details related to each row that can either be used as an input, or as the output of a calculation performed by Phacet Tools (AI generation or Python Code for example)

Capturing different data with types

Let’s explore available data types in Phacet.

Column Type	Usage	Type of workflows
File	The File Type allows you to upload pdf files directly to a cell, to be references in another cell.	Extract information from a document.\ Structure data from a document Classify documents
Text	The Text Type allows to add text to a cell. text can be added manually or via CSV Import	Display extracted information from a document Apply Python code and formulas to an input Display AI generated content Generate content
Single and Multi Select	The Single or Multi Select Types allow you to tag a record from a definite list of tag options. Single select allow you to choose one tag. Multiple select allow you to choose any number of tags. You can manage the list of options available in the settings.	Categorize incoming emails or customer requests Analyse user feedback Categorize financial investment documents
JSON	The JSON Type allows you to generate and visualize data in a structured JSON format, using AI or Python Code Tools.	Passing structured data to the Python tool for further parsing, transformation, or analysis. Visualize multiple related data extracted from a document in a structured and/or nested way. Structure data to be exported into another tool accepting JSON

Applying Tools to Column

All column types (except File) allow you to generate content using AI or Python code Tools while referencing other columns values.

AI Tool : generate content based on AI reasoning.
Python Tool : execute custom code for specific treatments and automation.