What does Airtable do well? Airtable is a great alternative to using a standard spreadsheet solution such as Excel or Google Sheets. It allows for way more visual customizations that can take your data to the next level. There are nice additional features such as the ability to create forms and viewing data in calendar or kanban views.
What does Airtable not do well? Nothing big comes to mind. Airtable offers all of the main features that you'd expect from a spreadsheet solution with a fresh, cool spin.
What do you wish you had known about Airtable before using? Wish I would have known about the form feature right away. It makes it easy to create custom forms that pull data directly into the Airtable base - and receive email notifications each time a new form is submitted.
Have you used a competitor to Airtable? If so, how does it compare? I use Google Sheets frequently. Airtable is definitely nicer to look at. We just use Google Suite at our agency so gSheets tends to be the go-to.