You’ve probably heard the buzz around 'No-Code' recently (or maybe not). I’ve certainly mentioned it in plenty of my content, but… what the heck is No-Code, anyway?
And why should you, as an Oil & Gas professional, care?
Today, we’re diving into this growing trend to uncover how No-Code isn’t just for tech-savvy developers—it’s an incredibly useful tool that can transform the way you work, unlock new efficiencies, and even help you monetize your skills.
At its core, No-Code platforms allow anyone to build applications, workflows, or digital solutions without writing a single line of code.
Yep, you read that right. No more getting lost in the weeds of coding!
Our industry is being transformed by AI, automation, and digital tools.
Whether you’re a professional looking to increase productivity or a consultant seeking new ways to offer value to your clients, No-Code is a gateway to quicker, more efficient workflows.
With No-Code tools, you can automate repetitive tasks, build dashboards to visualize complex data, or even develop a product to sell through various platforms. That’s exactly what the CrowdField Store is for!
Why don’t we ask ChatGPT?
Prompt:
<Could you provide 5 examples of how subsurface professionals in the Oil & Gas industry can leverage No-Code tools to improve their workflows and productivity?>
Reply:
Systems, processes, and workflows that would typically cost tens of thousands to outsource to specialist developers can now be done by you, without any coding, for peanuts!
Let’s walk through a simple workflow to give you a glimpse of what you can accomplish with No-Code tools.
Here’s an example of the steps I want automated:
This type of workflow can be set up without writing any code, making your processes more efficient and streamlined.
Let’s keep it really simple so you can see how easily you can use everyday tools:
Production template - Google Forms
Sure, you might already know how to create an Excel form linked to an Excel file or a Google Form linked to a Google Sheet. But just for fun, and to showcase cross-platform integration capabilities, I want to do something different: create a Google Form and link it to an Excel database.
Head over to Google Forms and sign in to your Google account.
You can either choose a template or start a new form from scratch. From there, simply begin adding the questions you want the field operator to answer. The process is incredibly intuitive and user-friendly. For this example, I’ve kept it simple:
That’s it! You can check out the form for yourself here: link to form.
Production database - Excel
Now, let’s create our Excel spreadsheet, which will serve as the repository for all the operators’ entries.
The fields or columns in the Excel sheet are straightforward. The table should look like this:
The Connector - MAKE
MAKE (formerly Integromat) is the powerful automation tool that ties everything together. In the context of our workflow, it acts as the connector between Google Forms and Excel, ensuring that every form entry automatically updates your Excel database.
With MAKE, you can create seamless integrations between different platforms, eliminating manual data transfers and saving time.
How does it work?
In MAKE, you build "Scenarios" by dragging and dropping apps into a workflow. You then define the parameters for how the apps should interact—all without writing a single line of code. It’s a simple and intuitive way to automate tasks across different platforms.
This is what the Make interface look like:
In my scenario, I have three “Modules” that are connected and run in the following sequence:
If we click on any of these modules, we can see that our job, after establishing the necessary connections with the appropriate credentials (Microsoft, Google, etc.), is simply to map out the corresponding fields by clicking—for example, mapping the "Oil Prod" entry in the form to the corresponding ‘Oil Prod’ column in the Excel sheet.
In this GIF, notice how the “Google Form” module blinks when I’m searching for the corresponding field to map to the Excel sheet:
It might not make much sense at this point, but trust me—this process becomes very intuitive once you start exploring the tool. The key point I’m highlighting is that you can set this up without having to write any code!
Now, let’s watch on the screens, side by side, how this plays out once we submit an entry via the form.
I will hit the “PLAY” button to run the make scenario manually this time, but this can also be set on a schedule to run every 5 minutes, 15 minutes, once a day, or at any interval you prefer.
As you can see above, the MAKE scenario, once run, automatically sends the form data to the Excel database and then sends a notification email with the content we specified.
There you have it—a no-code workflow for updating production databases and sending email notifications from field entries.
Let’s set aside the obvious concerns about cloud data security or the fact that there are already reliable companies offering similar services. This is simply an example to showcase these tools in action.
From here, it’s all about connecting the dots and figuring out how you can apply these tools to your own specific use cases.
Explore a curated collection of valuable resources in our Store, both free and paid, all designed to help you upskill.
Alan Mourgues is a Petroleum Reservoir Engineering Consultant with 25 years of international experience. He is the founder of CrowdField — the go-to hub for Oil & Gas subsurface professionals to upskill, freelance, and monetize their expertise. CrowdField brings together a global community through: i) Freelance marketplace for niche talent and task-based solutions; ii) Digital Store & Vault of engineering tools, workflows, and resources; iii) AI Hub showcasing startups, workflows, and use cases; iv) Learning resources including webinars, blogs, and curated datasets. Alan’s mission is to empower professionals to turn knowledge into income and future-proof their careers as the energy transition unfolds.
