Field Types
Table Field Types
A database field is a single piece of information from a record. A database record is a set of fields.
The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store.
Field Type Parameters - Tells additional details to the database about how to store a value and configures general behavior of the input boxes.
Edit Record Parameters - Used in Edit Record layout and it configures the input box appearance and functionality.
Value Processing Parameters - Used in Catalog Record layouts and Details layouts, configures how to process stored value and render HTML content.
string - Text String (Single Line)
Provides a text box for data entry.
Field Type Parameters:
Length (number)
Number of characters. Number of characters not bytes.
Example:
30
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example 1:
[Field Name]
Example 2:
[Field Name:my_CSS_class,onclick='alert(1);']
Value Processing Parameters:
Limit Output (list)
Limits returning output text, first number of characters or first number of words.
Options:
Length (number)
Number of characters or words.
Clean Braces (radio)
Deletes all braces from the text. (i.e. to avoid Content Plugins running.)
Options:
Clean Quotes (radio)
Deletes all quotes from the text.
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:chars,30,true,true]
multilangstring - Multilingual Text String (Single Line)
Provides a set of text boxes for data entry. One inputbox for each language.
Field Type Parameters:
Length (number)
Number of characters. Number of characters not bytes.
Example:
50
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Limit Output (list)
Limits returning output text, first number of characters or first number of words.
Options:
Length (number)
Number of characters or words.
Clean Braces (radio)
Deletes all braces from the text. (i.e. to avoid Content Plugins running.)
Options:
Clean Quotes (radio)
Deletes all quotes from the text.
Options:
Language (language)
Specify the language. Default front-end languege will be used if not specified.
Example 1:
[Field Name]
Example 2:
[Field Name:chars,1,true,true]
alias - Alias (For SEO Links)
Alias field that can be used insted of listing_id for SEO purpose.
color - Color
Provides Color Picker functionality in the Edit Form or hexidecimal value as output.
Edit Record Parameters:
Transparent (radio)
Allow transparency - alpha color.
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:transparent]
Value Processing Parameters:
Format (radio)
Return formats: HEX is #rrggbb or #rrggbbaa, RGB is rgb(r,g,b) or rgbs(r,g,b,a)
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:rgba]
signature - Signature
A signature pad that allows users to draw smooth signatures on canvas element and export the signatures to PNG/JPG/SVG images.
Edit Record Parameters:
Width (text)
Width in pixels
Height (text)
Height in pixels
Example:
[Field Name]
Value Processing Parameters:
Image tag or Link (radio)
Show as HTML IMG tag or a link to the image.
Options:
Image Format (list)
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:link,svg]
text - Text Area (Multilple Lines)
Provides a textarea box for data entry.
Field Type Parameters:
Text Editor (list)
Options:
Spell Checker (radio)
Options:
Example:
rich,spellcheck
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Limit Output (list)
Limits returning output text, first number of characters or first number of words.
Options:
Length (number)
Number of characters or words.
Clean Braces (radio)
Deletes all braces from the text. (i.e. to avoid Content Plugins running.)
Options:
Clean Quotes (radio)
Deletes all quotes from the text.
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:50,1,true,true]
multilangtext - Multilingual Text Area (Multilple Lines)
Provides a set of textarea boxes for data entry. One textarea box for each language.
Field Type Parameters:
Text Editor (list)
Options:
Spell Checker (radio)
Options:
Example:
rich,spellcheck
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Limit Output (list)
Limits returning output text, first number of characters or first number of words.
Options:
Length (number)
Number of characters or words.
Clean Braces (radio)
Deletes all braces from the text. (i.e. to avoid Content Plugins running.)
Options:
Clean Quotes (radio)
Deletes all quotes from the text.
Options:
Language (language)
Specify the language. Default front-end languege will be used if not specified.
Example 1:
[Field Name]
Example 2:
[Field Name:chars,50,true,true]
int - Integer Number
Provides an integer number inputbox.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
float - Float (Decimal) Number
Provides a decimal number inputbox.
Field Type Parameters:
Decimals (number)
Number of digits to the right of the decimal point (the scale). Must be no larger than Precision Number of digits.
Precision (number)
Maximum number of digits (the precision).
Smart Imput (radio)
Allows input without pressing decimal point key. Example: to type [12.67] just type [1267] The decimal point will be placed by itself.
Options:
Example:
2,1,smart
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example 1:
[Field Name]
Example 2:
[Field Name:inputboxClass,readonly='readonly']
Value Processing Parameters:
Number of decimals (number)
Format returning number. Add tracing 0 if needed. (useful when formating a currency)
Decimal Separator (string)
Separate decimals with provided character. i.e. ',' or '.'
Thousand Separator (string)
Separate thousands with provided character. i.e. ',' or '.' or ' ' (space)
Example 1:
[Field Name]
Example 2:
[Field Name:2,.,","]
records - SLQ Table Join (Multiple)
Provides a Multiple Left Join to records of another table.
Field Type Parameters:
Table (table)
Type the name of the Custom Table to join/link with.
Field Name (string)
Type the field name to return the value from (that can be overwritten in Layout). You may type layout name instead. options: [layout:the layout or tablelesslayout:the layout]
Selector (list)
How to select records.
Options:
Filter (string)
Limits records using filter. Example: [age>30] where age is a field in joining table
Dynamic Filter (string)
Used with multibox, requires that joining table contain SQL Join field to use it as Category Filter
Order By (string)
Field name to sort record by
Allow Unpublished (radio)
Allow to select unpublished records.
Options:
Example:
products,title,single,,,title,true
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
checkbox - Checkbox (YES/NO)
Provides a single checkbox to be checked or unchecked
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Format (list)
Type of checkbox
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:,,yesno]
email - Email
Provides an email field.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
url - URL / Link
URL / Link to some website. Must start with http:// or https://
Field Type Parameters:
CSS Class (string)
Name or names of CSS class(s).
HTTPS Only (radio)
Allow only secure URL links
Options:
Domain Name (string)
Must include following domain name, separate domain names with the comma. Example: youtube.com,youtu.be
Allow Query Parameters (radio)
Allow the URL links include query parameters like ?param1=blahblahblah
Options:
Example:
,true,,false
date - Date
Date Picker
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Format (string)
PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.
Example 1:
[Field Name]
Example 2:
[Field Name:Y-m-d]
time - Time
Time Selection. Saves value in ticks with defined offset. It will save time as number of seconds from the midnight by default.
Field Type Parameters:
Min (From) Time (string)
Minimum (From) Time that can be selected.
Max (To) Time (string)
Maximum (To) Time that can be selected.
Step (string)
Selection increment. you can use h - hours, m - minutes, s - seconds. Or combined: 1h5m
Save Ticks (string)
Save the value as a number of ticks.
Save Tick Offset (string)
Save value offset number.
Example:
10h5m,70h,5m,1s,1s
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
format (string)
Date/Time format. Similar to PHP date format.
Example:
[Field Name]
Value Processing Parameters:
Format (string)
PHP date format i.e. 'h:i:s'
Example 1:
[Field Name]
Example 2:
[Field Name:"h:i"]
image - Image File
Provides Image Upload functionality.
Field Type Parameters:
Image Size Options (imagesizelist)
You may specify various size options. When image file being uploaded, the Custom Tables will create a modified version(s) of the image file based on the settings provided.
Image Processing Methods (multiselect)
Image processing methods that will be applied to newly uploaded image. This option available in Pro Version Only.
Folder (folder)
Folder where all the files will be kept. By default /images
Example:
"id,100,100,,jpg",,/images/product_photos
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
imagegallery - Image Gallery
Provides Multiple Image Upload functionality.
Field Type Parameters:
Image Size Options (imagesizelist)
You may specify various size options. When image file being uploaded, the Custom Tables will create a modified version(s) of the image file based on the settings provided.
Image Processing Methods (multiselect)
Image processing methods that will be applied to a newly uploaded image. This option availabel in Pro Version Only.
Folder (folder)
Folder where all the files will be kept. By default /images
Example:
"id,100,100,,jpg",,/images/product_photos
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
file - File
Provides File Upload functionality.
Field Type Parameters:
Max File Size (int)
Obsolete. The max. upload file size is taken from PHP.ini file. No need to specify anything.
Folder (folder)
Folder where all the files will be kept. By default /images
File Types (string)
List of acceptable file types (list separated by space)
Save As File Name (string)
Specify the name of a newly uploaded file. You may use field tags [fieldname]
Custom PHP (string)
PHP file/function that will process file content before being downloaded by the user. File must be located at /components/com_customtables/customphp.
Example:
8,/images/user_files,"doc docx"
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Security (list)
Encrypts the link to the file and limits access time to it.
Options:
Link (list)
How to render the link
Options:
Icon (list)
Select the icon size
Options:
Target Window (list)
Target browser window when opening the link
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:timelimited,filename-link,32,parent]
filebox - File Box
Provides Multiple File Upload functionality. It also tracks versions.
Field Type Parameters:
Max File Size (int)
Maximum file size that can be uploaded to the server (in megabytes). Note: check your PHP settings as well.
Folder (folder)
Folder where all the files will be kept. By default /images
File Type (string)
List of acceptable file types (list separated by space)
Example:
20,/images/userfiles,"pdf ppt"
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Security (list)
Encrypts the link to the file and limits access time to it.
Options:
Link (list)
How to render the link
Options:
Icon (list)
Select the icon size
Options:
Target Window (list)
Target browser window when opening the link.
Options:
List Format (list)
How to the output list format.
Options:
filelink - File Link
Path to a folder on the server. Provides selection of the file at provided path.
Field Type Parameters:
Folder (folder)
Folder a user can select a file from.
Example:
/images/userfiles
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Security (list)
Encrypts the link to the file and limits access time to it.
Options:
Link (list)
How to render the link
Options:
Icon (list)
Select the icon size
Options:
Target Window (list)
Target browser window when opening the link
Options:
Example 1:
[Field Name]
Example 2:
[Field Name:timelimited,filename-link,32,parent]
creationtime - Creation Time
Stores the date/time when record was created.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Format (string)
PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.
Example 1:
[Field Name]
Example 2:
[Field Name:Y-m-d]
changetime - Change Time
Stores the date/time when record was last modified.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Format (string)
PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.
Example 1:
[Field Name]
Example 2:
[Field Name:Y-m-d]
lastviewtime - View Time
Stores the date/time when record was last viewed.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
Value Processing Parameters:
Format (string)
PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.
Example 1:
[Field Name]
Example 2:
[Field Name:Y-m-d]
viewcount - View Count
Stores the view count number.
userid - Author User
Stores the ID of the user who created the record.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
user - User
Provides User Selection box. It can also create a New User account if all nessesary fields are set: Name,Email,User Group(s)
Field Type Parameters:
User Groups (string)
Limit selection to certain User Group(s). Or used as default User Group(s) when creating a new user account.
Name (string)
Used to create new user account only. Field tags, example: [firstname] [lastname]
Email (string)
Used to create new user account only. Field tags, example: sales@joomlaboat.com
Name Filter (string)
Limit selection to certain name - name must content this characters.
Unique Users (radio)
Do not let assign same user account to different records.
Options:
Example:
,,,,unique
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
language - Language
Provides Language Selection box.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
server - Server Info
Server and execution environment variables. See: http://php.net/manual/en/reserved.variables.server.php
Field Type Parameters:
Option (list)
Select what information to save.
Options:
Example:
REMOTE_ADDR
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
id - Custom Record ID
Autoincremented ID. parameter: start from number
Field Type Parameters:
Start Number (number)
The value starts from number
Example:
3
phponadd - PHP On Add
Executes PHP script on record added event.
Field Type Parameters:
PHP Script (string)
Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.
Example:
"Time is ".(time()+3600)
phponchange - PHP On Change
Executes PHP script on record change event.
Field Type Parameters:
PHP Script (string)
Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.
Example:
"[firstname]"."[lastname]"
phponview - PHP On View
Executes PHP script on record view event.
Field Type Parameters:
PHP Script (string)
Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.
Store in database (list)
Store the field value in the database.
Options:
Example:
"Time is ".(time()+3600),dynamic
sqljoin - Table Join
Left Join to another table, finds the record and reads value of any field.
Field Type Parameters:
Table (table)
Type the name of the Custom Table to join/link with.
Field Name (string)
Type the field name to return the value by defualt. You may type layout name instead. options: 'layout:layout_name' or 'tablelesslayout:layout_name'
Filter (string)
Limits records using filter. Example: [age>30] where age is a field in joining table
Dynamic Filter (string)
Requires that joining table contains Table Join field to use it as a Category Filter
Order By (string)
Field name to sort record by
Allow Unpublished (radio)
Allow to select unpublished records.
Options:
Selector (list)
How to select records.
Options:
Add Foreign Key (list)
A FOREIGN KEY is a key used to link two tables together. The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables. Like deleting table records. Enabled by default.
Options:
Example:
products,title,,,title,true,dropdown,noforignkey
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Filter (string)
Overwrites field type filter parameter. Limits records using filter. Example: [age>30] where age is a field in joining table
Example:
[Field Name]
googlemapcoordinates - GPS Coordinates
Google Map Coordinates (Latitude and Longitude) with selection map
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
dummy - Translation
Use field name to add translations of some terms in your layout. This doesn't store anything in the Data Base.
article - Article
Select Article box.
Field Type Parameters:
Category ID (int)
Category ID to allow selection from that category only.
Example:
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
multilangarticle - Article (Multilingual)
Select Article box per each language installed.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
md5 - MD5 Hash
MD5 Hash calculated based on selected fields values.
Field Type Parameters:
List of Fields (field)
Field Values will be taken and MD5 Hash code will be calculated over it.
Example:
"firstname,lastname,birthdate"
log - Change Log
Logs all record modifications. User, Datetime, IP. You can return to the previous version of the record.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
usergroup - User Group
User Group Select Box.
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
usergroups - User Groups
User Group Multi Select Box
Field Type Parameters:
Selector (list)
How to select records.
Options:
Example:
multi
Edit Record Parameters:
CSS Class (string)
Name or names of CSS class(s).
Attributes (string)
Optional attributes like: disabled, onclick, onchange etc.
Example:
[Field Name]
JoomlaBoat.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters
the trademark holder in the United States and other countries.