You can add calculations to a form by inserting a formula field and writing expressions that reference other answers, much like spreadsheet formulas. Totals, scores, and estimates then compute live while the respondent types. SharaForms ships this natively, so no scripts, plugins, or exports to spreadsheets are needed.
Forms that improve the moment math appears
- Quizzes that turn correct answers into a live score.
- Estimators that price services from quantity and tier inputs.
- Assessments that convert ratings into readiness or risk bands.
- Expense and timesheet forms that sum line items on entry.
- Order-style forms that subtotal choices before any checkout step.
Setting up your first calculated field
- 1
Collect the inputs first
Add number, choice, or rating fields for everything the math depends on. Give each a clear label, since labels become your references inside formulas.
- 2
Insert a calculation field
Open the builder, add a formula or calculation block where you want the result to appear, and open its editor.
- 3
Write the expression
Reference earlier fields by name and combine them with arithmetic. A simple line item total looks like quantity times unit price. Conditional rules let you apply different rates for different tiers.
- 4
Preview with real values
Open the live preview, enter sample answers, and confirm the result updates correctly before publishing the form.
Expressions worth knowing
| Goal | Shape of the formula |
|---|---|
| Line total | quantity multiplied by unit price |
| Quiz score | sum of points awarded by each scored question |
| Tiered pricing | conditional rule picking a rate, then multiplying by volume |
| Weighted rating | each rating times its weight, added together |
Mistakes that break trust in the numbers
- Leaving inputs empty with no fallback, which shows blank or broken results.
- Hiding intermediate math people expect to verify, like per-item prices.
- Rounding too early inside multi-step expressions, drifting final totals.
- Testing only happy paths instead of zero, maximum, and odd combinations.
Templates to start from
Frequently asked questions
- Do respondents need to refresh to see updated totals?
- No. Formula fields recalculate immediately as answers change, so totals, scores, and estimates stay current throughout the session. What respondents see is always derived from their latest answers without any manual refresh or submit step required.
- Can calculations run conditionally?
- Yes. Formulas support conditional rules, so different rates, weights, or bonuses can apply based on earlier answers. A service estimator might use weekend rates, or an assessment might award bonus points above a threshold, all inside the same expression.
- Can I use the computed result somewhere else?
- Yes. Calculated values behave like normal answers once submitted, so they appear in your dashboard columns, export to CSV and Google Sheets, flow into notification emails, and travel through webhooks to whatever system consumes them next.
Put this to work on a real form
Free plan, unlimited forms and submissions, all three presentation modes included.
