Skip to main content
Question

Analyze the evolution of skills

  • June 2, 2026
  • 3 replies
  • 23 views
Alexandra
Forum|alt.badge.img+1

 

I need to perform some calculations on the evolution of the skills of all participants individually, using the Airtable interface. For this, I need your help to create the data model.This is the information flow:1- At the beginning of the program, participants must fill out a Google form with 36 questions (never, rarely, sometimes, frequently, always) to assess their skills. The key is their email address.2- At the end of the course, they answer another Google form with the same 36 questions to assess the development of their skills. I already have a table with the participants' data, where the key is the email address.What is the simplest solution to implement this?I've already asked for help, but I haven't been able to implement the solution. :-)

    3 replies

    TheTimeSavingCo
    Forum|alt.badge.img+32

    Ah, could you talk a bit about what you’ve tried so far and what issues you’ve faced?

    If you could tell me what problems you had with the suggestion from the previous thread I could also try to help there

     

    I also do free half hour calls, feels like it might be useful to do a screenshare to talk through it and you can grab a time here if you’d like!

    Adam, Airtable Consultant - thetimesaving.company
    Alexandra
    Forum|alt.badge.img+1
    • Alexandra
    • Author
    • New Participant
    • June 3, 2026
    Thank you very much for your help.My first difficulty is the number of questions I didn't mention in my initial request for help. The skill assessment form (initial and final) has 35 questions, and the solution you suggested is limiting. Each skill is assessed through several questions.The questions should probably be in a different table.
    How can I ensure that when a form response is entered, that information appears in the "submissions" field linked to the "Submission" table?
    Another issue is that I need the data to be prepared to analyze the development of skills from participant to participant and from competency to competency within the interface.
     
    TheTimeSavingCo
    Forum|alt.badge.img+32
    How can I ensure that when a form response is entered, that information appears in the "submissions" field linked to the "Submission" table?

    Hm, what’s the Submissions field in this context?  Could you provide a screenshot of the table setup?

    ---

    Another issue is that I need the data to be prepared to analyze the development of skills from participant to participant and from competency to competency within the interface.

    Ah how you want the analysis displayed can heavily influence the data structure, and so if you could provide a mockup (maybe using Figma or Sheets or something) that would be really helpful

    Adam, Airtable Consultant - thetimesaving.company
    Terms & ConditionsAccessibility statement