Field Templates wrap every field in your database. By editing the field template, you can control how any field in any table for any view is presented. You can create user messages, style your fields, make fields links and more.


Some of the other things you can change with field templates

Field templates can have HTML, CSS and JavaScript code in them. In these help documents, we will give you some basic code that you can copy and paste into your field templates to customize your fields.


The default field appearances for the grid view

This grid view has an extra icon that lets you click it to view the record.


The id field template has a second icon in it

Changing a Template

Go to the table and view for which you want to change a field template. Go to Design > Design Mode On.

Click the gear icon at the top of the column you want to change.

Enter HTML in the field to alter the appearance of your field.

Add icons with links

<a href=db.aspx?t=HelpTopics&id=[DATA]&vid=2 id="edititem"><img align=absmiddle src=/c6401/630.png height=20 width=20 align=absmiddle border=0 alt="edit"></a><a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a><a href="db.aspx?t=HelpTopics&id=[DATA]&vid=11" title="View Details">[DATA]</a>

In the HTML above, the following link was not part of the default template. Adding this creates a link to the detail view, that is an image (an icon).
<a href=db.aspx?t=HelpTopics&id=[DATA]&vid=11 id="viewitem"><img align=absmiddle src=/images/webexview.gif height=20 width=20 border=0 alt="edit"></a><br />

Change the color of a link

<span style="color:red;font-weight:bold">[DATA]</span><br /><br />Put a <span> with the style you want around the [DATA] tag.<br />

Make a field a radio button

[radios:yesno:[DATA]:autoupdate]

Make a field a select box

[select:States:[DATA]:autoupdate]