Field Descriptions / Static Text Fields
Styling your Field Descriptions
Formulas in Field Descriptions
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.
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 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.
If you would like to add an image that will load every time anyone views your form, you can do so by using an HTML image tag or BBCode tag. For this to work correctly, your image must have an associated URL (your image may be hosted on Ragic or elsewhere on the internet).
You can upload your image to comments and right click on it to get the URL.
Add a Static Description Field to the field you would like your image to be displayed in.
Use this snippet to point to your image:
[img]your URL here[/img]
Make that sure you save the changes you have made to your design.
Your image will now be displayed in both the online and Printer-Friendly versions of your form. This is useful if you would like to add logos, banners, headers or footers to customize your forms.