Hello all. having some trouble. I set up a form with multiple choice questionnaire where each choice has a unique score where the total some based on the answers gives a range where it will determine the reediness of an organization, we are consulting. The scores are then set up to our dashboard where we can determine what path to pursue for their consultation. it seems like I can get the scores to be set up correctly within the form and could use some serious help!
I’m not sure I understand your question, but are you trying to display mathematical calculations or formulas on the form itself?
That is not possible with Airtable’s forms. You can only do that within Airtable after the form has been submitted.
However, if you want to display mathematical calculations on your form itself, you can do that with Fillout’s advanced forms for Airtable.
Fillout is 100% free, and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
- Using Fillout to create an eSignature approval process with PDF file creation.
- Using Fillout to create an order entry form with line items.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with this or anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
So I just want my clients to answer the form questions best related to their organization. and within our dashboard in air table it will score their related responses. I just need help to set up the form and dashboard so it can do just that score the responses but only we would see the score internally
Hey
If the former, then you’ll need to go with Fillout as suggested by Scott (or set an automation where they would get the score via email). If the latter, the Airtable should work.
Mike, Consultant @ Automatic Nation
Yes, as
Hey
Scoring System Overview
GROW Stage Section Max Points Focus
GUIDE 1–3 20 points Basic business foundations
REFINE 4 20 points Strategy and planning
OPTIMIZE 5–6 30 points Certifications and proposal readiness
WIN 7–8 30 points Bid tracking and competitive readiness
Total 100 pts
---
Detailed Scoring Breakdown
SECTION 1: Business Overview (Max: 10 pts)
· Business in operation 2+ years: 3 pts
· Has a business bank account: 2 pts
· Uses bookkeeping software/pro support: 2 pts
· Financials (P&L, Balance Sheet) available: 3 pts
SECTION 2: Team & Capacity (Max: 10 pts)
· At least 1 FTE: 2 pts
· Contractors or part-time team: 2 pts
· Can scale operations: 6 pts
SECTION 3: Business Strategy (Max: 20 pts)
· Has a strategic or business plan: 6 pts
· Actively targeting gov’t or corporate clients: 5 pts
· Clear and compelling unique value: 4 pts
· Services clearly defined: 5 pts
SECTION 4: Certifications (Max: 15 pts)
· At least 1 certification: 5 pts
· SAM.gov registration: 3 pts
· State/local registration: 3 pts
· DUNS/UEI number: 4 pts
SECTION 5: Proposal Toolkit Readiness (Max: 15 pts)
· Capability statement: 5 pts
· Past performance documented: 5 pts
· Has internal or external proposal support: 5 pts
SECTION 6: Bid Awareness (Max: 20 pts)
· Currently tracking bids: 5 pts
· Knows sector(s) to pursue: 5 pts
· Serves multiple states or regions: 5 pts
· Defined 12-month contracting goal: 5 pts
SECTION 7: Support Areas (Self-Identified Needs) (Max: 10 pts)
· Selected 2+ clear support needs aligned to GROW stages: 5 pts
· Open-text goal indicates proactive growth mindset: 5 pts
Readiness Levels (Total Score Interpretation)
Score Range Readiness Level Recommended Starting Point
85–100 Contract-Ready Start immediately with WIN (bid search + proposals)
65–84 Nearly Ready Begin with OPTIMIZE (certifications + toolkit)
45–64 Emerging Begin with REFINE (business & growth strategy)
< 45 Foundational Start at GUIDE (orientation + planning roadmap)
Hmm could you provide some examples of the questions, their answers, and the scores?
Here’s something I threw together on the off chance it’s helpful

Formula for ‘Question 1 Score’
IF(
FIND(
'Answer 1', {Question 1}
),
5
) +
IF(
FIND(
'Answer 2', {Question 1}
),
3
) +
IF(
FIND(
'Answer 3', {Question 1}
),
1
)
Formula for ‘Question 2 Score’
SWITCH(
{Question 2},
'Answer 4', 1,
'Answer 5', 2,
'Answer 6', 3
)
I do free half hour calls and you can grab a time here too, think it might be faster!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.