filemaker pro script examples to clear field in all records

On Windows, use the Tab key to move among buttons, text boxes, and pop-up menus. Your calculation should look like Figure 4-2. The formula now reads Lease Duration * Rental Fee. In the Current Table list, double-click the Rental Fee field. In the Operators section of the window, click the * sign. You could type the field’s name, but if you make a typing error, FileMaker will bark at you, so it’s usually easier to point and double-click. The field’s name appears in the calculation area of the window. In the Current Table list, double-click the Lease Duration field. It’s based on data in the Lease Duration and Rental Fee fields. Here’s where you’ll write the formula that gives you the Lease Value. In the Field Name field, type Lease Value.Īs with other database elements, it’s best to use simple, descriptive names for your new calculation field.įrom the Type pop-up menu, choose Calculation, and then click Create.

(See the box on Use the Keyboard for more information about using this window.) The Fields tab is where most of your field creation takes place. Choose File→Manage→Database, and then click the Fields tab (if it isn’t already active).

Filemaker pro script examples to clear field in all records