Knack form submitted with multple names need to split into one record per name

Ask the Community Get Answers
1

Get Answers

I have created a training database where you can add one name for trainee or multiple names for the training. When the form is submitted it puts all names in the name field. How can I create one record for each name in the table.

2

Hi there — welcome to the community!

What you’re describing is a common need in Knack: you’ve got a form where users can select one or more trainees for a training session, but instead of storing them all in a single field, you want to create a separate record for each trainee — for example, to track attendance or participation.

:counterclockwise_arrows_button: Why This Happens

By default, Knack just stores the selected trainees in a multiple-connection field on one record. It doesn’t automatically create a new record (like an attendance log) for each selected trainee.

:white_check_mark: Solution Options

  1. Use a Knack Flow (No-Code – Easiest)

If you’re on a plan that includes Knack Flows, this is the most straightforward solution:

  • Trigger: When a new training record is created.
  • Loop: Over each trainee in the multiple-selection field.
  • Action: Create a new attendance (or participation) record for each one, connecting it to both the training and the trainee.

No code is needed — it’s all done through the Flows editor inside Knack. This is definitely the simplest approach if Flows are available on your plan.

  1. Use Make (Low-Code / External Automation)

If your plan doesn’t include Flows or you want a bit more flexibility:

  • Use Make (formerly Integromat) to watch for new training records.
  • When triggered, retrieve the list of selected trainees.
  • Loop through each trainee, and create a separate attendance record using Knack’s API.
  • Make has built-in support for Knack and is great for automation tasks like this.

This works really well if you need more advanced logic (e.g., filtering, branching, notifications).

:warning: Is It Possible with JavaScript?

It may also be possible to do this using custom JavaScript inside Knack, but I’m not a coder myself, so I can’t offer much support on that side.

1 Like
3

Thank you for quick response. I like the idea of creating a Flow with an iterator so I have started creating the flow by adding an action of Record Created

Whenever a record is created in the “Toolbox Talks” table

image001.png1845Ă—304 18.5 KB

In the table “Toolbox Talks” there is a field called Employee which is connected by a Many to many to the Accounts table and allows for multiple selections to attend the training.

image002.png1553Ă—353 50.7 KB

I then added the iterator but when I go to setup fields no rows show up to select from.

image003.png1835Ă—628 35.3 KB

I am assuming I am doing something incorrect but not entirely sure what it is would you be able to assist me in some troubleshooting steps?

4

Hi @Laurie - I thought I’d take a look this morining and try to replicate this in Flows (as I’m new to it too) but I’m also getting stuck with the Iterator. I have sent the below video to @JohnKaras - Head of Product at Knack, to see where we are going wrong.

I’ll circle back as soon as I hear more, unless John updates this thread :slightly_smiling_face: