AppSheet Training
AppSheet Training
  • 315
  • 2 366 724
Improving App Performance: Virtual Column Optimization
Virtual Columns are awesome, but they can be costly to our app performance if we don’t implement them correctly. In this video we cover when to use virtual columns and how to re-architect them if they will be expensive for your app performance.
Переглядів: 1 048

Відео

User Based Logic Series 1: User Variable Automations
Переглядів 4474 місяці тому
In this video, we cover automating the creation of user variable records and dynamically setting values for our current user. This is critical for establishing user-based logic in AppSheet. Hope you guys enjoy!
Google's Hidden Superpower | VertexAI + AppSheet + AppsScript
Переглядів 9 тис.9 місяців тому
AppSheet, now FREE in Google Workspace, is an AI powered superhero that you need to help you automate your business systems. Join me as I walkthrough building an AI powered Inspection App for the Avengers with AppSheet, AppsScript, and Gemini. I'll also breakdown the 3 places you need to try this No Code App Development Platform in your business NOW! 🔗 Links Demo app and the AppsScript code: ww...
User Based Logic: The INPUT Feature
Переглядів 1,4 тис.9 місяців тому
#appsheet #automation #googledeveloper In this video Landan Quartemont (Google Developer Expert) walks through user based logic in this video on how to use the input feature. Join Landan during his Office Hours every Wednesday at 11:00 AM CT. 📋 Sign Up for Office Hours: bit.ly/3SKNjuE 🔗 ADDITIONAL LINKS: QREW Tech Home Page: bit.ly/3jDdu7p Learn More: bit.ly/3AzfjYJ Schedule a Call: bit.ly/45D1...
Generate Context Aware Data using AI in AppSheet || Planet Workspace Remix
Переглядів 1,1 тис.9 місяців тому
Join Camron as he explores a groundbreaking new app concept that analyzes inspector data and generates AI-powered stories based on your findings! This mind-blowing tech, called the Marvel Planet Inspector, brings the universe to life by weaving a narrative around your discoveries. This may be a fun use case, but can be applied to all sorts of real business use cases. Intro - 0:00 App Demo - 0:3...
NEW AppSheet Admin Console; a Big Step for AppSheet at Scale || Interviewing AppSheet Product Team
Переглядів 1,1 тис.9 місяців тому
In this video we had the amazing opportunity of Stefan interviewing Anthony from the AppSheet Product team at #GoogleNext24. In this video we cover the recent announcements of the brand new Admin Console and addition of new 'Org-wide' Governance Intro - 0:00 What is the Admin Console - 0:32 Who is this built for? - 1:40 Who gets access to the Admin Console? - 3:22 Does every Workspace get acces...
New AppSheet Features announced at Google Next 24 || Interviewing AppSheet Product Team
Переглядів 2,6 тис.9 місяців тому
In this video we had the amazing opportunity of Stefan interviewing Ann and Shirley from the AppSheet Product team at #GoogleNext24. In this video we cover the recent announcements of : - GCP Integration Connectors - Google Forms in AppSheet, Including Bot Triggers from Forms - AI assisted app creation within AppSheet - AI Data Extract for your app users - AppSheet's reasons for incorporating A...
AppSheet's Input Feature || Planet Workspace Remix
Переглядів 1,8 тис.9 місяців тому
In this clip Landan covers AppSheet's new Inut fature they've added replacing the original INPUT() Function. This is a clip from our Planet Workspace Webinar: ua-cam.com/users/liveJaxWmyu4fpU?si=fGzB_oxq25UHLNsZ Intro - 0:00 What does the Input feature do? - 1:25 Input Feature Live Demo - 4:55 Transfer data but not show the popup - 8:41 Input vs Action on Set of Rows - 9:40 Do you prefer the cu...
User Based Logic: Why not app logic properties in User Table
Переглядів 34210 місяців тому
User Based Logic: Why not app logic properties in User Table
User Based Logic: Definition
Переглядів 23010 місяців тому
User Based Logic: Definition
User Based Logic: User Table Overview and Dynamic Dashboards
Переглядів 77610 місяців тому
User Based Logic: User Table Overview and Dynamic Dashboards
User Based Logic: Introduction
Переглядів 41410 місяців тому
User Based Logic: Introduction
User Based Logic: Data Architecture Overview
Переглядів 26910 місяців тому
User Based Logic: Data Architecture Overview
User Based Logic: Use Case Overview
Переглядів 28710 місяців тому
User Based Logic: Use Case Overview
Innovative AppSheet Solutions for Business Workflow Challenges: Google Workspace's Superpower"
Переглядів 2 тис.10 місяців тому
Innovative AppSheet Solutions for Business Workflow Challenges: Google Workspace's Superpower"
Mastering Dynamic Data: A Comprehensive Guide
Переглядів 79511 місяців тому
Mastering Dynamic Data: A Comprehensive Guide
Mastering AppSheet Expressions || Tutorial
Переглядів 26 тис.11 місяців тому
Mastering AppSheet Expressions || Tutorial
Scaling Apps with AppSheet | GDE Office Hours
Переглядів 1,3 тис.Рік тому
Scaling Apps with AppSheet | GDE Office Hours
AppSheet Slices Tutorial | Filter Data based on User, Role, Date-Time, and more
Переглядів 27 тис.2 роки тому
AppSheet Slices Tutorial | Filter Data based on User, Role, Date-Time, and more
Content Planner App built with AppSheet | Connecting Data Pt. 2
Переглядів 3 тис.3 роки тому
Content Planner App built with AppSheet | Connecting Data Pt. 2
Automation for Education Webinar | AppSheet Demo - Goal Tracker & Inventory App
Переглядів 2,1 тис.3 роки тому
Automation for Education Webinar | AppSheet Demo - Goal Tracker & Inventory App
Goal Tracker App | Use Case
Переглядів 2,8 тис.3 роки тому
Goal Tracker App | Use Case
Creator Spotlight | Rene Casaña's AppSheet App helped reunite families | Full Length
Переглядів 6633 роки тому
Creator Spotlight | Rene Casaña's AppSheet App helped reunite families | Full Length
Rene's AppSheet App helped reunite families
Переглядів 4563 роки тому
Rene's AppSheet App helped reunite families
AppSheet Development Process | Idea to Deployment Pt. 1
Переглядів 11 тис.3 роки тому
AppSheet Development Process | Idea to Deployment Pt. 1
MASTER LINKTOFORM() and Other Deep Links in AppSheet | Bootcamp Tutorial
Переглядів 21 тис.3 роки тому
MASTER LINKTOFORM() and Other Deep Links in AppSheet | Bootcamp Tutorial
AppSheet Apps Transformed Ryan's Company (Case Study Highlights)
Переглядів 2,6 тис.3 роки тому
AppSheet Apps Transformed Ryan's Company (Case Study Highlights)
AppSheet Pricing Explained! [2021]
Переглядів 26 тис.3 роки тому
AppSheet Pricing Explained! [2021]
Field Inspection App - AppSheet Tutorial for Beginners
Переглядів 44 тис.3 роки тому
Field Inspection App - AppSheet Tutorial for Beginners
The Fastest Way to Learn AppSheet - Training Bootcamps
Переглядів 7 тис.3 роки тому
The Fastest Way to Learn AppSheet - Training Bootcamps

