Build a Service Ticket App - AppSheet Tutorial

We build a Service Ticket Repair app with AppSheet that has dynamic control flow to multiple related Service Process Forms

- 0:00 Introduction
- 2:35 Related Data Tables in Google Sheets
- 5:25 Dynamic Ticket Status via Virtual Columns and complex IFS() Expression
- 8:45 Repair Process Control Flow via Deep Links and Action Buttons
- 28:30 Cross Table Action to Update Finish Date

Find awesome content like this and much more at

[robgevw]

Thanks for this. Wish you would have started at the beginning of App Creation (you had some things already set up) and remove your head bubble so we could see the breadcrumbs for View and Table at the bottom of the preview, as well as seeing where you clicked. Great that you shared the app so we can reverse engineer some things, but frustrating when we can't follow along exactly.

[FredQI]

This is an amazing tutorial. How do you have the adds on to have the color coded syntax when you put in formulas and the assistance panel on the righ side of the screen where you can choose view names etc? Thanks,

[OscarFURIOUS]

Hey! Just 1 question. Why count instead of isblank/isnotblank?

[findthetruth]

Can we great FQA chatbot using appsheet. For example, I have a bunch of HR questions and answers. When I write a question then the answer will pop up according to the question.

[Luxxyfr]

LINKTOFORM("Medical History_Form", "[Patient ID]", "[MH- Patient ID]"). I am using this code but somehow the Patient ID is still not been auto filled. Do you know what I am doing wrong?