Skip to main content

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

 

You would probably be better off turning your multi-select field into a linked record field, and then using my solution #3 below.

However, all 3 of these solutions will handle multi-select fields as well:

  1. I don’t know how JotForm sends those names into Airtable, but if it sends those names directly into a multi-select field, then you could just create an Airtable automation to loop through the values of the multi-select field, and create a new record for each value that it loops through.
  1. However, if JotForm doesn’t work that way, then the best way of handling this would be to create an automation with Make's JotForm integrations to separate those names before they get into Airtable.

    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.

    In this video, I show how to work with Airtable arrays in Make.

    If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 
  1. However, instead of using Jotform, you may want to consider using Fillout’s advanced forms for Airtable instead.

    Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including direct communication with Airtable.

    So you could have your multi-select field feed directly into Airtable, and then you could run an automation to look through the multi-select items to create new records.

    Even better, Fillout lets you create linked records natively in Airtable, so this could be even easier if you changed your multi-select field to a linked record field.

    Fillout also offer the ability to update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, and much more.

    I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

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

 

Reply


Terms & Conditions