Price line
A Price line works out one line of a quote from a price. Click Build the line, then choose what to work out:- Type the percentage, or Use a saved one: a rate the snippet already has, such as
DISCOUNT, so several lines share it. - Choose how many decimals the answer keeps: 0, 1 or 2.
- The line reads a price box that’s already in the snippet. If there’s none, the window adds one at the cursor.
Calculator
A Calculator works out a number from figures you fill in, and prints the working, like100 - 25 - 5 = 70. Click Build the calculation and choose:
- It takes 2 to 10 numbers. Each box is named in the form, like Add: first number. The name isn’t printed.
- Dividing by 0, or a percent change from 0, prints no answer instead of a wrong one.
Interest
Interest has two buttons, Simple interest and Compound interest. Each adds its number boxes and prints the working with the answers:- Simple interest prints the interest, then the total with the principal.
- Compound interest prints the final amount, then the interest earned.
- Times a year starts on 12, which is monthly. Type 1 for yearly, 4 for quarterly or 365 for daily.
- An empty, zero or negative box prints no answer instead of a wrong one.
- Compound interest needs extension version 3.52.0 or later. An older one prints the working without the answer.
Remove a formula
The formula windows show how many formulas the snippet has. Manage lists them, each with Remove and Undo.Conditions
Condition inserts{if:A > 0}text{endif}. Replace A > 0 with what has to be true and text with what prints when it is.
- Numbers compare with
>,<,>=,<=,==and!=. - Text compares with
=or!=against a value in quotes:PLAN = "annual". {elseif: ...}adds another case and{else}covers the rest. The first true branch prints, and the others don’t.- The first
{endif}closes the block, so a condition can’t sit inside another one.
Greeting
Greeting inserts{greeting}, which prints Good morning, Good afternoon, Good evening or Good night from the clock where the snippet expands. Morning starts at 5, afternoon at 12, evening at 18 and night at 22.
- It follows the snippet’s language: English, Italian, Spanish or French. Force one with
{greeting: lang=ES}. - Replace a wording with your own:
{greeting: morning=Hi there}.
Writing formulas by hand
Type{= and } around any calculation: {=PRICE * QTY}.
- Use
+,-,*,/and brackets, with the names of your number fields. - Functions:
round(X, 2),avg(),min(),max(),abs(),floor(),ceil()andpow(X, N)(X to the power N). - Answers keep up to two decimals.
- A field that doesn’t hold a number makes the formula print nothing, not a wrong total.
Days between two dates
datetimediff(DATE_1, DATE_2, "calendar")counts whole days between two date fields.datespan(DATE_1, DATE_2, "inclusive")counts both ends. With"between"it counts the days in between. It prints nothing when a date is missing or the end comes first.
Dates that fill themselves in
{time: DD/MM/YYYY} prints today’s date. The Automatic button in the Fields group writes these for you. See Fields.
Month and day names print in English. Add
shift= to move the date, like {time: DD/MM/YYYY; shift=+3D} or {time: DD/MM/YYYY; shift=next monday}, and at=09:00 to fix the time.
Upper and lower case
Wrap text in{case: upper} and {/case} to change its case after it expands. The other options are lower, title and sentence. Fields inside it are filled in first, then cased.