Appify Your Business
Appify Your Business
  • 61
  • 296 993
Incrementing Order Numbers
In some situations, it is beneficial to have an auto-incrementing identifier, such as an order number that is unique for each order. This can be an easy way for customers to communicate their order information without letters, which are often misunderstood on a phone call. AppSheet handles most of the calculations client-side, which makes a simple max() + 1 calculation unreliable. The client will not be aware of other orders that are being created at that exact moment, so there is a chance of duplicate numbers. Therefore, in this situation, it is best to use an automation to generate a number. This ensures that the AppSheet server calculates the auto-incrementing value instead of the client, preventing duplicate numbers.
00:00 - Intro
02:32 - Creating the auto incrementing number
มุมมอง: 2 194

วีดีโอ

Create a masked pin entry form in AppSheet
มุมมอง 2K10 หลายเดือนก่อน
In this video, we will learn how to create a form that masks PIN number entry using AppSheet. This is useful in scenarios where you may want to add identification or additional security to shared devices that remain authenticated as a single AppSheet account. 00:00 - Intro 01:27 - Table columns 03:13 - Creating pin buttons 06:27 - Masking pin input 10:15 - Cleanup and presentation 13:18 - Rando...
Creating a filter pane in Dashboards
มุมมอง 2.8K10 หลายเดือนก่อน
AppSheet has a built-in system for users to filter results in a table-based view. However, this system is hidden by default behind the inverted pyramid icon for each view. In this video, I will show you how to create a filter pane that is immediately visible when a user arrives in a dashboard view. This has the added benefit that multiple views from different tables can be filtered from a singl...
Proper Month and Weekday Ordering
มุมมอง 1.5Kปีที่แล้ว
Ordering or grouping dates by month or weekday is not intuitive in AppSheet. Use this trick to allow sorting or grouping by the calendar order. The formula created in this video: switch( [Month No], 1, Jan, 2, Feb, 3, Mar, 4, Apr, 5, May, 6, Jun, 7, Jul, 8, Aug, 9, Sep, 10, Oct, 11, Nov, Dec ) 0:00 Intro 1:23 Starting the app 2:29 Get month number from date 3:34 Convert month number to month na...
Home Screens in AppSheet Part 2: Detail View
มุมมอง 8Kปีที่แล้ว
In a previous video I demonstrated how to create a home screen using a gallery view. In this video, I'll show you how to leverage a detail view and action icons to create a different type of home screen. View the app template: www.appsheet.com/templates/app?appGuidString=11568118-d7e5-4e79-9f31-17b119b081c7 00:00 - Intro 00:27 - Demo of End Solution 01:15 - The Data Structure! 02:51 - Creating ...
Establishing Many to Many Relationships in AppSheet
มุมมอง 7Kปีที่แล้ว
Creating a One to Many relationship in AppSheet is fairly straight forward in AppSheet. However if you need to create a Many to Many relationship between two tables there is no documented path. In this video, I try to outline a method that you can use to create Many to Many relationships between tables. App Template: www.appsheet.com/templates/app?appGuidString=05a79787-df15-4c42-896d-80ddd4d97...
Detail View Cards for Desktop UI
มุมมอง 2.1Kปีที่แล้ว
Learn how to create cards inside of a desktop detail view. This allows you to make better use of the screen size when apps are used in the desktop browser. Task Management App in 5 Mins: th-cam.com/video/S0gH_59e3q4/w-d-xo.html Better AppSheet Forms and Show Columns: th-cam.com/video/PjFYV7OwXvk/w-d-xo.html 00:00 - Intro 00:56 - 5 Min App Task Management App 01:20 - Switching to the New Editor ...
Better AppSheet Forms
มุมมอง 6Kปีที่แล้ว
Learn how to maximize your form layout in AppSheet. In this video, I cover how to add pages, sections, special descriptive headers for fields and even animated gifs to your forms. 00:00 - Intro 00:50 - Getting Started 01:56 - Setting Field Order 02:41 - Show Columns to Create Form Pages 05:26 - Form Instruction Text 07:57 - Tabs and Page Indicators 09:19 - Adding GIFs/Images/URLs and Videos 10:...
Quick Barcode or QR Code Scans in Succession with AppSheet
มุมมอง 9Kปีที่แล้ว
00:00 - Intro 00:15 - Example 00:34 - Building the App If you need the ability to rapidly scan barcode or QR codes in succession, this video will show you how to do it!
Apps Script Return Values and Parsing an API Response
มุมมอง 6Kปีที่แล้ว
00:00 - Intro 00:35 - Functional Demo 01:14 - Apps Script 03:55 - JSON Path Tool 07:33 - Setting up the AppSheet Automation/Bot 10:28 - Formula to Reference the Apps Script Output 12:08 - Testing the Automation Developers can now return values from an Apps Script directly to an AppSheet app. In this example, I outline how you can have an app user enter the name of a food ingredient and return a...
AppSheet + Data Studio
มุมมอง 12Kปีที่แล้ว
AppSheet Data Studio
Help with AppSheet Formula Complexity
มุมมอง 1.5Kปีที่แล้ว
Help with AppSheet Formula Complexity
Build an Audit History Log in an App
มุมมอง 2.7Kปีที่แล้ว
Build an Audit History Log in an App
Using REF_ROWS()
มุมมอง 6K2 ปีที่แล้ว
Using REF_ROWS()
Understanding AppSheet’s Confusing File and Image Storage Properties
มุมมอง 5K2 ปีที่แล้ว
Understanding AppSheet’s Confusing File and Image Storage Properties
Enum vs Enumlist Differences in AppSheet
มุมมอง 4.1K2 ปีที่แล้ว
Enum vs Enumlist Differences in AppSheet
Check it out! New Apps Script Functionality in AppSheet
มุมมอง 6K2 ปีที่แล้ว
Check it out! New Apps Script Functionality in AppSheet
Extract Text from Images
มุมมอง 1.9K2 ปีที่แล้ว
Extract Text from Images
Build a Crypto Portfolio Tracking App: Part 7 - Create Price Change Alerts!
มุมมอง 3662 ปีที่แล้ว
Build a Crypto Portfolio Tracking App: Part 7 - Create Price Change Alerts!
Lookup Data in Any Table - LOOKUP() in AppSheet
มุมมอง 8K2 ปีที่แล้ว
Lookup Data in Any Table - LOOKUP() in AppSheet
Make an Invoicing App
มุมมอง 15K2 ปีที่แล้ว
Make an Invoicing App
Home Screens in AppSheet Part 1: Use a Gallery View
มุมมอง 29K2 ปีที่แล้ว
Home Screens in AppSheet Part 1: Use a Gallery View
10 Essential AppSheet Functions
มุมมอง 3K2 ปีที่แล้ว
10 Essential AppSheet Functions
3 Tips & Tricks for AppSheet Actions
มุมมอง 7K2 ปีที่แล้ว
3 Tips & Tricks for AppSheet Actions
Basic Approval Workflows
มุมมอง 6K2 ปีที่แล้ว
Basic Approval Workflows
App Development Policies
มุมมอง 3502 ปีที่แล้ว
App Development Policies
Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"
มุมมอง 3162 ปีที่แล้ว
Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"
Scale Your AppSheet App to Millions!
มุมมอง 2.4K2 ปีที่แล้ว
Scale Your AppSheet App to Millions!
Build a Crypto Portfolio Tracking App: Part 5 - Automatic Price Updates!
มุมมอง 4852 ปีที่แล้ว
Build a Crypto Portfolio Tracking App: Part 5 - Automatic Price Updates!
Build a Crypto Portfolio Tracking App: Part 4 - APIs and importJSON()
มุมมอง 5282 ปีที่แล้ว
Build a Crypto Portfolio Tracking App: Part 4 - APIs and importJSON()

ความคิดเห็น

  • @dgrolfe
    @dgrolfe 7 วันที่ผ่านมา

    This is by far the best explanation and example I've found. Thank you very much!

  • @dgrolfe
    @dgrolfe 9 วันที่ผ่านมา

    Good explaination of how to setup a Slice. But how is it applied? Do we create a new view for it? Does it move the slice data to a different/new table? How do we access the sliced data, if we want to use it for other purposes...such as export it to another datasheet?

  • @AndyLuffman
    @AndyLuffman 18 วันที่ผ่านมา

    In order to have different filters for different users, I have added the UserEmail to filter table and using lookup in the filter form but this doesn't seem to be working, I think the updates are too slow. Has anyone any other ideas how this can be achieved. UPDATE : I have put the filter columns on the table that lists the users and lookup from there which works.

  • @sergiorafaelrodriguezchave5450
    @sergiorafaelrodriguezchave5450 19 วันที่ผ่านมา

    Hello, thank you for the video. I tried to use it in user settings to use a password but then we fill all the pins the numbers disappear so if the pwd is wrong the numbers disappear and cannot be entered again, any suggestion?

  • @infoguiahn
    @infoguiahn 24 วันที่ผ่านมา

    Excellent function, thanks, it took me a bit to get it to work, but I did it, I had to change some of the code

  • @fabiodias3439
    @fabiodias3439 24 วันที่ผ่านมา

    Sir.. this just made my day! could you please write a code for a list from a filtered table?

  • @AutomationWithSholz
    @AutomationWithSholz 25 วันที่ผ่านมา

    Awesome

  • @sarnas699
    @sarnas699 หลายเดือนก่อน

    sir not working for me. while click the button it showing blank page.

  • @hamzaather9387
    @hamzaather9387 หลายเดือนก่อน

    Thanks, would you like to connect with me ?

  • @SaeDang-qm6gn
    @SaeDang-qm6gn หลายเดือนก่อน

    What's the benefit of doing this instead of creating a separate table to represent the association?

  • @user-dy4cp4yw6g
    @user-dy4cp4yw6g หลายเดือนก่อน

    Relative reference list items not appearing in pdf

  • @natozeleo7579
    @natozeleo7579 หลายเดือนก่อน

    Can i save data to google sheet? If yes ...how?

  • @Samuelfloresbueno
    @Samuelfloresbueno หลายเดือนก่อน

    I need to build an app for 3 stores to be able to write procurement orders simultaneously, from the same catalog, but divided into different invoices, any ideas ?, I basically need to add the items from the catalog to the total invoice directly from the appsheet, right now I'm using a filter function on googlesheets to filter the values that has input a Qty, but i know there's a "add a new row to another table" in appsheet

  • @RobertGrissom-of6mf
    @RobertGrissom-of6mf หลายเดือนก่อน

    Hi, thanks for the informative video. I am updating that Main row, it shows the history inline but it only shows what i updated it to, it doesn't show the prior information? Also, it seems to create only one row for that item instead of multiple so it just updates that singular row

  • @berketezic289
    @berketezic289 หลายเดือนก่อน

    Thx for your helps,i have created 2 tables according to your video,Controls and Spare parts, I need to save quantity of spare parts that are used in the control.

  • @apsarshaik9407
    @apsarshaik9407 หลายเดือนก่อน

    Hi this great video and I got to learn something new today, I have tried to build similar stuff for my business, I face two problems, 1st one is everything is NEW in the change column. 2nd I'm not able to see inline history, please guide me if possible

  • @aliceviruenavazquez8719
    @aliceviruenavazquez8719 หลายเดือนก่อน

    Excelent video!! I am tryinf to this this exact same behaviour but based on existing labels. So the scan should be used to identify wich existing labels is getting its date updated to now(). Any advice? Thanks!

  • @neverlosehope117
    @neverlosehope117 2 หลายเดือนก่อน

    Hii,, how to allow duplicate value in key column ?

    • @khushalagrawal75
      @khushalagrawal75 2 หลายเดือนก่อน

      Not possible, make the one that is unique in your Row as Key 👍

    • @neverlosehope117
      @neverlosehope117 2 หลายเดือนก่อน

      @@khushalagrawal75 actually i want to make inventory count app for 100 stores so it is possible in app sheet??

    • @khushalagrawal75
      @khushalagrawal75 2 หลายเดือนก่อน

      @@neverlosehope117 Create a Id Column in data section and make it as key , yours case may work

  • @knzamy
    @knzamy 2 หลายเดือนก่อน

    thanks for idea

  • @frontlineroofingcompany2854
    @frontlineroofingcompany2854 2 หลายเดือนก่อน

    I appreciate this channel! Subscribed :)

  • @petermarcusk
    @petermarcusk 3 หลายเดือนก่อน

    This wasn't helpful sir 😂, how do we link views from home table to views in data table

    • @appify
      @appify 2 หลายเดือนก่อน

      Not sure I understand. A view is a view. This video shows you how to go from a home screen to another view. You need to create views connected to the data tables you want first.

  • @Randommomentsblr
    @Randommomentsblr 3 หลายเดือนก่อน

    Post doing all this, the ref values in child table are not reflecting correctly and it shows a random number/id instead of actual value. Example : I have vehicle number in parent table which i want this in parent table and im adding , vehicle number- IN-0099, but child table shows me vehicle number as 71eff8ec Kindly suggest what im i missing here

    • @appify
      @appify 3 หลายเดือนก่อน

      Is the column set to a list type?

    • @Randommomentsblr
      @Randommomentsblr 3 หลายเดือนก่อน

      @@appify There is no option as such

    • @Randommomentsblr
      @Randommomentsblr 2 หลายเดือนก่อน

      Any update?

  • @aiciplus2000
    @aiciplus2000 3 หลายเดือนก่อน

    good... it reopens but you still have to click scan, is there a way to auto save and open camera scan without clicking?

    • @user-eh6lo8us7p
      @user-eh6lo8us7p 3 หลายเดือนก่อน

      You should put your scan to the first collum in your database and then reset the sheet

    • @appify
      @appify 3 หลายเดือนก่อน

      The field also needs to be a required field too. Then it will auto open the scanner.

    • @user-eh6lo8us7p
      @user-eh6lo8us7p หลายเดือนก่อน

      @@appify you save my life, thank you so much

  • @ShopGoodOklahomaCity
    @ShopGoodOklahomaCity 3 หลายเดือนก่อน

    This is great! But I've noticed that if a row in one table is deleted, the reference to that record in the other table is duplicated rather than removed. Anyone know how to fix?

  • @RobHunter-bp7ww
    @RobHunter-bp7ww 3 หลายเดือนก่อน

    Thanks for the video. I've tried this but The Bot doesn't run the auto increment. If I put a task to send an email to me BEFORE the update row event - I get the email. If I put an event AFTER the update row event, I get no email. So it seems to be hanging on the update row event any thoughts?

    • @appify
      @appify 3 หลายเดือนก่อน

      If you go to the automation monitor under Manage it should tell you the error.

  • @gustavoomena
    @gustavoomena 3 หลายเดือนก่อน

    Excelente, thanks!!!

  • @deqkuanggl
    @deqkuanggl 4 หลายเดือนก่อน

    Hi So i have 2 colums 1st =date 2nd=duty teacher My question is if a student pick a certain date in 1st column ,how to automatically duty teacher can be showed in the 2nd column?

  • @user-vj7kj7ln3m
    @user-vj7kj7ln3m 4 หลายเดือนก่อน

    I have made well, but I need to add second Approver which mean the request created by employee and I will approve it and it will go to my manger for final approve

  • @innovatune_ai
    @innovatune_ai 4 หลายเดือนก่อน

    Thank you so much for your video and instruction. This helped me a lot for my use case. Blessings to you! I subscribed to your channel and will follow you.

  • @KGingeri
    @KGingeri 4 หลายเดือนก่อน

    Wow, great tutorial! You've answered a TON of questions I was running into with AppSheet. I just about abandoned it! Thanks. I'm going at it again. My need is a bit different in that I want to invoice from tasks and time spent for various clients. However, I think you've given me what I need to progress! Subscribed.🙂

  •  5 หลายเดือนก่อน

    What is a voice in your backround . İs it a hammer in a building area? Too noisy

  • @espeditodelgaudio6718
    @espeditodelgaudio6718 5 หลายเดือนก่อน

    It is necessary only one row in the tab Filter of google spreadsheet?

  • @MrDylan1031
    @MrDylan1031 5 หลายเดือนก่อน

    Can anyone help me answer this question? What if we want one of the buttons to navigate to a view within the app that isn't a primary navigation tab, and also uses data from an entirely different spreadsheet?

  • @user-vi5pd7ec6l
    @user-vi5pd7ec6l 5 หลายเดือนก่อน

    Tried recentrly, id didnt work

  • @user-pm8qy5xk2b
    @user-pm8qy5xk2b 5 หลายเดือนก่อน

    4:43

  • @user-pm8qy5xk2b
    @user-pm8qy5xk2b 5 หลายเดือนก่อน

    is there any template to start creating processes?

  • @user-pm8qy5xk2b
    @user-pm8qy5xk2b 5 หลายเดือนก่อน

    Is there any appsheet template to start creating processes?

  • @MBP2313
    @MBP2313 5 หลายเดือนก่อน

    What if you come from a filtered table?

  • @abhrajyotidas0704
    @abhrajyotidas0704 5 หลายเดือนก่อน

    Sir, this trick, this code... You have my respect🔥

  • @bernt6500
    @bernt6500 5 หลายเดือนก่อน

    Thanks for the video!!

  • @RolandoGarciaV
    @RolandoGarciaV 6 หลายเดือนก่อน

    Been searching for this for hours thanks

  • @Vjfgk
    @Vjfgk 6 หลายเดือนก่อน

    I finally got my dashboard to work thanks to this video. Your explanation is easy to follow and logical. Is it possible to modify the filter expression to be able to select multiple criteria within the same column? Let's say I like to filter low and medium, and exclude high within the same column?

  • @KemuelAvenido
    @KemuelAvenido 6 หลายเดือนก่อน

    Help, it's not working for me now. T.T

  • @rubyruby4270
    @rubyruby4270 6 หลายเดือนก่อน

    If I want to search for a row by scanning a character using OCR technology, what will be the steps?

  • @westsunvisa
    @westsunvisa 7 หลายเดือนก่อน

    How can I share my created app to other employee "User" and ADMIN2 which they can only see their data and me as an "ADMIN" can see my data and other users.

  • @Huynh-Tan-Quoc
    @Huynh-Tan-Quoc 7 หลายเดือนก่อน

    THANK YOU FOR THIS VIDEO

  • @vvdd903
    @vvdd903 7 หลายเดือนก่อน

    how would i extract a total price from a receipt. since receipt has multiples number but just need total price?

    • @appify
      @appify 7 หลายเดือนก่อน

      In this scenario you can assume the highest price is the total price. So max(Extractprices([Column])) something to that effect.

  • @leonardooliveira7582
    @leonardooliveira7582 7 หลายเดือนก่อน

    Wow, you saved my life! Thank you!

  • @danilodamian3627
    @danilodamian3627 7 หลายเดือนก่อน

    Hi what if we have 2 approvers, status "endorsed for final approval', "fully approved". With 2 dates for the dates of the 2 mentioned? My problem is when status is "fully approved" the date on "endorsed for final approval" gets erased. Whats the get around?

  • @Mukash
    @Mukash 7 หลายเดือนก่อน

    Excuse me, Can U help me? I tried to copy this app, but I'd met mistakes. How can I show it?