Empowering citizen developers since 2016

https://chat.openai.com/g/g-ZG9TkPOrl-appster ___________________________________________________________ Appster GPT is your AppSheet copilot, here to help you build your apps efficiently - yet with all the power that the platform can provide. It's been refined to suggest the efficient build methodologies promoted by Matt from MultiTech Visions, and has access to a knowledge base of all the resources and tools available from MultiTech Visions. Whether you're just starting off and want to know what's the best build practices, or how to implement some of the base functionalities... or if you're an advanced user looking to integrate your own custom Ai into an app you're building - Appster is here to help. ___________________________________________________________ OpenAi has opened up the ability to create a customized version of ChatGPT; naturally as soon as I was granted access I immediately started working. I already have a system that integrates GPT4 into a RAG system to help my supporters with their AppSheet endeavors, called the Answer Portal, but this is hosted inside an AppSheet app - which does not allow for live streaming of answers. This newer interface will allow for a more streamlined UX and give you an immediate reply. The only downside is that now it's a conversation between you and Appster, I can no longer join in and help push Appster in the right direction. For that, you'll need to sign up for secure access to the Answer Portal, where you can gain access to the original Appster - where I am also in the loop, so when Appster get's off the rails, I can point it back in the right direction. - www.MultiTechVisions.com/answers #ChatGPT #AppSheet

In this tutorial, I'll guide you through an advanced yet incredibly useful feature of the AppSheet platform: using the API to create multiple child records with the aid of a START/END loop and a template table. - This technique will allow you to take a client side action loop you may have, and convert it to run server-side instead. This video makes use of a sample app of mine as a starting point; you can copy the app for free below (if you wish to play along at home). - https://www.appsheet.com//templates/Inspections-Checklists-Questionnaires-oh-my?appGuidString=2ff8a48c-3292-4a0f-bdc5-6eebf2209a59 KNOWLEDGE & TECHNIQUES INVOVLED: - START/END loop - [_thisrow-1] - Template Tables Table of Contents |---------------------------------------------------------------------------------------- 00:00 Start 01:30 Setting up the bot 02:56 API Body 05:30 The START loop 07:07 Dual-Context explanation 08:17 Setting the parent connection 09:50 Setting the specific item 11:09 Explaining the whole START/END loop 13:07 What you end up with ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Answer Portal // https://www.MultiTechVisions.com/answers // // Merch // https://multitech-merch.creator-spring.com/ // ///////////////////////////////////////////////////////////////////////// 📌 Stay Connected: Join our Answer Portal for personalized support and to access a wealth of AppSheet resources. Drop your questions and suggestions in the comments below! 🎯 Hit the Like Button if you find this tutorial helpful and Subscribe for more AppSheet tips and tricks! For more information about MultiTech Visions, visit www.MultiTechVisions.com #CitizenDeveloper #AppSheet

In this video I show how to take over the "Add" button for inline views with your own action and how you can restrict when child records are created; I was trying to answer the following: "Basically, I want to be add records to the child table only if the parent record has Active status, otherwise the “new” button should not appear." https://community.appsheet.com/t/we-need-the-ability-to-easily-hide-the-new-button-for-inline-views/10604 ----------------------------------------------------------------------------------------------------------------------------- Help support the channel, donate through the link below! https://streamlabs.com/multitechvisions ----------------------------------------------------------------------------------------------------------------------------- Starting App |--------------------------------- https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=245700e5-9061-4045-843f-7850b5eb439a Ending App |---------------------------------- https://www.appsheet.com/samples/An-app-that-demonstrates-how-to-control-when-child-records-are-created?appGuidString=e84d6be8-8fb8-4930-b968-aa1ac8d37b72 ----------| Table of Contents |---------- 2:51 - Starting from the Order Capture sample app 4:02 - LINKTOFORM() 8:27 - Minor updates to the sample app (for smoother/safer functionality) 11:45 - Restricting when child records can be created (via Action restriction) ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Schedule a 1-on-1 // https://calendly.com/multitechvisions/1-on-1 // // Patreon // https://www.Patreon.com/MultiTech // // Merch // https://multitech-merch.creator-spring.com/ // ///////////////////////////////////////////////////////////////////////// For more information about MultiTech Visions, visit www.MultiTechVisions.com #CitizenDeveloper #AppSheet