![Appify Your Business](/img/default-banner.jpg)
- Видео 62
- Просмотров 325 454
Appify Your Business
Добавлен 24 авг 2021
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...
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
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
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
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
Home Screens in AppSheet Part 1: Use a Gallery View
Просмотров 31 тыс.2 года назад
Home Screens in AppSheet Part 1: Use a Gallery View
3 Tips & Tricks for AppSheet Actions
Просмотров 8 тыс.2 года назад
3 Tips & Tricks for AppSheet Actions
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!
hey, looks like the template app have an error
Is there any formula for remember last value(text) in a text box remain same text after submit until we edit that again
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?
Great video. thanks
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??
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.
@appify How to show child records when user clicks on button in detailed view or dashboard view
You can make an action that goes to another view with an expression using linktofilteredview(). support.google.com/appsheet/answer/10107338?hl=en
great lesson from thailand
Wonderful tip but I have problem on iPhone Showing some character.
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!
Ah. Thanks!
how to delete duplicate colum i made two colum _RowNumber _RowNumber1 how to delete one
_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.
You have my respect! thank you very much😃
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
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.
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.
Great content from South Africa 🇿🇦
Great tutorial! How can I add the images route if already have a folder with subfolders? Could I edit directly in Google sheets?
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"
If a customer would want to buy more than one thing in an invoice how could this be made possible?
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
Thank you very much brother
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?
This is by far the best explanation and example I've found. Thank you very much!
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?
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.
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?
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
Sir.. this just made my day! could you please write a code for a list from a filtered table?
Awesome
sir not working for me. while click the button it showing blank page.
Thanks, would you like to connect with me ?
What's the benefit of doing this instead of creating a separate table to represent the association?
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.
Thanks for the response! That makes total sense considering it's a no-code platform
Relative reference list items not appearing in pdf
Can i save data to google sheet? If yes ...how?
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
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
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.
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
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!
Hii,, how to allow duplicate value in key column ?
Not possible, make the one that is unique in your Row as Key 👍
@@khushalagrawal75 actually i want to make inventory count app for 100 stores so it is possible in app sheet??
@@neverlosehope117 Create a Id Column in data section and make it as key , yours case may work
thanks for idea
I appreciate this channel! Subscribed :)
This wasn't helpful sir 😂, how do we link views from home table to views in data table
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.
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
Is the column set to a list type?
@@appify There is no option as such
Any update?
good... it reopens but you still have to click scan, is there a way to auto save and open camera scan without clicking?
You should put your scan to the first collum in your database and then reset the sheet
The field also needs to be a required field too. Then it will auto open the scanner.
@@appify you save my life, thank you so much
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?
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?
If you go to the automation monitor under Manage it should tell you the error.
Excelente, thanks!!!
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?
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
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.
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.🙂
What is a voice in your backround . İs it a hammer in a building area? Too noisy
It is necessary only one row in the tab Filter of google spreadsheet?
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?