Apr 07, 2020 10:52 AM
I constructed a database in FileMaker Pro many years ago to hold information about the many recordings my band has made over the years. I’m looking for an alternative to this platform, and only just now learned of Airtable.
There are two features of FileMaker Pro that are used in this database, and I need to know whether Airtable has equivalent features.
The first is repeating fields. The record for each song we’ve recorded has a repeating field which lists “who plays what” on the song for all six members of our band.
The second feature in question is container fields. In this database, each record has a container field that links to a .wav recording of the song in question. Note that this uses FileMaker’s “store a reference to” feature. That is, the .wav file is not contained within the database; rather, this field links to the recording, which is stored on the hard drive, outside of the database.
Does Airtable have the capability of replicating these two features? Thanks in advance for all help!
Apr 07, 2020 11:39 PM
Welcome to the Airtable Community! I can answer your questions about FileMaker and Airtable.
Airtable does not have repeating fields. Repeating fields are pretty much an idiosyncracy of FileMaker that goes way, way back to the days before it was possible to have multiple linked (related) tables.
For Airtable users who might read this and have no idea, a “repeating field” in FileMaker is a single field that has multiple, um, pigeonholes. It’s often used for storing multiple phone numbers and stuff like that. Instead of creating Phone1 and Phone2 and Phone 3, you create one field called Phones and configure it to have three repetitions. When you search for a phone number, you can search in that field and the number will be found regardless of which rep it’s in, where if you searched in Phone1 for a number that was actually stored in Phone2, you wouldn’t find it.
Anyway, Airtable does not have them and doesn’t much need them. If you’re storing phone numbers (say) you can either
I’ve been developing in FileMaker almost 30 years (sigh) and am fully aware that repeating fields have other uses. I’m just using phones as an example.
If you’re planning to export your data from your FileMaker database into a new Airtable base, you’ll need to restructure it in FileMaker before you export the data. Feel free to contact me through a private message if you have a question about how to do that.
Airtable has something called “Attachment” fields. An attachment field is kinda sorta like a FileMaker container field, in that you can use it to store files like photos, word processing or spreadsheet documents, even movies or music clips.
I haven’t made a detailed comparison of the ways in which Airtable attachment fields differ from FileMaker container fields, but a couple things come to mind.
Make sense? Hope that helps.
Apr 09, 2020 12:36 PM
Hi William –
Thank you very much for your reply! It’s my good fortune that there is someone here with deep FileMaker experience. Me, I’m just a self-taught duffer in the program, though I go back all the way to the time when I first got FileMaker Pro 2 in a bundle with WriteNow ( ) and a couple of other long-forgotten Mac programs.
If you don’t mind a couple of follow-up questions:
As I indicated, the repeating field in my database has six “slots,” one for each of the members of the band and the instrument(s) he plays on a given song. If I understand correctly, you were saying that I could create a single “who plays what” text field in Airtable, but that it could contain multiple lines (I assume delineated with a Return). Correct?
If this is the case, I have a feeling that Exporting the data in my Repeating Field in a way that’s usable by Airtable might be problematical. I’m guessing this is where a PM to you would be warranted.
For an Airtable replacement for the container field that now allows me to store a reference to a .wav file so that it can play when clicked, you’re saying I would need an attachment field that would store the .wav file directly. Would I run into any storage limit issues in Airtable if I did it this way? Right now, there are nearly 330 distinct records in our database, each with an associated .wav file (they average probably 6-7MB each). And more will be added.
But I could also put a link in this field, as long as it leads to some kind of online source (e.g. Dropbox). I probably couldn’t link to a local storage device (e.g. hard drive or thumb drive), correct?
If we need to discuss this further, we probably should go the PM route rather than boring everyone else here! But I will appreciate any help you can give. Thanks again.
Apr 10, 2020 09:25 PM
I sent you a private message with a couple of suggestions. Good luck!