Skip to main content

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:

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 ​@Cj_Coleman does the end user (client filling out the form) need to see the score as well, or is score something that only your team internally needs to see?

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 ​@Mike_AutomaticN said above, you can do all of this natively within Airtable. If you need to hire a consultant to help you with this, feel free to contact me through my website: ScottWorld — Best Airtable Consultant


Hey ​@Mike_AutomaticN So the client does not need to see the score just my team so we can determine what stage we need to start them at. here is a doc for you to further understand our objective 

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