Help

Creating a database
F
ILEMAKER PRO HELP 207
Functions reference (alphabetical list)
Adding a new line to the results of a formula
You can format the results of a formula by inserting carriage returns in your calculation.
To add a new line to the results of a formula:
1. With the database open, choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Fields tab.
3. If your database contains more than one table, select the appropriate table from the Table
list.
4. In the Fields tab of the Manage Database dialog box, select the calculation field, then click
Options.
5. In the Specify Calculation dialog box, click to insert the cursor in the place you want the line
to break.
6. Click the ¶ button (carriage return operator) to insert a line break.
See Defining calculation fields for information about the dialog box.
7. Click OK.
Note Type \¶ (backslash followed by a carriage return operator) to enter a carriage return
(paragraph) symbol instead of an actual line break.
Examples
Field1 & ¶ & Field2 returns:
Fred
Jane
when Field1 contains Fred and Field2 contains Jane.
"Fred ¶ Jane" returns:
Fred
Jane
Related topics
About formulas
About functions
Functions reference (category list)
Functions reference (alphabetical list)
Text operators
Using operators in formulas
Adding comments to a formula
For complex or infrequently used formulas, you can add comments to explain the details. Use C
style or C++ style comments, which you can enter anywhere in a formula.
C style comments start with the characters /* and finish with the first occurrence of the characters
*/. Your explanatory text appears between the two asterisk characters. Comments can begin on
one line and end several lines later. You can nest C style comments.