3 ms·
An on-prem clone of Airtable would be a much better replacement for 99% of software that is written in Excel VBA, but: - you have to buy it and justify the exp
by orthoxerox 3y ago
An on-prem clone of Airtable would be a much better replacement for 99% of software that is written in Excel VBA, but:
- you have to buy it and justify the expense, but your company already pays for Excel
- if it's FOSS, then your cybersecurity will want to scan it and demand you fix every single "critical" CVE, but they don't dare block the use of Excel
- you have to run it on a server, so you need to buy a server as well, but Excel runs on desktop machines and you probably already have a network share, too
- the server will probably be locked down tight and have no access to other servers, while Excel running on desktop machines has the level of access of the user running it
- the IT will try to lock down the server-side installation and grant you as little rights as possible (please submit an enhancement ticket if you need to change the data type of the column), but they can't tell you what you can't do in VBA
I'm not an SME, I work in IT myself, but the amount of self-inflicted hurdles in modern enterprises is staggering. I run a large team that develops ETL jobs, and I needed a database to cross-reference tickets vs jobs vs source systems vs releases vs subteams, because of course no existing system knows all this. Ended up running this in Excel with some Powershell scripts: one to scrape JIRA, another to scrape Airflow, the other to access the target database under my personal account and download the list of tables. Still easier that doing it by the book.