Formatting and Rendering

 

For fields in Results Pages and those configured as non-editable (Display Only) in forms, Caspio Bridge offers a variety of formatting and rendering choices.

Formatting Fields

For all data types except for File, the following formatting options are available:

  • None – The value in the field is displayed exactly as it is entered in the underlying table.
  • Localization – The value in the field is formatted with your current localization settings for the selected format type.
  • Custom – Lets you define all format type settings. Select one of regional formatting patterns to serve as a basis and then modify the settings as needed.

The contents of File fields can be displayed using one of the following options:

  • Image – Displays the image contained in the field. You can specify the Width and Height for the image.
  • File – Displays the name of the file contained in the field. When Hyperlink for the download is checked, the file name becomes a link that users can click to download the file to their computers. Checking Include folder path in file name shows the complete path to the file in your Caspio Bridge account. Checking Enable custom hyperlink text allow you to customize the link display to the file in your Caspio Bridge account. You can use static text, or parameters to create dynamic link displays.
  • Auto-detect – The field is displayed as image if it contains an image, and as file name otherwise. Options available for both are the same as for Image and File.

Advanced Options

In Advanced mode, the formatting options described above are also available for values in dropdowns derived from a lookup table or view. After selecting the lookup table for the dropdown, go to the Advanced tab to set up formatting.

Formatting Inserted Field Values

When inserting fields into labels, confirmation messages and HTML blocks, you are prompted to select the format the inserted value will use. Format types available for each data type are shown in the table below.

Data type / Format type String Number Currency Percent LongDate ShortDate Time YES/NO
AutoNumber            
Text
Number      
Date/Time        
Yes/No            
File              

By default, the field is formatted as String. All format types use the current localization.

In Advanced mode, the formatting options described above are also available for values in dropdowns derived from a lookup table or view. After selecting the lookup table for the dropdown, go to the Advanced tab to set up formatting.

Formatting Inserted Field Values

When inserting fields into labels, confirmation messages and HTML blocks, you are prompted to select the format the inserted value will use. Format types available for each data type are shown in the table below.

Data type / Format type String Number Currency Percent LongDate ShortDate Time YES/NO
AutoNumber            
Text
Number      
Date/Time        
Yes/No            
File              

By default, the field is formatted as String. All format types use the current localization.

Formatting is not available for Mobile Forms

Rendering Text Fields

When displaying data that are in Text fields, you can render them in the following ways:

  • Text – This is the default behavior. Whatever character is in the field is displayed, and formatted according to your formatting selection. Caspio Bridge ensures that special characters are preserved and are properly escaped so they are not interpreted as tags by the browser.
  • HTML – Tells Caspio Bridge to treat the content of the field as HTML. It allows the browser to interpret your HTML tags as HTML code. By default, Caspio Bridge blocks all potentially unsafe tags. You can choose to Enable all HTML tags but note that this may result in a security threat to your application.
  • URL – Tells Caspio Bridge that this field contains a URL. Caspio Bridge creates a clickable link that can take users to the referenced page. By default, the URL appears as entered in the table, but you can Enable custom display and provide your own text for the link (such as "View details", for example). The referenced page may open in the same browser window (default option), or in a New browser window.
  • Email – Tells Caspio Bridge that this field contains an email address. Caspio Bridge creates a clickable email link that can activate the user's email software and pre-address a new message to the email address entered. By default, the email address is displayed on the DataPage, but you can Enable custom display and provide your own text for the link (such as "Send inquiry", for example). Optionally, enter a template Subject and Body for the email message. The user will be able to modify both the subject and the body in her email software.
In Mobile Forms, available rendering options are Text, WML, URL, and Email. They are similar to those described above but do not provide the custom display capability.