Timesheets - from Jotform - single field 3 employee names - need to split

[kalpsb]

Hi I am a newbie to Airtable so please bear with me.

I have been using JotForm to collect timesheet data from employees

and one field contains team members i.e. could be more than one team member in a single field and appear to be space separated in Airtable - in the JotForm itself this is a multiple select for each team member present that day

How can I view/split this to make individual timesheets for each member listed in that cell i.e. duplicate the view for each one of those team members please?  This would then enable me to share each team members timesheet with them individually?

The team member field looks like this:

Thanks

Kalpesh

[ScottWorld]

Probably the best & easiest way to do this would be to create an automation to separate those names before they get into Airtable.

The easiest way to do this would be with Make's JotForm integrations and Make’s Airtable integrations.

I’m assuming that JotForm sends those items as an array. Make offers an “iterator” tool that lets you loop through arrays so you can create individual records in Airtable.

However, if you've never used Make before, it could take a few hours to learn how to use it, so I’ve assembled a bunch of Make training resources in this thread: https://air.tableforums.com/t/make-com-basic-navigation-tips/277

And Make even created an entire Make Training Academy here: https://academy.make.com/?pc=scottworld

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here:
https://www.youtube.com/watch?v=SbH9iE5ncCk&list=PLqssva4liHRwHhQIpTXekG8WObEoyC2F1

[TheTimeSavingCo]

You can do this just with JotForm and Airtable alone, really.  You're using the JotForm integration, right?  If so, just make the multiple select field from the JotForm map to a multiple select field on Airtable, and it'll appear as selected options in that multiple select field:

And on submission:

Here's the form

I'm assuming you have a 'Timesheets' table or something, so just make an automation that'll use that multiple select field as a list, and then make it create one record per multiple select option in the 'Timesheets' table:

And here's a link to the base so that you can copy it