Working with our customers, we designed the type-in formula bar to be easier to use and a more intelligent way to build formulas for your Klips. You can type a formula directly in the formula bar or select from a list of functions. When you start typing a function name in the formula bar, a list of functions filtered by the letter you entered is displayed. Online help with examples and parameters automatically pops up for each function.
Watch this video demo. It introduces key features of the type-in formula bar, and answers common questions.
Watch this video to learn more about working with the type-in formula bar.
In this article:
Formula bar shortcuts
Here are some useful hints on how to use many of the features available in the type-in Formula bar.
Type-in assistance:
Using operators in formulas:
In the Formula Bar: |
What it does |
+ |
Add. |
- |
Subtract. |
* |
Multiply by. |
/ |
Divide by. |
< |
Is less than. |
> |
Is greater than. |
<= |
Is less than or equal to. |
>= |
Is greater than or equal to. |
= |
Is equal to. |
!= |
Is not equal to. |
Selecting content in the formula bar:
In the Formula Bar |
What it does |
Click anywhere in the formula |
Sets the focus and places the cursor. |
Click on a parenthesis (brackets) in your formula |
Places the cursor next to the clicked parenthesis. The matching parenthesis is also selected. |
Double-click on a string |
This selects the string |
Triple-click |
Troubleshooting in the formula bar
Errors are highlighted in the formula bar:
- A function or parameter that has the wrong syntax appears highlighted in red in the formula bar.
- A tooltip is displayed when you hover over a syntax error in the formula bar.
- If the formula evaluation results in an error, a red border will appear around the entire Formula Bar and an error icon is displayed.
Pop-up function help
When you select a function, a help pop-up displays a description, examples and parameter information. You can dismiss the Help pop-up by clicking the X in the dialog and reactivate it at any time with the Show Function Help button.
Show Function Help button