Automated Task Tracker App - AppSheet Tutorial for Beginners

A full AppSheet tutorial geared toward beginners where we build an Automated Task Tracker App. In this build we cover a variety of features of AppSheet. We will not be going into depth about most of those features during this build series, but by the end you should feel comfortable creating simple apps in AppSheet.
As you go through this path you will be able to follow along and build the app yourself, then you can customize the app and make it more personalized by changing or adding features.
Try this path here: appsheettraining.com/path_det...
- 0:00:00 Introduction
- 0:01:11 Data Introduction
- 0:01:38 Setting up data in a Google Sheet
- 0:05:53 Setting up tables in AppSheet
- 0:10:09 Setting up columns in AppSheet pt. 1
- 0:14:28 Setting up columns in AppSheet pt. 2
- 0:20:22 Data Outro
- 0:21:40 App Interface Introduction
- 0:22:42 UX: Primary View
- 0:32:56 UX: Brand
- 0:37:01 UX: Details
- 0:43:21 UX: Form
- 0:47:44 Behavior: Action
- 0:56:17 UX: Format Rules
- 1:02:50 Data: Slices
- 1:06:18 UX: Calendar View
- 1:11:23 UX: Calendar System Views
- 1:15:03 App Interface Outro
- 1:15:48 Automation Introduction
- 1:16:20 Automation tab and Bots walkthrough
- 1:20:14 Setting up an Event for a Bot
- 1:24:29 Creating a Process
- 1:26:45 Creating a Task
- 1:30:13 Outro
Link to Demo App: www.appsheet.com/Template/App...
Link to Spreadsheet: docs.google.com/spreadsheets/...
Find awesome content like this and much more at
www.AppSheetTraining.com
Schedule a call: bit.ly/45D1CVC
#appsheet #nocode

[@nilabja2974]

You taught every options in detail. Very very very nice. Thank you.

[@bmejia6327]

This has helped me so much !! thank you , sending blessings your way!

[@user-lp7xp9zj7b]

JASTIN ,Thank you so much from amazing detail, well done!

[@peraruor]

Thnak you so much for this video. I've seen other videos from AppSheet traning, but this is what I needed. It is easy to follow and you show what we need to know to get start with AppSheet. We need more videos like this. Thank you so much.

[@alijama3892]

the Best teacher of this topic i even seen. Thank you

[@josepadilla6080]

You are the best teacher. Thanks very much. This is a really good tutorial

[@gianemosquera1313]

Thank you for having the patience to explain each of the options detail by detail, sir.

[@AppSheetTraining]

Glad you enjoyed it! AppSheet is really powerful, and we love helping people get the most out of the tool.

[@jacqueshollands5630]

Brilliant. Thank you for the excellent tutorial.

[@AppSheetTraining]

You are welcome, Jacques! We have plenty more on our channel, and in-depth video training and Live Bootcamps on our website, AppSheetTraining.com

[@davosban4887]

Very helpful video. Thanks a lot. Built a whole office task management app with this.

[@AppSheetTraining]

Wow awesome!

[@codybowling3235]

Thank you, I appreciate this video so much!

[@nsikumoh]

Thanks so much. You are a great teacher.

[@blackwoodtechnology118]

Great Sir! Please I request to you make more videos on AppSheet because I really need apps sheet training sir. and you are the best teacher, thank you so much for making this video it helps me to make my first AppSheet app.

[@mpowers3311]

thank you ! clear explanation.

[@york-fabianraabe902]

Very nice! Thank you so much 🙂

[@stardust6457]

Thanks for your efforts

[@reddykota9539]

Nicely explained, thank you

[@mrq8608]

Excellent Video Thank you

[@eidodoos]

very good explaination and easy to understand compared to previous narrator

[@wajay2006]

Excellent Video !! Thank you.

[@AppSheetTraining]

You are welcome; glad you enjoyed it!

[@wajay2006]

@@AppSheetTraining Do you have any implementation methodology. How do you do discovery of applications. Fitment of use case for Appsheet. Specifications. Design Development Deployment Devops Security and Deployment. Apologies for my expectations.

[@AppSheetTraining]

Hi Ajay, I’d be happy to chat more about that. Send me an email - [e-mail]

[@galaxy4701]

Best video thank you

[@alr969]

Awesome!

