Good day all! New Airtable user here.
I’m experimenting with Airtable Pro to gain some functionality over Google Calendar for planning complex jobs across multiple manufacturing departments within our facility.
I’m using it as a glorified calendar and I’m trying to get over a couple hurdles I cannot figure out.
I need to export about 12 different Google Calendars into Airtable, which I’m able to do by exporting each Calendar as an .ics file, and importing that file into Airtable. Here’s where I run into two MAJOR hurdles.
I need to be sure I maintain the NAME of each Google Calendar as it’s imported into Airtable, into a field titled “Department”. For example, I have a Google Calendar named “Material Arrival”, and I have a department in the drop-down menu titled the same. However, when I import the .ics file, I do not get an option to map the Google Calendar’s name to any field. Nor do I seem to have an easy option to automatically set the Airtable field to say “Material Arrival” for all the new entries. They just all import with that field blank. There are THOUSANDS of entries, there’s no way I can go manually click each one to say “Material Arrival”.
I only want to import .ics calendar entries that are applicable to 2021. These calendar entries go back to 2014, the only ones that matter are 2021. I have only been able to export ALL of the Google Calendar’s entries rather than just a selected date range. How can I get them from Google Calendar into Airtable?