Help

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

Topic Labels: Data Formulas Views
772 2
cancel
Showing results for 
Search instead for 
Did you mean: 
kalpsb
4 - Data Explorer
4 - Data Explorer

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:

kalpsb_0-1707249428095.png

Thanks

Kalpesh

 

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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

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:

Screenshot 2024-02-07 at 11.38.09 AM.png

Screenshot 2024-02-07 at 11.37.48 AM.png

And on submission:
Screenshot 2024-02-07 at 11.37.57 AM.png

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:

Screenshot 2024-02-07 at 11.42.02 AM.png

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