Appify Your Business
Appify Your Business
  • Видео 62
  • Просмотров 325 454
In-App Status Messages for Bots!
In this example I will walk you through the step-by-step process of building status messages to keep your users updated when automations are running in the background. Discover how to utilize certain AppSheet functions to create custom messages based on data, user actions, and app logic. Whether you want to display simple confirmation messages or complex progress indicators, this video will equip you with the knowledge to enhance your app's user experience.
00:00 - Start
00:37 - Getting started
01:25 - Recording bot success to data source
02:52 - Action buttons that display status updates!
04:07 - Using virtual show columns for status messages
06:50 - Adding color and icons with formatting rule...
Просмотров: 448

Видео

Incrementing Order Numbers
Просмотров 2,8 тыс.Год назад
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...
Create a masked pin entry form in AppSheet
Просмотров 2,5 тыс.Год назад
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
Просмотров 3,9 тыс.Год назад
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,6 тыс.Год назад
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
Просмотров 9 тыс.Год назад
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
Просмотров 8 тыс.Год назад
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,3 тыс.Год назад
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: ruclips.net/video/S0gH_59e3q4/видео.html Better AppSheet Forms and Show Columns: ruclips.net/video/PjFYV7OwXvk/видео.html 00:00 - Intro 00:56 - 5 Min App Task Management App 01:20 - Switching to the New Editor ...
Better AppSheet Forms
Просмотров 7 тыс.Год назад
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
Просмотров 11 тыс.Год назад
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
Просмотров 6 тыс.Год назад
Apps Script Return Values and Parsing an API Response
AppSheet + Data Studio
Просмотров 13 тыс.Год назад
AppSheet Data Studio
Help with AppSheet Formula Complexity
Просмотров 1,6 тыс.2 года назад
Help with AppSheet Formula Complexity
Build an Audit History Log in an App
Просмотров 3,1 тыс.2 года назад
Build an Audit History Log in an App
Using REF_ROWS()
Просмотров 7 тыс.2 года назад
Using REF_ROWS()
Understanding AppSheet’s Confusing File and Image Storage Properties
Просмотров 6 тыс.2 года назад
Understanding AppSheet’s Confusing File and Image Storage Properties
Enum vs Enumlist Differences in AppSheet
Просмотров 4,4 тыс.2 года назад
Enum vs Enumlist Differences in AppSheet
Check it out! New Apps Script Functionality in AppSheet
Просмотров 6 тыс.2 года назад
Check it out! New Apps Script Functionality in AppSheet
Extract Text from Images
Просмотров 2 тыс.2 года назад
Extract Text from Images
Build a Crypto Portfolio Tracking App: Part 7 - Create Price Change Alerts!
Просмотров 3842 года назад
Build a Crypto Portfolio Tracking App: Part 7 - Create Price Change Alerts!
Lookup Data in Any Table - LOOKUP() in AppSheet
Просмотров 9 тыс.2 года назад
Lookup Data in Any Table - LOOKUP() in AppSheet
Make an Invoicing App
Просмотров 16 тыс.2 года назад
Make an Invoicing App
Home Screens in AppSheet Part 1: Use a Gallery View
Просмотров 31 тыс.2 года назад
Home Screens in AppSheet Part 1: Use a Gallery View
10 Essential AppSheet Functions
Просмотров 3,1 тыс.2 года назад
10 Essential AppSheet Functions
3 Tips & Tricks for AppSheet Actions
Просмотров 8 тыс.2 года назад
3 Tips & Tricks for AppSheet Actions
Basic Approval Workflows
Просмотров 7 тыс.2 года назад
Basic Approval Workflows
App Development Policies
Просмотров 3692 года назад
App Development Policies
Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"
Просмотров 3272 года назад
Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"
Scale Your AppSheet App to Millions!
Просмотров 2,6 тыс.2 года назад
Scale Your AppSheet App to Millions!
Build a Crypto Portfolio Tracking App: Part 5 - Automatic Price Updates!
Просмотров 5042 года назад
Build a Crypto Portfolio Tracking App: Part 5 - Automatic Price Updates!

