← All guides
✅ Build your own form

How to check your form gives the same answers as your spreadsheet

About 5 minutesNo codeFree ChatGPT account works

Give ChatGPT a few quotes you already know the answer to, inputs and totals, and ask it to test the form against them. If every total matches, publish. If one is off, say which and it fixes the formula. CalcForms will not publish a form while a saved test fails.

Step by step

  1. Pick three real quotes

    Choose ones that use different paths: a small job, a big one, one with the add-on ticked. Write down the inputs and the total you actually charged.

  2. Give them to ChatGPT

    "Test the form with these: 1,800 sq ft, asphalt, tear-off, total $8,950. 2,400 sq ft, metal, no tear-off, total $22,800. …"

  3. Read the result

    ChatGPT reports each one as a match or shows the difference. A mismatch usually means a rounding rule, a fee you forgot to mention, or a bracket edge.

  4. Fix in plain words

    "Round the total to the nearest $10." or "Add the $150 permit fee when the job is over 2,000 sq ft." Then test again.

  5. Keep the tests

    Say "save these as the tests for this form." From now on, any change that breaks a test blocks publishing until you fix it or update the test.

The words to say

Copy this into ChatGPT (with CalcForms added) and fill in the brackets.

Say this to ChatGPT

"Test this form against these past quotes and tell me which match: [inputs → total], [inputs → total], [inputs → total]. Save them as the form's tests."

What you will see

A short report per quote: match, or the expected and actual totals side by side. Once saved, "publish" either succeeds or tells you which test failed.

Common mistakes

FAQ

What if I do not have past quotes?
Make three up and work them out on paper or in your spreadsheet. The point is a known answer.
Can I test after the form is live?
Yes. "Re-run the tests" any time, and every later change is checked against them before it publishes.
Can I re-run an old reply with new numbers?
Yes. "Take Jane's reply from Tuesday and change the material to metal." You see the new result without asking her again.

Rather do it together?

Book a free 30-minute onboarding call. We open your spreadsheet and build the form with you.

Book a free call → Or start in ChatGPT