КОМЕНТАРІ

  • @FreshMootz
    @FreshMootz 2 дні тому

    This is interesting. I am creating strength training spreadsheet templates and they're a pain to view on a phone, which is what most of my athletes use. It is going to require tweaking but it looks much better to view it. Are there piracy settings that I can use to restrict access for those other than my athletes?

  • @romarioballoon7319
    @romarioballoon7319 10 днів тому

    So why you havent show us the results!?

  • @carlangaslongas
    @carlangaslongas 13 днів тому

    You guys rocks, this tutorial and copycat example is AWESOME, is there any other platform that we can buy another modified apps and be in touch if required? Edited, I just followed in all your social networks

  • @aiTranXuan126
    @aiTranXuan126 20 днів тому

    Great app, thanks!

  • @aminurrahman2246
    @aminurrahman2246 21 день тому

    How to add in icon (in out colum)

  • @mr.e7379
    @mr.e7379 27 днів тому

    Really um, like um.. Erhm. Umm and so um.

  • @mr.e7379
    @mr.e7379 27 днів тому

    Um...like. erhhm. Um

  • @safwan3282
    @safwan3282 27 днів тому

    Hello Sir Thank you for this video, I try to make a inventory and sales app for my business, but some problem to make in the PDF template. 1. I can't put serial number of products on sales invoice in the pdf template on Google doc. 2. Also I can't put header footer & page number in the all pages when input sales invoice many item at a time on PDF template. Also 3. Also can't put total amount in word. Sir kindly make a video for solution. I tried lots of videos to make on this.

  • @Booyah
    @Booyah Місяць тому

    My favorite tutorials are the ones where the teacher is just clicking on things and reading the text that is on the screen.

  • @MikkoAmores
    @MikkoAmores Місяць тому

    Could you give me an example for this, if its alright? Im quite dumb right now.

  • @mohdzamreeabdul3935
    @mohdzamreeabdul3935 Місяць тому

    Very good explanation. Many thanks, Bro !

  • @tennisblood
    @tennisblood Місяць тому

    Can AppSheet call a REST service

  • @ChiragGajjar-q3d
    @ChiragGajjar-q3d Місяць тому

    Can you help me guiding in building an app in appsheet ?

  • @Foydali_bro
    @Foydali_bro Місяць тому

    (Unable to add row to table '2'. → Object reference not set to an instance of an object) I have this error and my data is not transferred to google sheets, is there a solution for this?

  • @PascaleRaffaele
    @PascaleRaffaele 2 місяці тому

    Great video, thank you🎉

  • @HaydaraliAsrorov
    @HaydaraliAsrorov 2 місяці тому

    👏

  • @chidanandabilur5193
    @chidanandabilur5193 2 місяці тому

    column,so I not able to auto scanning for the same barcode. And I not to duplicate scanning is there any way to resolve it to bypass.

  • @unsuspicious_youtuber
    @unsuspicious_youtuber 2 місяці тому

    is it just me or is coding way easier

  • @ingfredfiifiarthur2858
    @ingfredfiifiarthur2858 2 місяці тому

    How do i create a two different pdf report one from the main table and another one from the slice table

  • @HaydaraliAsrorov
    @HaydaraliAsrorov 2 місяці тому

    👏

  • @AlberichRheinmann
    @AlberichRheinmann 2 місяці тому

    Beautiful words .... but only words. Only 1 big unsolved problem in appsheet. You cannot use pdf creation with header and footer in the pdf file. And i think ... in what kind of universe do they live ? and i could tell you many of them. After 1 year with appsheet i have learned a lot of them. Nocode maybe cool, but you reach instantly limits and you have to use appscript. and so on... and so on

  • @anandmallikarjunan7775
    @anandmallikarjunan7775 2 місяці тому

    Could you please send me the exact codes to send multiple records from Appsheet table to Whatsapp? Thanks.

  • @mudassar1
    @mudassar1 3 місяці тому

    4:15 - Dereference - mazeed in description

  • @reatcas
    @reatcas 3 місяці тому

    Thank you AppSheet team for this interview!

  • @danayu3428
    @danayu3428 3 місяці тому

    Building the app is easy, but designing the layout-I'm still trying to figure it out...

  • @ravipatelCTF
    @ravipatelCTF 3 місяці тому

    🤯 2nd mind blowing experience with AI. 1st was with ChatGPT. ❤❤❤❤❤ From India

  • @rizkyfebri6288
    @rizkyfebri6288 3 місяці тому

    thanks, really helpful

  • @GuidoADELFIO
    @GuidoADELFIO 3 місяці тому

    THANK YOU SO MUCH FOR THIS VIDEO AND ALL THE TIPS!

  • @spacefolder
    @spacefolder 3 місяці тому

    Video starts at 4:45

  • @moisesabraao6169
    @moisesabraao6169 3 місяці тому

    Olá boa tarde, estou buscando ajuda tem algum tempo. Eu tenho duas tabelas no google sheet. E tenho o appsheet um formulario que envia registro pra um das guias. Só que o colaborador perde algum tempo setando o nome dos colaboradores que eles tiram a produção. Gostaria de saber se é possível o campo do formulario ir sugerindo a sequencia dos usuário. Por exemplo, coletei a produção de jadson e mandei e lá já apareceria a joseana que a que vem depois de jadson. Eu já tenho uma guia de colaboradores, tentei algumas formulas atraves da IA mas foi frustrante, a formula deixa até sugerindo apenas o primeiro nome, mas depoois que envio ela não sugere a sequencia, que nesse caso seria a joseana

  • @erickmorgan11
    @erickmorgan11 3 місяці тому

    Its great.... How to create Header and Footer?

  • @corbypotyok1808
    @corbypotyok1808 3 місяці тому

    I have successfully implemented security and user permissions. I have an issue where some users can sign in with their google authentication and they can see what they have access to. Other users try to authenticate then get a 403 error, access denied. All of my settings are the same for all users at the moment and still no luck. Anyone have any suggestions? It is a Google Workspace domain environment in education.

  • @MartinDaniels-f1h
    @MartinDaniels-f1h 3 місяці тому

    Great analogy - thanks for for the content

  • @zerkorj
    @zerkorj 4 місяці тому

    Ngl I just watched your videos about expressions that was posted 5 years ago and I wasn't really understanding.This one is structured in a better way and I understand now

    • @AppSheetTraining
      @AppSheetTraining 4 місяці тому

      Haha glad to hear that over 5 more years of full time AppSheet Development we got better at explaining expressions! -Thanks, Cam

  • @EdwardIlemba
    @EdwardIlemba 4 місяці тому

    Malawi... :)

  • @cesartobar6564
    @cesartobar6564 4 місяці тому

    From Colombia, thanks for this content!

  • @heribertogutierrez2640
    @heribertogutierrez2640 4 місяці тому

    This is amazing, I'm considering purchasing all your content, just need a little more of guidance, I want to be able to upload an excel file, and then send the information from the file, to a google cloud function, that is going to process that file, (Answer the excel file questions), and then return the file to another location, or attach the report to an email, is this the same concept that you use here ?, where do I can find a tutorial explaining this, thanks in advance!, big fan

  • @Abdulwaheed-ge8pr
    @Abdulwaheed-ge8pr 4 місяці тому

    a.o.a how i use char(10) in concatenate function

  • @ZiyodullaUsmonov-wj2jb
    @ZiyodullaUsmonov-wj2jb 4 місяці тому

    Hi. It has been 5 years since that video was updated, I don't know whether you'll see this comment or not. But I am going to learn it from zero, but I can not understand. Can you help me find simple lessons

    • @AppSheetTraining
      @AppSheetTraining 4 місяці тому

      We have this video created earlier this year! ua-cam.com/video/dkOQlFNJHJ0/v-deo.htmlsi=tgdJTJOhw1uMSXWe

  • @DustmanDiagnostics
    @DustmanDiagnostics 4 місяці тому

    Thanks Landan for another AppSheet video. I try to take away as much as possible from any of AppSheet Training's videos whether they pertain to what I am working on or not. Never know when it may apply but in a different context. These tidbits of information have made my app what it is today. Even though it is structured around a single user, that user being myself, I still use dynamic expressions explicitly throughout the app just for my own UX and to break up the monotony of what I call "cookie cutter" apps. For example, changing the localization settings to something a little more humorous rather than your typical boring "cancel", "save", "back" options, I've included phrases like; "Forget about it", "Put in the memory warehouse", "Whoa, did you see an alien back there?" Just to liven it up a bit. My personal favorite is making display names dynamic. Having the display change based on criteria is amazing in my mind, down to pluralization based off a COUNT() function or a running total using a SUM() function and in some case both combined in a CONCATENATE() function ("&"if you prefer). You and Stefan have taught me so much in the past two years, for free mind you, I'm super appreciative of you and the entire QREW team. You deserve much more attention than it receives. Regardless, good job guys and gals!

  • @yashagarwal8189
    @yashagarwal8189 5 місяців тому

    How to scan multiple inventory IDs in the same row without moving to other row

  • @iiamroyyy
    @iiamroyyy 5 місяців тому

    Dude anyway you can help me convert my AppSheet into this

  • @tieanddye
    @tieanddye 5 місяців тому

    Hi. Watching from south africa. Thanks for your work. Been looking for how to build my own CRM and avoid paying so much for zoho etc.

  • @york-fabianraabe902
    @york-fabianraabe902 5 місяців тому

    Thank you for your video. It is very good to see where are the limitations. I personally was surprised how much more helpfull ChatGPT was for building my app in comparison to Gemini. But hopefully Gemini will improve over time.

  • @skykeeper_
    @skykeeper_ 5 місяців тому

    I make 300 column's in google sheet and because of that my App was getting slow to sync ...what should i do

  • @topblasted
    @topblasted 5 місяців тому

    The link you have provided is not working, Please provide a new link 🙏

  • @DanielCamposGaldezMonteiro
    @DanielCamposGaldezMonteiro 5 місяців тому

    my menu just wont appear

  • @nizamoshman7898
    @nizamoshman7898 5 місяців тому

    Thank you Sir...now my apps already usable.

  • @DustmanDiagnostics
    @DustmanDiagnostics 5 місяців тому

    Thanks Camron for the insightful part 2 of the CRM app build. I never thought of using a VC to use as an inline action placeholder, very creative workaround. I can sense your frustration doing these live streams because of the time crunch. I know just from watching how you perform that this CRM app could be worlds better given more time to clean up the small details and possibly think for a minute without the pressure of being live and remembering screen share, lol. In my app, most every visible column name has a dynamic display name, even if it's just to pluralize by using a COUNT() function. Like having one item displayed would say "1 installed item for $X.XX" or multiple items "3 installed items for a total of $X.XX" as the display name for an inline ref view inside a detail view. The flexibility of AppSheet is amazing, and with an imagination, so much can be accomplished. Learning how to use the functions is what takes the longest time. With no formal training and with only what I found on the AppSheet Training and Google Community websites I have learned from the best. Looking forward to part 3 of your app🦾

  • @usamaghaffar67
    @usamaghaffar67 5 місяців тому

    Is there any formula or expression for remember last value(text) in a text box remain same text after submit until we edit that again

    • @maheshkumarkushwaha2254
      @maheshkumarkushwaha2254 4 місяці тому

      PUT FORMAULA TO DETECT LAST VALUE TEXT BOX IN INTIAL VALUE BY MAX FORMULA FOR DATE TIME STAMP. THEN SELECT REQUIRED VALUE AGAINST THAT TIME STAMP.