Search:  

Previous pageDatatypes Next page
Datatypes 

The system supports the following data types within Tables. There are not just the "traditional" datatypes like 'Text' and 'Integer', but also larger types like 'File', which accepts an uploaded file, and functionally-loaded ones like 'Product family' and 'Shipping Band'.

The most complex of all is probably the 'Record Link' datatype, which allows you to reference data in another Form, and has a wealth of options controlling the way in which data is loaded and displayed.

Read-only datatypes

If included in a Table, these fields will be automatically filled-in by the system, and their values cannot be manually changed.

Record ID

Contains a system-generated unique reference for the record

Username

Identifies the user who created the record

Created

The date when the record was created*

Updated

The date when the record was last updated

Updated by

The user who last updated the record

View Code

A unique hash, or password, which can be used to permit a user to view the record

Edit Code

A unique hash, or password, which can be used to permit a user to view and edit the record

Creation Site Referer

The page the user who created the record came from when they visited the site*

Creation Page Referer

The page the user who created the record came from immediatley prior to hitting the Form page

Creation IP Address

The IP address of the user who created the record*

 

 * When fields (marked * in the above) are edited and 'Save as new record' is chosen, the new record will either be given the values from the original record, or take on new values relevant to the current circumstances. This behavior is selectable in the Edit Table, field configuration dialogs (acessed from the floating-toolbox of the Table).

Full list of datatypes

IconRecord ID
IconLarge Text
IconTimespan
IconCreation Site Referer
IconUsername
IconRich Text
IconRadio Button Group
IconCreation Page Referer
IconCreated
IconEmail
IconDrop Down List
IconCreation Client IP Address
IconUpdated
IconCheck Box
IconImage
IconCreation Server IP Address
IconUpdated by
IconInteger
IconFile
IconItem Type
IconView Code
IconNumber
IconRecord Link
IconInstallation ID
IconEdit Code
IconCurrency
IconMultiple Record Link
IconText
IconDate/Time
IconProduct Family
           
 

DATA

Managing Data

Tables

Referential Integrity 

Data Entry Forms

Queries and Views

Custom Views

 

USERS & SECURITY

Users & Permissions

User Group Manager 

User Registration

Access Codes & Agreements

Personalizing Experience

Managing Profiles

 

SaaS

SaaS Server

SaaS Site Manager

SaaS Client Accounting

SaaS Templates & Clones

SaaS Self Service

Associates System 

 

CMS

User Editable pages

CSS Editor

Editing Pages

Direct URLs

Using Javascript & JQuery

Content Approval & Workflow

 

WEB

Key Concepts

Components

Understanding Embeds

Site Building

Themes System

SEO Optimization

 
           
 
clearString   neatComponents™    © Enstar LLC  1999-2019 All Rights Reserved      Terms of Use      Privacy & Cookies      Contact us...
 
 
 
 

 

Docs HomePrint:   Print this page