![]() The final step of my Zap will post to a Slack channel and request that specific attributes of each Work be added. This step will allow the Zap to thread subsequent messages about the same Work. That way, I can see at a glance that all five parts were added, but the main message contains the action item for me to add attributes. ![]() I’d like the first run of the Zap to post a Slack message, and for the remaining Slack messages to be threaded. That means the Zap will run five times on each Work, but only create the Work record once. The Zap is going to run when a group of five PDF files are added in a folder to the Drive. Remember, only one Works record is created for every five Sheet Music records! Then, a Find Message step in Slack searches a specific channel I created to see if a message has already been posted about the Works record. I then added a Delay After Queue step to enable Slack threading - you’ll see why in the final step! Next, a Create Record step creates a new Sheet Music record, and adds the Google Drive link to the record field. We only need to create the Works record once for each set of 5 Sheet Music parts, so the Find step will return the Works record on the other 4 runs. Remember, each Work contains 5 parts known as Sheet Music! The Zap is going to run on each Sheet Music item added to the Drive. This Works record will populate my table showing all the Works in our library. I then added an Airtable Create Record step that finds or creates a new Works record. I created a naming convention for each file so my Formatter steps can reliably return the data. Next, I used a series of Split Text Formatter steps to split the file title and return the composer name, arranger name, work title, and instrument. I set up my filter to only continue if one of those keywords appeared in the file name field, AND they were a PDF file. I knew that my file names would contain certain keywords, and that the filetype would be a PDF. I then added a Filter step to only allow certain files to continue. This triggers on any new File added to Google Drive. In other words, if I added a folder of five parts, the Zap would not trigger.įor my workflow, I used the New File trigger. The catch here is that the Zap will only trigger on files added to that specific folder, it will not trigger on subfolders. If you’d like to trigger on a specific folder, you can select New File in Folder. The first step is to create our Google Drive trigger. I created a Zap that triggers on a New File in Google Drive, parses the part details from the file name, creates new Records in Airtable, and pings our group Slack so we can manually add finer details to the newly created records. ![]() ![]() I created a new folder in Google Drive for our music library, and I would add the files for the database to that folder. The database also contains a Works record for each piece, and details attributes like work length and musical style.Įntering this information manually would take, for lack of a better term, FOREVER. We decided to create an Airtable database that contains a single record for each part with a direct link to the Google Drive file. The challenge with a large library is that it can be difficult to browse and find results that match a given set of attributes. This is an arrangement of a popular ballad, from a movie, about 3 minutes long, etc. For example, let’s think about “Somewhere Over the Rainbow”. ![]() We keep a folder with the title of the work, and each folder contains five PDF files for each part.Īny given work also has a number of attributes that are impossible to capture in a single file name. So for a standard brass quintet, there will be five “parts” for each work: Trumpet 1, Trumpet 2, Horn, Trombone, and Bass Trombone (Tuba). A “work” (a song) consists of parts for each member of the group. Or have you thought about doing a file reorganization project, and wondered if there’s a way to automate a record of which files have been added to the new folder?įolks with large collections of video files, audio files, or other libraries of information often try to use nesting folders in a Drive to keep things organized, but it can be hard to browse through items that meet certain criteria.įor example, my brass quintet has a large library of sheet music. Background Infoĭo you have a lot of files in your Google Drive, but you can never find what you’re looking for? Hi there, this is Erin Oz from the Premier Support Team with a workflow idea to share. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |