AppSheet Training
AppSheet Training
  • Видео 315
  • Просмотров 2 233 168
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.
Просмотров: 477

Видео

User Based Logic Series 1: User Variable Automations
Просмотров 21821 день назад
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
Просмотров 5 тыс.5 месяцев назад
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
Просмотров 9095 месяцев назад
#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
Просмотров 8935 месяцев назад
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
Просмотров 9655 месяцев назад
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,3 тыс.5 месяцев назад
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,2 тыс.5 месяцев назад
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: ruclips.net/user/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
Просмотров 2666 месяцев назад
User Based Logic: Why not app logic properties in User Table
User Based Logic: Definition
Просмотров 1756 месяцев назад
User Based Logic: Definition
User Based Logic: User Table Overview and Dynamic Dashboards
Просмотров 4886 месяцев назад
User Based Logic: User Table Overview and Dynamic Dashboards
User Based Logic: Introduction
Просмотров 3206 месяцев назад
User Based Logic: Introduction
User Based Logic: Data Architecture Overview
Просмотров 1986 месяцев назад
User Based Logic: Data Architecture Overview
User Based Logic: Use Case Overview
Просмотров 2116 месяцев назад
User Based Logic: Use Case Overview
Innovative AppSheet Solutions for Business Workflow Challenges: Google Workspace's Superpower"
Просмотров 1,9 тыс.6 месяцев назад
Innovative AppSheet Solutions for Business Workflow Challenges: Google Workspace's Superpower"
Mastering Dynamic Data: A Comprehensive Guide
Просмотров 6917 месяцев назад
Mastering Dynamic Data: A Comprehensive Guide
Mastering AppSheet Expressions || Tutorial
Просмотров 15 тыс.7 месяцев назад
Mastering AppSheet Expressions || Tutorial
Scaling Apps with AppSheet | GDE Office Hours
Просмотров 1,1 тыс.8 месяцев назад
Scaling Apps with AppSheet | GDE Office Hours
AppSheet Slices Tutorial | Filter Data based on User, Role, Date-Time, and more
Просмотров 25 тыс.2 года назад
AppSheet Slices Tutorial | Filter Data based on User, Role, Date-Time, and more
Content Planner App built with AppSheet | Connecting Data Pt. 2
Просмотров 2,9 тыс.2 года назад
Content Planner App built with AppSheet | Connecting Data Pt. 2
Automation for Education Webinar | AppSheet Demo - Goal Tracker & Inventory App
Просмотров 2 тыс.2 года назад
Automation for Education Webinar | AppSheet Demo - Goal Tracker & Inventory App
Goal Tracker App | Use Case
Просмотров 2,7 тыс.2 года назад
Goal Tracker App | Use Case
Creator Spotlight | Rene Casaña's AppSheet App helped reunite families | Full Length
Просмотров 6442 года назад
Creator Spotlight | Rene Casaña's AppSheet App helped reunite families | Full Length
Rene's AppSheet App helped reunite families
Просмотров 4502 года назад
Rene's AppSheet App helped reunite families
AppSheet Development Process | Idea to Deployment Pt. 1
Просмотров 10 тыс.3 года назад
AppSheet Development Process | Idea to Deployment Pt. 1
MASTER LINKTOFORM() and Other Deep Links in AppSheet | Bootcamp Tutorial
Просмотров 20 тыс.3 года назад
MASTER LINKTOFORM() and Other Deep Links in AppSheet | Bootcamp Tutorial
AppSheet Apps Transformed Ryan's Company (Case Study Highlights)
Просмотров 2,5 тыс.3 года назад
AppSheet Apps Transformed Ryan's Company (Case Study Highlights)
AppSheet Pricing Explained! [2021]
Просмотров 25 тыс.3 года назад
AppSheet Pricing Explained! [2021]
Field Inspection App - AppSheet Tutorial for Beginners
Просмотров 42 тыс.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

Комментарии

  • @zerkorj
    @zerkorj 2 дня назад

    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 День назад

      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 9 дней назад

    From Colombia, thanks for this content!

  • @heribertogutierrez2640
    @heribertogutierrez2640 13 дней назад

    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 18 дней назад

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

  • @ZiyodullaUsmonov-wj2jb
    @ZiyodullaUsmonov-wj2jb 18 дней назад

    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 17 дней назад

      We have this video created earlier this year! ruclips.net/video/dkOQlFNJHJ0/видео.htmlsi=tgdJTJOhw1uMSXWe

  • @DustmanDiagnostics
    @DustmanDiagnostics 22 дня назад

    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 27 дней назад

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

  • @iiamroyyy
    @iiamroyyy Месяц назад

    Dude anyway you can help me convert my AppSheet into this

  • @tieanddye
    @tieanddye Месяц назад

    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 Месяц назад

    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_ Месяц назад

    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 Месяц назад

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

  • @DanielCamposGaldezMonteiro
    @DanielCamposGaldezMonteiro Месяц назад

    my menu just wont appear

  • @nizamoshman7898
    @nizamoshman7898 Месяц назад

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

  • @DustmanDiagnostics
    @DustmanDiagnostics Месяц назад

    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 Месяц назад

    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 25 дней назад

      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.

  • @JesusCuervo-t6c
    @JesusCuervo-t6c Месяц назад

    You deleted the demo app

  • @KemAve-c1e
    @KemAve-c1e Месяц назад

    Hi in the HTML long text format, is it possible to display child records in a table as well with looping (start, end tags)?

  • @vishalchain
    @vishalchain Месяц назад

    i have been learning from your videos n started making an app . now i got stuck cant see anything like that on ur video.i have put details of one person then i give same as above yes n no. when selecting yes i wana copy above details. any way to do that? 🤔 really need ur help 😊

  • @vp9209
    @vp9209 Месяц назад

    I recommend that the next training video has an example of what is being created and how it will be used by users because without it, it's difficult to understand the big picture.

  • @DavidGinzberg
    @DavidGinzberg Месяц назад

    Thank you! Great session!

  • @bajangsekacang
    @bajangsekacang Месяц назад

    nice.... I have long time waiting for...

  • @prof.Kakira
    @prof.Kakira Месяц назад

    Following from Rwanda, East Africa. Thanks for these helpful appSheet tutorials.

  • @brianmcdowell540
    @brianmcdowell540 Месяц назад

    This is really helpful, thank you!!🙏

  • @michaelbuss6539
    @michaelbuss6539 2 месяца назад

    You do not say what field I should attach the expression to (like a URL), or a special button. Neither do you then show a working example. It would be so awesome if you did! For instance, I have a view (list) of concerts. I have another view of ALL the concerts and repertoires(the songs). Starting at the Concerts view, I want to click on one concert and jump to a filtered view of repertoires that ONLY shows me the songs for the selected concert. For starters, I will make the concert title the location for my link... Let's go see if this works. Sound good?

  • @robertadjei1978
    @robertadjei1978 2 месяца назад

    Do you guys have an appsheet community I can join

  • @ashivns
    @ashivns 2 месяца назад

    Please suggest expression to filter parent record based on products in child record, from product column in filter dashboard. Products are added as line items in parent table.

  • @radjivcurial1170
    @radjivcurial1170 2 месяца назад

    Hey Camron, could you please provide the link of this app? I want to try to rebuild it.

  • @radjivcurial1170
    @radjivcurial1170 2 месяца назад

    Thank you! Could you possibly create a turorial for a app for the financial sector? For example, for small businesses or the billing department? That would be great.

  • @DustmanDiagnostics
    @DustmanDiagnostics 2 месяца назад

    Thanks Cameron. Didn't learn anything new yet, but was awesome watching how you built your CRM app. Too bad I missed the livestream. I'd like to share my app and get some input on possible improvements but the time it would take would be considerable. Great content as always.

  • @AppSheetTraining
    @AppSheetTraining 2 месяца назад

    Copy the app here: www.appsheet.com/template/appdef?quickStart=False&appId=1f177368-3613-4cf4-9a6b-f059a3e68276&appName=QREWCRMAug1-Template-672988#Manage.Author.TeamWork

  • @emmanuelg.adzaworlu6295
    @emmanuelg.adzaworlu6295 2 месяца назад

    Help me set-up a SQL database

  • @bounsanongvongphachanh823
    @bounsanongvongphachanh823 2 месяца назад

    What about limit 2500 row meaning in plans.

  • @MrSandipcpatel
    @MrSandipcpatel 2 месяца назад

    i have in sheet male 1 female 2 and Transgender 1 how can i sum this

  • @andirifan8034
    @andirifan8034 2 месяца назад

    make speed to 1.25, it helps for me

    • @AppSheetTraining
      @AppSheetTraining 2 месяца назад

      For sure! As a native English speaker I speed up tons of videos, but I want our videos to be as accessible as possible for AppSheet's non-native english speaking audiences.

  • @syedimranSC
    @syedimranSC 2 месяца назад

    The naming should be QR code Scanners rather than Barcode Scanners. Thanks.

  • @elliotdingus
    @elliotdingus 2 месяца назад

    Thanks a million for this tutorial. It took me a bit to get it working on my own app as the translation of some things wasn't quite as smooth as expected! Nevertheless, it's now working and I'd have never got to this point without this video -- thanks!!

    • @AppSheetTraining
      @AppSheetTraining 2 месяца назад

      Thanks for this comment, glad it's clicking now!

  • @minhxuanho3878
    @minhxuanho3878 2 месяца назад

    Hi, thanks for sharing great tips. I wonder if the duplicated User table is in sync with the original user table in case of any moditification is occured in the original table ?

    • @AppSheetTraining
      @AppSheetTraining 2 месяца назад

      Interesting thought, I'm not sure and honestly I'm not sure what my assumption would be either if it have to sync before pushing the changes from table to table or not. Might have to look into this next week, let me know if you beat me to it .

  • @perpusasbp
    @perpusasbp 2 месяца назад

    hey i want to scan ISBN of book. so when I scan that ISBN, the app would show the identity of the book. how to do that?

  • @patrickpuma
    @patrickpuma 2 месяца назад

    Brilliant. Thank you for this

  • @IndaloRobotics
    @IndaloRobotics 3 месяца назад

    It would have been beneficial to see what the link to the form does!

  • @steve293
    @steve293 3 месяца назад

    A true example of great visuals and horrible instructions that reflect only 1% of what the topic was supposed to cover 🙄

  • @CristianLopez-qd3qb
    @CristianLopez-qd3qb 3 месяца назад

    Thanks

  • @Cithulu1
    @Cithulu1 3 месяца назад

    Thanks!

  • @matenggroup3821
    @matenggroup3821 3 месяца назад

    Does need to pay subscription?? for push notification

  • @dgrolfe
    @dgrolfe 3 месяца назад

    This never shows the final result. Does the slice save in a new tab in the datasheet? Does this only affect a certain view? What is a slice used for? You've only shown that a slice is a filter, essentially, but you didn't show how it's used.

  • @TheSrinikaranam
    @TheSrinikaranam 3 месяца назад

    What is the syntax if there are multiple conditions. In your example, i want to select user_email when user_role is "Admin" and user_dept="Sales" (assume user_dept is another column).

    • @AppSheetTraining
      @AppSheetTraining 3 месяца назад

      You would nest an AND function inside of the second parameter of the SELECT function. In the AND function just separate your logical statements by a comma. Like: SELECT(Users[Emails], AND([user_role]=“Admin”,[user_dept]=“Sales”))

  • @pappy101
    @pappy101 4 месяца назад

    So i do power apps and a few other "low code" platforms for one of the worlds best known enterprises and i have to say the columns tab is nice...

  • @c-04-poojaavhad47
    @c-04-poojaavhad47 4 месяца назад

    How to add related inspection