Construct your first AppSheet app: how I constructed a meals tracker

Spread the love

Posted by Filipe Gracio, PhD – Buyer Engineer

Banner image that shows the Google Workspace logo

I maintain forgetting what I’ve within the freezer. At first I used Google Sheets to maintain observe of it, however I wished one thing that was straightforward to seek the advice of and replace on my smartphone. So I turned to AppSheet! Right here’s a tutorial to comply with to make an analogous monitoring resolution.

Creating the database

First I created a database that imported my information from the Sheet:

A cropped screen shot illustrating creating a database in AppSheet by importing data from sheets

After I chosen “Import from Sheets” and chosen the sheet I used to be cumbersomely sustaining, I get the preview of the brand new database:

A cropped screen shot illustrating creating a database in AppSheet by importing data from sheets

Creating the App

Then I can return and create an App:

A cropped screen shot illustrating creating an app

After I title it I can choose the database I simply created.

A cropped screen shot illustrating step 1 of selecting the database


A cropped screen shot illustrating step 2 of selecting the database

The App now begins getting created, after which I can begin customizing it!

Customizing the App:

I made a decision I wish to really add extra data to the App. For instance, I wish to categorize my gadgets, so I would like one other column. I can edit the info for this and I am going to add a column “Class”.

A cropped screen shot illustrating editing the data

After including the additional column, that is the end result:

A cropped screen shot showing the data with the new column added

That’s going to come in useful later for presentation and group!

Now let’s do some configuration about how the gadgets are introduced on the precise app. That’s within the UX part of the App builder. I wish to choose “Desk”, Group by “class” after which type alphabetically by “Merchandise”

A cropped screen shot showing The Pirmary views in the UX Section of the App builder

After tweaking a number of extra choices in UX “Model” and “Format Guidelines”, that is how my app is seems:

A screen shot of the app on a mobile device displaying with content from the original dataset

Utilizing the App – including and updating gadgets.

Now, I can see what I’ve within the freezer always. If I prepare dinner one thing and have a leftover, I can simply add it by clicking the + button. After that, I simply want so as to add within the information:

A screen shot illustrating the functionality of the app on a mobile device

And naturally, if I exploit one thing I can simply faucet on it to edit the quantity (or delete it).

Attempt it your self!

This small App is one thing I exploit each week now! It’s a lot simpler than my previous methodology, plus I discovered the right way to use AppSheet. And this was only a fairly easy use case – which solely touched the tip of the iceberg of AppSheet’s options. When you work for organizations which have data to share and set up, this know-how may very well be helpful for you.

Attempt it out for your self: you need to use the whole set of AppSheet options without charge whereas constructing one or many app prototypes. You may also invite as much as 10 take a look at customers without charge to make use of your apps and share suggestions.

Thanks to my colleague Florian Opitz, Buyer Engineer – Google Workspace + Safety , for his helpful edits and ideas.

Leave a Reply

Your email address will not be published. Required fields are marked *