One Click Audio Journal

[Jonathan_Letts1]

I use a single base (Contuity) as my relationship manager, task manager, journal, brainstorming tool, invoice generator, and more.

Scenario:
Journaling is good for you
I was using voice memos to record a 10 minute audio journal entry every day and I didn’t want my audio journals to be seperate from my written journal entries (in Airtable).

I set up a single click mobile “start recording” program that saves the audio as an attachment.

Here’s how
Workflow:
Tap icon
Desktop icon opens “Shortcuts”
Shortcut begins recording audio
Tap to stop recording
Email is generated with audio attached (.m4a), subject is populated with “Audio”
“To” is populated with “trigger@applet.ifttt.com”
“From” is populated with my email
IFTTT captures email and creates a new record with audio as the attachment and the subject and any text in the notes field.

What’s been great is discovering how frequently I use it. People suggest we record a part of a conversation to bring up later so we don’t need to take notes. I just press the shortcut. I copy them on the email so they can do as they please, and I’m able to link them in my personal CRM so I can find it with no effort later on.

Have you used airtable integrations to save audio or other types of files from emails?

[itoldusoandso]

Have you have been able to Update an existing record instead of create a new record?

It’s an interesting approach but I think it’s worth exploring further so sorry for resurrecting this post if it’s too old to respond but nobody did, so I wanted to reply.

My idea is to create the record on Phone /iPad and later need to add more details. Updating a record on mobile device is inconvenient because:

1. Have to lookup the record first
2. Have t scroll down
3. Current mobile apps have an issue AirTable didn’t fix yet - the EDIT view of the record shows complete list of all available fields, which could be obnoxious to scroll through the whole list (I have 200 columns in one of my tables and all these 200 fields are showing up, instead of about 20 I have visible, the rest is supposed to be hidden).
4. Going from one record to the next takes time. In the EDIT view, swiping left takes me to “comments” section. That’s OK I guess, but I would have expected it to take me to the next record to edit … and so on…

So… I am playing with the idea to use email to do individual updates of the records. For example, my record includes an image, title, price and “item number”. Later I want to add “Description”. So I am thinking to use email where the subject of the email would read something like “AIRTABLE SKU 0001” , where 0001 is the item number. Zapier or Integromate or Automate.io (or IFTTT maybe) would take the email and put the content of the email body into the column “Description” based on the "item number 0001.

I believe same could be done with recorded Audio file.

I have already setup Google Cloud Speech API to process Audio file in Airtable (Wav and Flact only right now, but in future also mp3).

Since AirTable doesn’t allow recording voice into the record, using email would work nicely, but I needs to update existing record in my case.

Thanks for bringing up the email idea. I am going to try it later this year and provide an update (unless somebody else has it done already… please chip in).

[Jonathan_Letts1]

I like where your head is at on this. Transcribing text would be wonderful. You could set the subject like as something and run a “find” through zapier. I also could imagine that doing it though something on Miniextensions or through a bubble.io app would work.

[TonyMaden]

Hey guys, this was the only thread I could find on the forum related to my need to record an audio note or voce message directly into a record. The media add button has many options for links, but only one to create a photo via the interface itself. I’d like to see a voice message button added. My same ask in via this video. I need a way to give a link to a form to our field partners around the world so they can record their story behind the media asset they are uploading. If Airtable can not do this please share apps and no-code methods that can. Thanks and have a great weekend https://youtu.be/nBXwr81M-as

[Libby]

I like all these suggestions, but still can't nail a solution for my requirement, which is very much like Tony's. @TonyMaden did you come up with a solution for this?

[Hazza_Haz]

+1 would love the ability to directly capture voice note from Airtable form!

[scalingsymphony]

I was also searching for this, would be awesome if Airtable would integrate this. However I build a workaround with fillout.com. You can either create new record straight from the form of update a existing record. You can prefill information with url parameters, so you can create a formula link with information from your row, and enter it straight into the form with the audio input. Using it for content creation purposes now 🙂