Build a Service Ticket App - AppSheet Tutorial

[@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.

[@AppSheetTraining]

Thanks for the feedback, never have received feedback about us covering the Table/View Hyper Links (Breadcrumbs). Surprised, because that seems like a useful info for tutorials. We'll keep that in mind moving forward.

[@FredQI2012]

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,

[@AppSheetTraining]

Thats our extension we made 'AppSheet Toolbox, available on chrome web store! chrome.google.com/webstore/detail/appsheet-toolbox/hklmffdokpefcfabkmkpjnkoakehigjg

[@OscarFURIOUS]

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

[@AppSheetTraining]

No particular reason! Multiple ways to do the same thing!

[@findthetruth3021]

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.

[@AppSheetTraining]

How do you plan to distribute the application? Do you want to embed it in another website?

[@findthetruth3021]

@@AppSheetTraining I don't know, let's say I want to share it like a public link or as an app with them. I want my users reach to it without freely without any difficulty. Like sharing in SharePoint or anything that you think is easy for my users. Thanks a bunch. İf I am not clear I wil clarify more.

[@AppSheetTraining]

A better option would probably be Bubble.io for your chatbot.

[@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?

[@AppSheetTraining]

Here is the syntax for LINKTOFORM with your columns - LINKTOFORM("Medical History_Form", "Patient ID", [_THISROW].[MH-Patient ID]) . The main thing to remember is " " don't need to be added to the [ ] . Hope this helps!