I apologize if the title of this makes no sense, but here is what I’m trying to accomplish:
I am running a certificate program where students must complete certain tasks for points to earn the certificate. I want to track these in airtable. I have two tables; One for Participants and One for Tasks, and they are linked so I can look at a participant’s progress in one table and can see who is completing which tasks in the other table. Each table has specific unique data for the tasks or participants.
I have run into a problem in that some of the tasks are able to be repeated, so I can’t use a linked record field to add a task twice to one participant. Here is a visual:
This is what I have currently (obviously simplified)
Participant 1: Task 1, Task 2, Task 3
In my participant sheet I need the ability to do this:
Participant 1: Task 1, Task 1, Task 2, Task 3
The participant sheet is set up to automatically calculate point totals for individuals, so my options are somewhat limited in how I can approach this.
To further complicate things, I am using a Jotform (connected to the base via Zapier) to allow the students to submit their tasks and would like to automate entry. This is set up and works, but the problem of not being able to add a value twice kills the functionality of the form.
I’m open to any suggestions and am happy to restate or further clarify if that helps.