PCG logo
Article

From Idea to App in 5 Minutes With Google AppSheet

A finished app in just a few minutes? No problem with the no-code platform Google AppSheet.

image-a3cf2b4e98c2

In this video, we'll show you how to set up a task tracking appExternal Link within five minutes, complete with a connection to another table and automation for sending dynamic emails.

Database

For the data table, we will use Google Sheets, with separate tabs for tasks and projects.

image-96df4e9fdfd3

With the Google Sheets completed, we can jump right into AppSheet via the Extensions -> AppSheet -> Create App tab.

Column Types

We arrive at the 'Tables' view and add the 'Task' tab in addition to the 'Task' table tab. Under Data -> Columns, we set up the attributes of each column field. After creating the app, only a few adjustments are needed. These include changing the Status field to 'Enum' and adding the available options.

image-4b7ded0f6d36

In the application we also assign the created task to a project, so that a relation from one table to another is created.

image-637f4bc3776c

Automation

In order for the task owner to be informed about the task assigned to him, we add a bot to automatically send an email as soon as a new entry is created. AppSheet does a lot of work for us here as well through the suggestion bar, where we just enter the keywords "Task", "created" and "email" and get the desired process pre-configured. We also select "Embedded app view" as the email type and the corresponding view "Task_Form", so that the recipient can adjust the record directly in the email.

image-52563fc7be90

Deployment

Now we are just three clicks away from deploying the application. Under "Not Deployed", on the top left of the developer console, we run the deployment check. Once it has run, we can deploy the app.

You can view and make a copy of the app at this linkExternal Link.

image-e9ace1ded9ec

Do you want to empower employees without programming skills from specialist departments to create their own apps? Contact us now.



Services Used

Continue Reading

Article
Google Cloud report uncovers: GenAI as a driver of growth and success

The study ‘The ROI of Generative AI’ by Google Cloud delivers impressive figures. Find out how organisations around the world benefit from GenAI.

Learn more
Article
Google Cloud Backup & DR: Ultimate protection for your critical data

Backup & Disaster Recovery in the Cloud: Why you should rely on Google Cloud.

Learn more
Article
Gemini for Google Workspace: Prompting Guide for Efficient Use of AI

Your cheat code for Gemini for Google Workspace: Get the most out of the AI features with our prompting guide.

Learn more
Article
Cloud Security
IDC study: 60% fewer security incidents using Google Chronicle

A new IDC study about Google Chronicle SecOps delivers impressive figures: 407% ROI & 60% fewer security incidents at companies worldwide.

Learn more
See all

Let's work together

United Kingdom
Arrow Down