Database Design Documentation
How can we help?
Full Site Search

Field Descriptions

Field Descriptions / Static Text Fields

A Ragic Sheet can contain more than just fields. It can also contain Static Form Descriptions that serve as instructions or decorative elements for your forms. Normally when you start typing in a field in Design Mode, it creates a field ready for input. You can change the editing mode by clicking on the Editing Fields button at the top, and then clicking on Editing Descriptions. By doing so, when you type on the sheet, you will be able to create Static Form Descriptions instead of Fields.

Another way to create descriptions is to go to the Add Component tab on the left, and drag and drop a Description from Static Text directly onto your sheet.

Styling your Field Descriptions

When you click to select a description field, you can change its style using the formatting panel embedded in the left sidebar.

You can change the font size and style, text alignment, text and cell colors, and link to a URL.

Selecting the color options for a Static Text Field will display a Color Picker, which allows you to adjust the canvas, choose a color swatch, or enter a hexadecimal code in the upper-left-hand corner.

To adjust the width of a Static Text Field in Design Mode, drag the lower-right corner of the field.

Formulas in Field Descriptions

Formulas work in Static Description Fields for display purposes only.

This is useful if you need to recalculate a formula each time your database form is loaded, but do not need to keep this value in your database itself. You will need to use BBCode for your formula to work.

Let's say that you would like to view a person's age according to their birthday. Writing [formula](TODAY() - A1)/365.25[/formula] into a description field would display the age of this person, which will always be recalculated according to the day that the form is opened.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google