[@jay4125]

BEFORE THIS VIDEO MY KNOWLEDGE OF APPSHEET WAS 2-3%, NOW ITS WAY MORE THAN 30% I CAN SAY... THANK YOU SIR FOR THIS WONDERFULL VIDEO

[@galib7486]

Excellent tutorial (y)

[@AppSheetTraining]

Thanks Abdullah!

[@ibrahimbek2804]

Thank you

[@atiaatia9677]

Thanks

[@taikuechuepheat1667]

this video is very good

[@user-bk1wj1qh7d]

Hello! Everything you talked about works! In addition to the notification bot. Set similar expressions, but for some reason not. Combined in different ways - mail from the column, manually indicated. The date format is correct. What other nuances can there be? Please advise me to read something on this topic?

[@3BoxCreation]

This video is very good. It is explained in a very clear way. Thank you for that. Can I know this? I want to make a monthly summary as an email at 12 midnight on the last day of each month. The task done throughout the month as a pdf. Divide complete and incomplete into two separate formats.

[@kailsati]

Fabulous 🤗

[@vvdd903]

Good teacher

[@AppSheetTraining]

Thank you! 😃

[@veerkaku9448]

Awesome

[@rajarshibasu2190]

Very well explained. Can you come up with a Construction app video so that we may track projects, create submittals, use approval work flow and export task notes to a pdf and email. Basic requirement Field Inspection and operation.

[@AppSheetTraining]

Great suggestion!! We have a production grade field inspection app video series here: appsheettraining.com/path_detail/build-an-inspection-app-with-appsheet We’re working on more companion apps for the project management portion of the workflow.

[@shianreon]

Thank you so much!!! I can receive the mail when I press the (RUN) button, but can't automatically receive the time I set, where should I check? thanks for your help.

[@Turtnle2]

Great tutorial, thanks. What I don't understand: How does a data entry get a unique ID when entered into the table and not into the app? I have existing data in a table which I want to convert to a app with appsheet, all these data is of course not displayed in the app when selecting ID column as a key (initially I did not have the ID column and appsheet used the rownumber). Do I have to fill in that column with an ID manually also when doing new entries via table?

[@blessedkanu16]

Hi, I think the Appsheet detects the header name "ID" and automatically sets the cells under the header ID with the =UNIQUEID() formula, same way it recognizes cells under "Due Date" headers as dates. You can put in random ids into your sheet, when users fill in data in the App, Appsheet automatically creates an ID too(I put in random letters and numbers as my ID in the sheet, then when I put in data in the app as a user, I found out Appsheet generated IDs for my new entries,no errors occurred)

[@gladyssanchez1626]

thanks for the explanation. you are very patient, but may you tell me where can i get this tutorial in spanish please.

[@Centrus668]

Wow, I have learned a lot of new things from your video, thank you. Can we use this to send it to google calendar

[@AppSheetTraining]

Yes for sure! You can use a URL initial value feature or connect google calendar as a data source.

[@Centrus668]

@@AppSheetTraining thank you for your reply, do you know of a tutorial that can help me to get data to google calendar. or a URL initial value feature.

[@AppSheetTraining]

Here is our webinar on this topic: kzbin.info_0uZjh9gJpQ?si=vY3P1TcBiZJECkx7. There are also some great AppSheet Templates on AppSheet's template page that have these features. Hope this helps!

[@Centrus668]

@@AppSheetTraining Thank you for the info, I believe it will help

[@Centrus668]

I did look at the video, it help me to get data to Google sheet, but I have one problem, and do not know if this is possible. One question, If I have in my task in column "Status" This words "wag" Klaar" "Gekansleer" and "Uitgestel, How can I get it to save to my google calendar, if I try it it gives error on this words, as Google have different words in in Status. I did try to change the words for Status in my app for google calendar, but it does not work..

[@shahsamiurrashid5894]

Hi! Very good day. Now I can build simple apps using appsheet following your youtube tutorials. These are very helpful. I am a University Lecturer. I have a lot of students. So how can my students use my developed app without logging in AppSheet. Is there any way, as the other apps we dont need to login to the database. I am urgently in need of this answer. I tried the ways, all of them require log in to the Appsheet. Thanks in advance for your kind help.

[@AppSheetTraining]