Комментарии

  • @interfazdigital5107
    @interfazdigital5107 5 дней назад

    hey, looks like the template app have an error

  • @usamaghaffar67
    @usamaghaffar67 6 дней назад

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

    • @appify
      @appify 3 дня назад

      Not sure I understand. Values persist until changed. Do you mean to remember the value that was last entered when creating a new item from form?

  • @MohdHusni-v7i
    @MohdHusni-v7i 9 дней назад

    Great video. thanks

  • @UnboxRacing
    @UnboxRacing 9 дней назад

    Great video. I wondering how to apply this to a ticket scanning app at an event. Tickets have a QR code, scan using app and update a “ticket used y/n” field to yes. Guess i need to just have a scan field and match it to the ticket ID, then set an action to update the used field??

    • @appify
      @appify 7 дней назад

      Yeah in this situation you have a scans table and a tickets table to track status. The scans table is where you have the form that scans a ticket and "On form save" you can use "execute an action on a set of rows to update the status of that ticket in the tickets table.

  • @BabuBabu-dt4ts
    @BabuBabu-dt4ts 15 дней назад

    @appify How to show child records when user clicks on button in detailed view or dashboard view

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

      You can make an action that goes to another view with an expression using linktofilteredview(). support.google.com/appsheet/answer/10107338?hl=en

  • @pooz78
    @pooz78 19 дней назад

    great lesson from thailand

  • @kadaverukadaverufamily2659
    @kadaverukadaverufamily2659 21 день назад

    Wonderful tip but I have problem on iPhone Showing some character.

  • @BenBeattieHLA
    @BenBeattieHLA 28 дней назад

    Hello! I don't normally comment on videos. But I've watched a lot of yours to get started on Appsheet and they've been really helpful. So, a small token in return for you... When you create a virtual show column, if you let the App formula (ie the "") propagate so you get the green tick below, then you get all the virtual column options displaying. That means you can select Show as the type without having to go back into the table and edit it. Hope that helps you!

    • @appify
      @appify 27 дней назад

      Ah. Thanks!

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

    how to delete duplicate colum i made two colum _RowNumber _RowNumber1 how to delete one

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

      _RowNumber is a built in automatic column that is based on the order of the rows. You cannot change that. If you create another column called _rownumber then you will get _rownumber1. Recommend you change the name to Row ID or something like that do avoid confusion.

  • @user-lu2dc2sl5l
    @user-lu2dc2sl5l Месяц назад

    You have my respect! thank you very much😃

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

    Community plugin error for using data links There is an error caused by a community plugin for using data links. Please report the issue to the plugin provider if the issue persists. Community plugin details for using data links Fetching data from AppSheet failed. Error code: 6880b88e Help me please

  • @Ram-r7n
    @Ram-r7n Месяц назад

    How do you manage if there are 2 or more concurrent users in the app ? expression would return all the users same max() +1 value.

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

      The underlying reason as to why this method works is that all automations are run by the server in series. No automation is processed in parallel. As a result if there are concurrent users the server processes max()+1 as it receives the requests. This is why you would never want to use something like max()+1 in just an action itself. Actions are processed on the client (user side). As a result you would get what you described where max()+1 result could be the same value if multiple people are using the app at the same time.

  • @user-xj8vf2gf3n
    @user-xj8vf2gf3n Месяц назад

    Great content from South Africa 🇿🇦

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

    Great tutorial! How can I add the images route if already have a folder with subfolders? Could I edit directly in Google sheets?

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

      Yes. You just need to make sure the path is below the default folder. The limitation with using Google drive path in AppSheet is that all paths must start from the default folder path. This is based on the location of the spreadsheet in "My Drive"

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

    If a customer would want to buy more than one thing in an invoice how could this be made possible?

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

      You can use the transactions table for this as well. I didn't cover this in the video but, when you setup a REF type column there is the option to set "is a part of". This will add the function of allowing you to add multiple items when creating a new invoice. Check out the bottom part of this help article. support.google.com/appsheet/answer/10106510?hl=en

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

    Thank you very much brother

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

    Hello. First of all, congratulations on your videos. They are very useful to me. I have a question about the linkapp. Is there any way for the link to go to the specific view in the app?

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

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

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

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

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

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

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

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

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

    Awesome

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

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

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

    Thanks, would you like to connect with me ?

  • @SaeDang-qm6gn
    @SaeDang-qm6gn 3 месяца назад

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

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

      You can select all of the communities at once through the forms enum list, rather than including each person individually. This didn’t seem like a big thing to me - and probably not you either - but explaining to to end-users is hard. They didn’t understand why they had to keep individually adding the people.

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

      Thanks for the response! That makes total sense considering it's a no-code platform

  • @user-dy4cp4yw6g
    @user-dy4cp4yw6g 3 месяца назад

    Relative reference list items not appearing in pdf

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    thanks for idea

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

    I appreciate this channel! Subscribed :)

  • @petermarcusk
    @petermarcusk 5 месяцев назад

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

    • @appify
      @appify 5 месяцев назад

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

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

      Is the column set to a list type?

    • @Randommomentsblr
      @Randommomentsblr 5 месяцев назад

      @@appify There is no option as such

    • @Randommomentsblr
      @Randommomentsblr 5 месяцев назад

      Any update?

  • @aiciplus2000
    @aiciplus2000 5 месяцев назад

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

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

    • @appify
      @appify 5 месяцев назад

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

    • @user-eh6lo8us7p
      @user-eh6lo8us7p 3 месяца назад

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

  • @ShopGoodOklahomaCity
    @ShopGoodOklahomaCity 5 месяцев назад

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

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

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

  • @gustavoomena
    @gustavoomena 6 месяцев назад

    Excelente, thanks!!!

  • @deqkuanggl
    @deqkuanggl 6 месяцев назад

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

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

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

    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.🙂

  •  7 месяцев назад

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

  • @espeditodelgaudio6718
    @espeditodelgaudio6718 7 месяцев назад

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

  • @MrDylan1031
    @MrDylan1031 7 месяцев назад

    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?