Thoughts and ideas on how to build tools, automate workflows and speed-up the workplace.
Managing requests and approvals is a fundamental step within all kinds of business processes. In fact, almost any internal task is going to require some element of sign-off or vetting. The tricky thing is that this is often tightly aligned to very specific policies and procedures within a particular organization. In other words, the specific steps required to gain approval - and the logic underpinning these - will vary across different businesses and individual tasks.
Ronan McQuillan
Sep 19, 2023
Building a CRM is one of the most common custom software projects you’re likely to encounter. See, every customer-facing business needs a repeatable way to manage relationships with current, potential, and previous clients. The trouble is that the market here is so thoroughly cornered by a handful of big players - like SalesForce, Dynamics365, HubSpot, and others. This creates two potential problems. First, with such market dominance, these vendors can often present comparatively high recurring licenses.
Ronan McQuillan
Sep 5, 2023
Understanding the different methods of API authentication is a core competence for any would-be developer, data professional, or anyone else who wants to connect to external tools, data sources, or other resources. Nowadays, APIs are fundamental to the way we build, integrate, and use all kinds of digital tools - whether this is building custom software from scratch - or simply connecting existing SaaS platforms to create streamlined workflows. So, you need to know how to use the different authentication methods that vendors could implement for their APIs.
Ronan McQuillan
Jul 21, 2023
Keeping track of stock is one of the most fundamental processes in any customer-facing business. Today, we’re checking out how to build a custom inventory management app for free - in just 20 minutes. Even better, since we’re going to use Budibase to build it, you’ll barely need any coding skills - and we’ll have a fully functional application before your coffee gets cold. All we need to do is connect our data, add a couple of custom queries, and start using Budibase’s built-in components to create a professional UI for managing stock levels.
Ronan McQuillan
Jun 23, 2023
MySQL admin tools are some of the simplest applications around - but they can play a vital role in all kinds of daily workflows. The unfortunate reality is that the kinds of colleagues who are responsible for most admin tasks don’t have the technical expertise or time to sit around writing custom queries all day. Therefore, we often need custom solutions to bridge this gap. IT teams are tasked with outputting huge numbers of internal tools for managing data sets.
Ronan McQuillan
Jun 23, 2023
Moving data from Google Sheets to Postgres - or the DBMS of your choice - is one of the fundamental steps toward achieving modern, effective data management. See, huge numbers of teams rely on spreadsheets for use cases where they just aren’t really suitable. Obviously, spreadsheets are so dominant for a reason - there’s no disputing that they offer a huge degree of flexibility, power, and usability. But - when it comes to securely scaling data operations while maintaining accuracy, reliability, and interoperability, they leave a lot to be desired.
Ronan McQuillan
Jun 16, 2023
Nowadays, your workload management tool is at the center of your daily operations. In the age of remote, distributed teams, effective oversight and coordination is everything. And the market has responded. In fact, there are countless platforms out there trying to fill this niche. The only trouble is that every company has its own unique requirements and challenges. Therefore, COTS vendors typically cast the widest net possible - aiming to provide value for the largest number of buyers rather than fully meeting more individualized requirements.
Ronan McQuillan
Jun 2, 2023
Knowing how to build a dashboard is one of the core competencies for most knowledge-based jobs. Dashboards are the difference between raw data and clear, actionable insights. Most of us can pull up a couple of pie charts based on a spreadsheet - or even use a visualization platform like Looker to create basic reports. But what happens when your business data doesn’t fit neatly into one of these tools?
Ronan McQuillan
Apr 28, 2023