You could deploy the app as a Public app. That would allow anyone to use the app. If you need to restrict a users view to only showing their data, you have to require a login.

[@juanmartinrodriguez3337]

Hi! Is it possible to set a push notification based on a DateTime column inside the app. I want to send reminder notification to employees based on the task schedule. Summarizing i want to create a notification based on data and not in an event. Thanks in advance.

[@johannvalverde5757]

What is the formula if I have more than 2 status options. Thanks for the tutorial.

[@Skillsyncx]

Thank you very much for this tutorials. Please how do I create an app to mark attendance for different groups?

[@AppSheetTraining]

Hi @TheKwamebrand thanks for reaching out! Sign up for your Free Tech Talk here 👉 bit.ly/365IZQC and we can build out a personalize use case guide for your attendance app. Thanks!

[@Skillsyncx]

@@AppSheetTraining thank you

[@salesuae5549]

Is it possible to create an auto sliding multi page table views in appsheet ?

[@apippudinb7346]

when I try to run the bot manually it works, but when I try using a schedule it doesn't work. I set SE Asia Standard Time for the time zone, because I'm in Indonesia. Is it correct??

[@dheerajkumarchoudhary4973]

Incase I update my sheet from Google Sheets will the data gets reflected in the App i.e. data updating works both ways??

[@AppSheetTraining]

As long as you enter in data accepted by the data type and are willing to add primary and foreign keys to maintain the references. This isn't what we recommend because its too easy to make mistakes. But ultimately AppSheet should make the User Experience of editing inside a sheet obsolete.

[@chukwunonsoikeji3563]

can I implement payment gateway in an app on appsheet and also file uploads

[@AppSheetTraining]

Payment gateway: no File upload: yes

[@zahraaindonesia3077]

Please help me, when I try to run the bot manually it works, but when I try using a schedule it doesn't work. I set SE Asia Standard Time for the time zone, because I'm in Indonesia. Is it correct??

[@AppSheetTraining]

Do you have a run this if true condition that may be returning false?

[@nocheomongos4932]

Hello Sir..How can we add date in enum expression? Thanks

[@REDDYPENNABADI]

When it status completed task should not visible in detail view how todo that.

[@Arc3103]

Could you make a countdown to your task? Please make a tutorial about that

[@sethserrette8765]

This man rolled all his sentences lol

[@daniella_arg]

How did you come up with the “ID” I didn’t see how you were able to generate it..

[@AppSheetTraining]

Initial Value: UNIQUEID()

[@daniella_arg]

@@AppSheetTraining I saw that portion & entered it, but then it didn’t translate to my sheet in the “I’d column” 🧐 thank you for your reply. I might just do the on demand or boot camp app sheet offers!

[@AppSheetTraining]

Hi Daniella, if you send an email to [e-mail], we can setup a meeting to help you find the right training options for you :)

[@techhome920]

Can i assign multiple task at one time?

[@AppSheetTraining]

You can you will need to create an loop of actions see this blog here for more information: appsheettraining.com/article/solution-design-project-management-app

[@narensaran7138]

Which book is to learn App Scripts

[@suhailzleads]

demo app link not working?

[@traderabenssoadocristianod4639]

how to make a bot to repeat daily the tasks of the previous day? I'm Cristiano from Brasil

[@lucascreto7512]

I get this on firsty time, but now the condition only givs me ''True'', help me please, i am from brazil

[@vvdd903]

Is there an option to add photos?

[@AppSheetTraining]

Yes if you create a column with a data type of image you will be given the choices of "take a photo" or "choose an image from your gallery" when filling out a form.

[@vvdd903]

Thanks

[@davosban4887]

@@AppSheetTraining Please where do the uploaded images go to ? Is there a general place all images can be found ? Does the storage count up in your google storage ?

[@AppSheetTraining]

Hi Davos, images are stored in the root folder for your app in your Cloud Storage Provider. If you’re using Google, it will be likely be in this Drive folder path: My Drive > appsheet > data > “your app name” > images

[@davosban4887]

@@AppSheetTraining Thanks

[@aymanfathy8592]

O

[@ethicalhackerwhitehat]

set the speed at 1.5. Thank me later

[@desairishab]

Nicely explained, thank you

[@AppSheetTraining]

Glad you enjoyed it! Do you have any other topics you’d like us to cover?