I want to build a “Send iMessage” button into my interface, but it doesn’t look like it’s going to work.
I have a {Phone} field, so generating a link to send an iMessage is easy enough with this formula:
IF(
{Phone},
SUBSTITUTE(
CONCATENATE("...
Hey everyone,
I’m an archery coach, and I’ve been using Airtable for a few years to manage information about the people who participate in our archery club and their achievements. I’m trying to figure out the best way to track the relationships among...
I’ve got a base I use to track my clients and the coaching sessions I have with them. Two tables: Clients and Sessions. The Sessions table has a link to the Clients table to display the client name.
The Clients table has various data about the client...
I’m using Zapier to create a new record in one of my bases. The Zapier web hook is sending a date and time that looks like “2017/05/12 7:07:51 PM”. I have a datetime field in my base that receives that data, but it gets converted as though the incom...
Starting yesterday, my Airtable Mac app (v. 1.0.0) starts, but doesn’t display anything. It’s just a big white canvas. I’ve reinstalled and have tried accessing it from multiple networks. I’m guessing that it’s not connecting to something properly. A...
You’ve got a many-to-many relationship there, so if you want to store anything in addition to the basic relationship, you’ll need to look at some kind of junction table. Check out Many-to-Many Relationships - Overview | Airtable Support for more deta...
One thing to keep in mind is how you will handle things when the tax rate invariably changes. You probably don’t want your historical records to change when that happens.
My best guess is something like the following:
Export all your tables from Airtable in CSV format.Massage all the CSV files in Excel to match up with the database schema of your new database.Use the standard import tools of your database to import th...
@Nathaniel_Granor, I see now what you did there. :grinning:
I don’t think I was sufficiently clear in my original post, so what you suggested didn’t quite work for me. The good news is that I was able to take what you suggested and make it work per...
