Airtable

Avantages

Interface utilisateur visuellement attrayante
Systèmes de suivi des tâches flexibles
Beaucoup de modèles de projets à choisir

Inconvénients

Potentiellement déroutant sans instructions
Autorisations utilisateur limitées
Interface Anglais seulement

Avantages

When a co-worker recommended Airtable, I was predictably skeptical. Who needs yet another spreadsheet software I said, with an internal (ok, maybe external) eye roll. But this is no mere spreadsheet platform. It is the only one you will ever need. Ever. Again. The functionality that make it worth it to switch from Excel or Google Sheets might seem insignificant when you look at them on a features list. Colored labels, grouping, filtering, view options, etc. But you have no idea what a big difference they make! Airtable makes it possible to put in all the data you have, but the key to its success is it lets you filter it down to only the essential information you need to see to make the decisions in front of you. It's the database that actually helps with decision-making. And the more I use it, the more uses I find for it!

Inconvénients

There are very few cons to Airtable. It's simple to use, and the potential is limitless. Once you start putting bases together, you just don't want to stop! One thing that is slightly non-intuitive is the relationship (or lack thereof) between different "tabs" of data. Read up on those before you go that route. You can also start getting out of hand pretty quickly with creating lots of different views, but nothing a little intentionality can't address. We trained our entire team on using Airtable for project management, and it's been the best decision we ever made.

Avantages

Airtable brings actual structure to our working environment. We use for a team of 15 to track tasks, projects, and even for lightweight documentation of work done or where stuff is. I really like the flexibility and the ability to create just about anything with it and still make the finished product look nice. The UI is what people first comment on when I invite them to our shared set of bases--either "it looks great" or "this is easy" or something like that. I especially love the integration with Zapier so that if you need to go outside an Airtable base, you probably won't have to do manual entry--it can sync with your other app.

Inconvénients

With the free version, you will hit the record limit will pretty easily. I wish they had a lower-priced plan that was above the free version, but below their much more expensive tiers.
A second huge miss is that there was really no way to do rich text. That severely limits the usefulness for using Airtable as any kind of repository for content or anything like that. Basically you convert everything to HTML markup and store it as plain text in Airtable, but like I said they have promised to fix this . . .

Avantages

1. I Like the point and click linking of info on one tab to info on the same or another tab
2. The controlled vocabulary function (selection of values)
3. one to one and one to many relationships handled seamlessly (multiple / single select)
4. Formulas are easy to use
5. Rolls up summarise linked data in the linked records
6. Count give a count of the # of linked records
7. Look up function carries information from the link records
8. You can embed whole files as an attachment direction linked to the record

Inconvénients

1. We have to pay $20/user/month to use the blocks. While it saves a lot of time, we only use a few blocks
2. Great for small teams but gets expensive for larger teams as cost is per user.

Avantages

When I first started to use Airtable, I came away deeply frustrated with it's usability. It's sometimes slow, straightly obtuse to use and has many "pending features" that would be extremely helpful for some of the simplest of tasks.

However, there came a time when I had to organise a league table for a tournament over the internet, and all of sudden, Airtable clicked.

What Airtable is good at is creating a database of entries for a specific use, so for example, making an internet registration form where a user can enter data and "register" their interest in a particular thing is so quick and easy to do.

I created an application form which auto stored the data into a highly organised table that I could then use however I wanted (I created a league table from the registered users with ease and shared the results of the league as the scoring progressed) - all via the internet, I don't know of a way that I could have achieved this without AirTable, Google Docs would have been a possible solution, but Airtable allows you to add attachments easily (so images, etc) as well as allowing you to manipulate (And hide) data in any way you can think of using Rollups and Lookups - two of it's most powerful features.

Once you get used to it, Airtable becomes useful, and I can see myself using it again and again when I want to organise a very specific and distributed task on the internet.

Inconvénients

Don't think this is Excel in a different disguise, it's not, it's not as adaptable and not as powerful as Excel. You couldn't use it to track a project or manage a holiday system or anything like that, but creating a full customer list for a newsletter? Yep, easy, that's the kind of thing it DOES do really well.

It could use a few more features on the free tier of the software (the paid tier unlocks "blocks" - which is a strange name for plugins, which allow you to view the data in different visual ways but ultimately it's not as well integrated as it should be and therefore has a limited use)

Another thing is that Airtables mobile interface is woeful compared to it's desktop version, and for some reason you can't access the desktop website via mobile. I have no idea what compelled them to make this decision but it's something they need to address in the future. The mobile layout is next to useless.