# Customizing resource table

# Demo (opens new window)

Resource table can be customized via resource columns settings. Additional columns can be added via custom SQL query:

Resource SQL

# Column types

Type Table cell Description
Text image Single line text
Integer image Number input
Decimal image Number with floating point
Reference image Link to the related resource
Date and Time image Date selector with time. Time is displayed using browser timezone
Date image Date selector
Boolean image Checkbox
Long text image Multiline text with textarea
Richtext image HTML text with ActionText editor
Currency image Formatted number with currency symbol. Cents currency base option formats currency from cents to decimal
Percentage image Expects a number between 0 and 100 to display it as a progress bar
Change image Expects positive or negative number
Chart image Expects an array of numbers to build a simple line chart
Tag image Input with select options
Link image URL or path displayed as a link or as a button
Color image Color in hex format with color picker
Image image Image with file input
File image File link with file input
JSON image JSON text editor