Skip to content
Office

Office Form feature

Calculated fields

Work out prices, scores and totals as people answer, then show the result, use it in logic or charge it.

How a calculation works

A calculation is a number that starts at a value you choose and runs through steps in order: add, subtract, multiply, divide or set. Each step can use a fixed number, a number someone typed, the hidden value behind a choice, a product total or another calculation. A step can have its own condition ("only if Frequency is filled").

Text calculations work too: set, add to the end or add to the start, handy for building a summary line.

Where the result goes

Results update live while someone fills in the form. Put one in a paragraph ("Your estimate: {Estimate}"), in the thank-you screen, in emails and PDFs, use it as the payment amount, or test it in logic to choose an ending. Every result is saved with the response, so you can sort quotes by size.

Example

A cleaning company's instant quote

Base price $40. Add $20 per bedroom and $15 per bathroom. Then multiply by the frequency: one time is 1, every two weeks is 0.9, weekly is 0.85. A three-bed, two-bath home every two weeks shows $117 per visit before the person even leaves their email. Anything over $200 goes to a "We'll call you to confirm" ending instead of the booking button.

How to set it up

  1. 1

    Open Calculations in the builder and add a number calculation.

  2. 2

    Set the starting value, then add steps in order.

  3. 3

    Give choice options hidden values if a choice should change the number.

  4. 4

    Show the result with a {Field} token in a paragraph, or use it as the payment amount.

Calculated fields is part of Office Form and included on every plan.

Questions people ask

Can I build a scored quiz with this?

Yes, by giving options values and adding them up. For answer keys and grading, use Office's quiz product, built for exactly that.

Do people see the calculation?

Only where you show it. Calculations are hidden unless you put the result in a label, paragraph or ending.

Try Office Form with your whole team

7-day trial with every feature. Cancel from the billing page whenever you like.