The moment your business wants to do things a way that isn't SAP's way, you completely butcher everything though. See https://news.ycombinator.com/item?id=17541092
He got a somewhat wistful look in his eyes, and said (more to himself than to us) he wished he could go back and choose not to do that.
I'll never forget that. He was earning an insane amount of money, working super high-level at one of the largest IT firms in the country.
Edit: Mind you for job security and cash generating potential they are can be pretty good - years ago I knew of people on £3000 a day in the UK working on very niche financial systems - but you basically had to have a lot of domain knowledge (financial consolidation) and decent development skills.
But it's really ugly, messy, and you might have to implement 5 corner cases of what the german government has thought of to complicate the lives' of everyone in regards to capital gains taxes in combination with church taxes, in a year in which you got married but one of the two left the church the same year. Oh, and what if you also got a kid that year and moved cities? And during implementation there is another law passed to change stuff?
In other words: So out of the world that noone finds it interesting anymore :D
And then it just became too expensive for their clients to move away. (i hate that company)
but the marketplace for displacement in this space is still ripe, else we wouldnt be seeing startups like this.
I wouldn't use that as a source of inspiration, at least not on the "connectivity" end.
Emulating AirTable usability with a CRM focus would be a category killer if successful.
If you want pretty spreadsheets, cool. If you want to use this as a CMS or CRM, and it has to interface with an external tool, god rest your soul.
edit: a candid example, we were using it to track some payables for advertising campaigns. Marketing team (that likes airtable) was adding the invoice as a file field to the table. That file attachment is not added to any "email" or "external" sync features of airtable, making it impossible to add it programmatically to an accounting software or to a shared accounting drive. Using zapier doesn't fix it since it's just not the file or a link to it in any of the api calls, only a reference field. It also doesn't export when you do an export of the table. You have to manually go in and download the file from each record (in the ui) which makes putting it there vs dropping it into a shared drive pretty useless as far as time savings is concerned.
I love it for the same reason I love XL, which is that you can turn it on and it just works and normal people can use it. You can create a sheet that tracks something important to the business in 20 minutes, and you have built in slack notifications and cron-type job capability and the ability to call or be called via REST API and so on, plus easy to follow user management and row level commenting and so on all built in.
In the first 20 minutes.
Yeah there’s stuff it can’t do or is bad for. When you get to that stuff use another tool, and guess what you usually can use whatever you did in Airtable as a spec instead of trying to sort out what the business process actually needs in terms of fields and so on.
I absolutely love it. It’s been an incredibly helpful addition to what had been our previous stack of salesforce for CRM and our own rails app/site, and is just so much faster for creating internal business tools than either.
Getting records from a table is as straightforward as making an API call to: `/{baseId}/{tableId}`. For getting the actual ids, there's a metadata API. The docs are also quite comprehensive. I’m curious as to where you have run into issues?
They make it trivial to import/push data in but accessing it or pulling it out looks like an intentionally hindered dark design pattern (like egress on aws). I have resorted to writing extension scripts in their godforsaken nonstandard javascript framework to access and aggregate data before pushing it out. Accessing google sheets programmatically is a walk in the park, comparatively.
There should be a template library and a way to do a really high-level business model NODE style work flow and it pulls the templates needed to make that
A NODE TREE builder for a crm would be valuable, if it doesnt already exist - start with "departments" and then have children recommendations for each, such that Inventory is a Child of Receiving and all the requisite models/modules in such....
We use it for inventory, logistics, accounting, customer support, managing our partners (dealers), managing our suppliers... as well as sales.
I spent 2 years as a Salesforce developer, and still dabble in APEX from time to time.
All of that is context for what I'm about to say:
Salesforce is a nightmare to develop and maintain. The concept of a central system to run the whole business makes sense. But Salesforce has no focus, IMHO.
I like how simple and easy to use Twenty is. But what I'd love to see is something like AirTable. Yes, call it a CRM so that you have an instant use case. But make it easy to do custom development. Make sure there's a great API. Much like Wordpress, make it easy to know where I can safely extend the platform.
Do all of that, and I think you might have a winning product!