RB User Guide > Tools > Form Templates > Creating/updating forms & letters

Editing form templates: Formulas options

If your form has a table in it, use Form Templates’ Formulas options to add custom formulas to your forms.

Continued from Creating/updating forms & letters.

In the New Form/Edit Form window, click inside a table where you want to insert a formula. Then click Formulas:

• Formulas

  • Formula

    Enter your formula in the field

  • Functions

    Select a function in the drop-down.

• Number Format

  • Number format:

    Select the style that you want for your numbers in the drop-down.

  • Cell Type:

    • AB
    • 12

• Formula Settings

  • Enable Formula Calculation

     

  • R1C1 Reference Style

     

  • A1 Reference Style

     

Step-by-step instructions

• Creating new forms & letters

• Editing form templates: File options

• Editing form templates: Home options
• Editing form templates: Insert options
• Editing form templates: Layout options
• Editing form templates: View options
• Editing form templates: Data Fields options
• Editing form templates: Table Tools options