- Видео 121
- Просмотров 873 176
Aris Azhar
Малайзия
Добавлен 21 авг 2022
Hi, I'm Aris, a bonafide tech enthusiast who's always on the hunt for the latest innovations and gadgets that the tech world has to offer. Through this channel, I share my passion for technology with you, offering reviews, tutorials, and in-depth explorations of cutting-edge devices and software.
So, whether you're a tech newbie, a seasoned pro, or somewhere in between, there's something here for you. If you're as passionate about tech as I am, or simply want to learn more about the tech world in an engaging and uncomplicated way, join me on this journey. Click that subscribe button, turn on the notifications, and let's explore the future, one gadget at a time!
Welcome aboard, fellow tech enthusiasts! Your journey towards tech-savviness and efficiency begins here.
So, whether you're a tech newbie, a seasoned pro, or somewhere in between, there's something here for you. If you're as passionate about tech as I am, or simply want to learn more about the tech world in an engaging and uncomplicated way, join me on this journey. Click that subscribe button, turn on the notifications, and let's explore the future, one gadget at a time!
Welcome aboard, fellow tech enthusiasts! Your journey towards tech-savviness and efficiency begins here.
How to Generate Sales Receipts in PDF with AppSheet | Step-by-Step Tutorial with PDF Fix!
In this tutorial, we walk through how to create an AppSheet app that generates a professional sales receipt in PDF format for multiple items under the same order.
You'll learn how to set up sample data, use expressions for calculations, and automate PDF generation using AppSheet’s Automation feature. Perfect for businesses looking to streamline invoicing. Watch till the end for advanced tips and best practices to ensure smooth implementation!
Join this channel to get access to perks:
ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin
You'll learn how to set up sample data, use expressions for calculations, and automate PDF generation using AppSheet’s Automation feature. Perfect for businesses looking to streamline invoicing. Watch till the end for advanced tips and best practices to ensure smooth implementation!
Join this channel to get access to perks:
ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin
Просмотров: 1 615
Видео
Looker Studio Tutorial for Beginners: What It Is & How to Get Started
Просмотров 796День назад
Welcome to the first episode of my Looker Studio tutorial series! 🎉 In this video, i’ll introduce you to Looker Studio (formerly Google Data Studio) - a powerful tool for creating stunning reports and dashboards from your data. Whether you're new to data visualization or just getting started with Looker Studio, this video is for you. By the end of this tutorial, you’ll have a solid foundation t...
Appsheet Episode 98: Separate Menu items based on user roles for you App. It's that easy!
Просмотров 1,8 тыс.14 дней назад
Join this channel to get access to perks: ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin In this AppSheet tutorial, you'll learn how to create a custom menu that dynamically adjusts based on user roles and gravity scores. By using the LOOKUP function and leveraging Gravity (a weighted number for roles and menu items), you can control which menu options appear for users with different access l...
Appsheet Episode 97: Basic understanding of labels for a better experience. Simple Steps!
Просмотров 89114 дней назад
Join this channel to get access to perks: ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin In this video, i’ll show you how to easily display images within your tables in AppSheet! Whether you're creating an inventory app, a project management tool, or any application that involves images, learn how to incorporate image columns to visually enhance your data. #AppSheet #AppSheetTutorial #AppShee...
Appsheet Episode 96: How to create custom running number with prefix. Simple steps!
Просмотров 81921 день назад
Join this channel to get access to perks: ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin In this tutorial, you will learn how to create a custom document numbering system in AppSheet that resets every month. This setup is ideal for generating document numbers in the format KKM/YYYY/MM/1, where the number automatically resets to 1 at the start of a new month. Follow along as we cover: Creating...
Appsheet Episode 95: How to calculate distance between two points. FREE Method!
Просмотров 3,4 тыс.2 месяца назад
Welcome to my tutorial on calculating the distance between two addresses in Google Sheets using the OpenRouteService API! In this step-by-step guide, i'll show you how to: 1)Set up your Google Sheets with addresses. 2)Use Google Apps Script to call the OpenRouteService API. SCRIPT: arisazhar.com/how-to-calculate-distance-between-two-points-free-method/ API: openrouteservice.org/ Join this chann...
Appsheet Episode 94: How to Create Dynamic Enum for Available Time Slots. Simple Steps!
Просмотров 2,5 тыс.2 месяца назад
In this tutorial, I'll walk you through creating a dynamic enum in AppSheet to display available time slots based on a selected date. This ensures that users can only select time slots that are not already booked. Don't forget to like, share, and subscribe for more AppSheet tutorials! Join this channel to get access to perks: ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin
Appsheet Episode 93: How to disable previous dates in data entry. Simple Steps!
Просмотров 1,1 тыс.2 месяца назад
Welcome to my AppSheet tutorial! In this video, i'll show you how to set up a validation rule in AppSheet that prevents users from entering dates before today. I'll also guide you on how to add a custom error message to help users understand the validation rule. What You’ll Learn: 1)Navigate to the Data tab in AppSheet. 2)Select the table and date column you want to validate. 3)Enter the Valid_...
Appsheet Episode 92: How to do Grid Pricing Calculation. EASY STEPS!
Просмотров 3,8 тыс.4 месяца назад
Welcome to my detailed tutorial on implementing grid pricing in AppSheet! In this video, i'll guide you through the process of setting up a dynamic pricing grid within your AppSheet application, perfect for businesses that require flexible pricing structures based on different dimensions like drop and width. Learn how to structure your data tables, integrate dropdown selections for product vari...
Appsheet Epsiode 91: Edit & Delete Records with Super Admin Approval. SIMPLE TUTORIAL!
Просмотров 2 тыс.4 месяца назад
In this video, i'll show you step-by-step how to set up your app so users can edit and delete records only until they have been approved by a super admin. Once approved, these records will be restricted from further editing and deletion, ensuring data integrity and adherence to your workflow requirements. Learn how to use column constraints, and actions effectively to manage user permissions an...
Appsheet Episode 90: How to Calculate Planned & Consumed Days (Simple Steps!)
Просмотров 2,5 тыс.5 месяцев назад
In this tutorial, we explore how to effectively calculate 'Planned' and 'Consumed' days using AppSheet. Starting with a comprehensive breakdown, we discuss the setup of a virtual column to dynamically determine the 'Planned' days based on future dates and 'Consumed' days for periods that have already started or are currently active. I'll guide you through each step, from configuring your Google...
Appsheet Episode 89: How to Create a Countdown Timer with hours and minutes. (Fastest Way!)
Просмотров 2,1 тыс.5 месяцев назад
In this video tutorial, we’ll dive into creating a dynamic countdown timer in AppSheet. Learn how to use expressions to calculate the time remaining until a specified target date and time. Whether you're managing event deadlines or project timelines, this tutorial will guide you through each step of setting up a reliable countdown display in your AppSheet applications. We'll start by examining ...
How to Send Automated Birthday Emails (The Easy Way!)
Просмотров 8186 месяцев назад
Learn how to send automatic birthday email in just a few simple steps with our automated birthday emails guide. Join this channel to get access to perks: ruclips.net/channel/UChBCB5V1jKzMK40139idOmgjoin
Appsheet Episode 88: How to search between multiple tables (Easiest way!)
Просмотров 5 тыс.6 месяцев назад
In this comprehensive tutorial, we dive deep into the powerful feature of AppSheet that allows users to search across multiple tables from a single view. Whether you're managing a complex database or simply aiming to enhance your app's user experience, this video is your go-to guide for implementing and optimizing multi-table search functionalities in AppSheet. We start by introducing the conce...
Mastering Google Apps Script: Holiday Calendar Automation in Google Sheets
Просмотров 7086 месяцев назад
Welcome to this Google Apps Script tutorial where I'll guide you step by step on how to create a custom Google Sheets extension to automate the process of adding public holidays based on the country and year of your choice. This script utilizes the Calendarific API to fetch holiday data, allowing you to dynamically update your spreadsheet with the latest holiday information. By the end of this ...
Appsheet Episode 87: How to Create User-Specific Dropdown Options in AppSheet Using Expressions
Просмотров 3,7 тыс.6 месяцев назад
Appsheet Episode 87: How to Create User-Specific Dropdown Options in AppSheet Using Expressions
Appsheet Episode 86: Connect Your AppSheet to a MySQL Database - A Step-by-Step Guide
Просмотров 4,6 тыс.7 месяцев назад
Appsheet Episode 86: Connect Your AppSheet to a MySQL Database - A Step-by-Step Guide
Appsheet Episode 85: How to Edit AppSheet Apps on Mobile Devices: Step-by-Step Tutorial
Просмотров 2,3 тыс.7 месяцев назад
Appsheet Episode 85: How to Edit AppSheet Apps on Mobile Devices: Step-by-Step Tutorial
How to encode your email with Base64 using Apps Script. Full script provided!
Просмотров 4207 месяцев назад
How to encode your email with Base64 using Apps Script. Full script provided!
Appsheet Episode 84: Unique Dropdowns in AppSheet, A Step-by-Step Tutorial
Просмотров 2,6 тыс.7 месяцев назад
Appsheet Episode 84: Unique Dropdowns in AppSheet, A Step-by-Step Tutorial
How to Create a Website Monitoring Tool with Google Sheets and Apps Script
Просмотров 1,4 тыс.7 месяцев назад
How to Create a Website Monitoring Tool with Google Sheets and Apps Script
Appsheet latest rate using select
Просмотров 1,7 тыс.7 месяцев назад
Appsheet latest rate using select
Appsheet Episode 82: How to transfer data to another table using automation workflow in Appsheet.
Просмотров 9 тыс.7 месяцев назад
Appsheet Episode 82: How to transfer data to another table using automation workflow in Appsheet.
Appsheet Episode 81: How to Master Multi-Email Recipients in AppSheet
Просмотров 2,6 тыс.7 месяцев назад
Appsheet Episode 81: How to Master Multi-Email Recipients in AppSheet
Automatic Backup Spreadsheet with Google Apps Script
Просмотров 2,1 тыс.7 месяцев назад
Automatic Backup Spreadsheet with Google Apps Script
Delete old and unused files from Google Drive using Apps Script
Просмотров 6137 месяцев назад
Delete old and unused files from Google Drive using Apps Script
Appsheet Episode 80: Understanding the new INPUT syntax update in Appsheet
Просмотров 7 тыс.7 месяцев назад
Appsheet Episode 80: Understanding the new INPUT syntax update in Appsheet
Appsheet Episode 79: Master Conditional Email Automation in AppSheet
Просмотров 2,8 тыс.7 месяцев назад
Appsheet Episode 79: Master Conditional Email Automation in AppSheet
Appsheet Episode 78: Crafting Multi-Box SVG Images in AppSheet: A Dynamic Visualization Guide
Просмотров 3,6 тыс.8 месяцев назад
Appsheet Episode 78: Crafting Multi-Box SVG Images in AppSheet: A Dynamic Visualization Guide
Appsheet Episode 77: Mastering SVG Scorecards in AppSheet
Просмотров 2,9 тыс.8 месяцев назад
Appsheet Episode 77: Mastering SVG Scorecards in AppSheet
This Videos is very Informative and Hepful. And, I have a few questions for you that I hope you can answer. #QuestionForAris Q1. How can we bulk Upload images in Appsheet(Selecting a number of images means 2 or more at a single time and Upoad)? Q2. How can we generate a PDF Report in a particular Template of a the Entries we have in our App.(For Eg. Generate all the invoices at once in Ascending order in a single PDF)? I would highly appreciate if you find a solution to Queries and make a video on it. Solution for Q2 is very necessary for the App i am Developing. For Q1 i have tried REF_ROWS but it is becoming a long and time taking process to upload a large number of images.
Hi Aris, How to know the number of data's in appsheet? could you please help me in that.
Hi...can you help me about formula for this template...if this table have an price, and how to sum total price with this filter...thanks 🙏🙏🙏🇮🇩🇮🇩🇮🇩
I am not sure bot something may be off in the code you are showing on your website. I tried it for October 2024 and your code returns 21 workdays for me instead of 23. ROUND((TOTALHOURS(EOMONTH(TODAY(),0)-(EOMONTH(TODAY(),-1)+1))/24)+1)- (ROUND((TOTALHOURS(WORKDAY((EOMONTH(TODAY(),-1)+1),ROUND((TOTALHOURS(EOMONTH(TODAY(),0)-(EOMONTH(TODAY(),-1)+1))/24)+1))-(EOMONTH(TODAY(),-1)+1))/24)+1)- IFS( WEEKNUM(EOMONTH(TODAY(),0))=WEEKNUM(WORKDAY((EOMONTH(TODAY(),-1)+1),ROUND((TOTALHOURS(EOMONTH(TODAY(),0)-(EOMONTH(TODAY(),-1)+1))/24)+1))),1, WEEKNUM(EOMONTH(TODAY(),0))<WEEKNUM(WORKDAY((EOMONTH(TODAY(),-1)+1),ROUND((TOTALHOURS(EOMONTH(TODAY(),0)-(EOMONTH(TODAY(),-1)+1))/24)+1))),3 )- ROUND((TOTALHOURS(EOMONTH(TODAY(),0)-(EOMONTH(TODAY(),-1)+1))/24)+1) )
Hi, what if theres 2 conditions for the user role? say for example the site where they are assigned and their role. Will it be the same process?
Very good! ❤ Thank you very much 😊
Hi Aris, I totally loved this playlist, I am also building an app regarding inspections of products. For each product we have to take multiple images from different angle. Can u pls make a video on how to generate multiple pics from the app using camera for each products? And also generate a pdf where we can see a report of different products with multiple images? Thank you👌👌✌
I wonder if the chart can go to -50 to +50 on both Y and X axis, thus creating new 4 quadrants.
great ! Thanks a lot : )
In the formula, how do you add one more return column ? Role, category, and status = (Active-inactive). Thanks
Thanks .... Was looking for such a user friendly report building tool.
A great useful explanation, thanks a lot. See you next video
Glad you liked it! See you too!
Many thanks for your work. I have watched many of your videos about working in Appsheet, but, unfortunately, I still cannot master the creation of PDF. In my case, the document is created by binding to the template that he himself created. Should I start editing it, then either Appsheet does not see it at all, or creates it according to the old model. What could be wrong? Cash? Misconfigured table relationships?
Thank you so much! I've bee struggling to make this role-based custom menu forever! One comment, could the gravity column in the user table just be the virtual instead of physical one?
The struggle is over for you! I am glad it's beneficial for you. Anyways, if there's a need for it to be virtual column I don't see the issue, however it may impact on your app performance eventually since virtual column computes most of the time if not all the time. Either way it can still work
@@aris_azhar I see! I neglected the point that virtual column computes all the time! thanks!
@@ChawinSrabour all is well brother..all is well. Exciting days ahead!
Hi Mr. Aris Azhar, My name is acep anang hermansah from Indonesia, I have question for you, Why the feature Scan QR Code/Barcode in appsheet is not working if open with browser Chrome/Mozilla etc... but if I open with Apsheet APK, it's working...
Thanks ❤
You're welcome 😊
🥰
🥰
Thank you for what you have done for me.💪
Pleasure is all mine! hope it helps
I have applied all the steps and everything has worked excellently but I had a problem when modifying the data I can't update my pdf file
@@Line.ofCode just ensure the bot will trigger on Add and Update . And disable timestamp, Prefix for PDF file is unique..all considered, should work just fine i guess
@@aris_azhar I have implemented what you told me to do The pdf file, which is in Google dirve, has been updated, but when I open the file from the application I find the previous data, Thank you for your cooperation with me
ruclips.net/video/8ZwBioVbjZM/видео.html Video explaining the problem
Really interesting, thanks for sharing Aris. Just a question: Can this product be called/included in other Google products? For example, in appsheet it would be very useful to call a report generated with Looker,
Hello Mr Aris Azhar, I want to ask if, for example, row 2 data is deleted, will the ID document continue to the next number?
Hello Steve! So nice of you to drop by. Anyways, to answer your question, the ID won't continue to the next number based on the deleted one. If you want it to be that way, i will make a Version 2 of this tutorial to do just that. Sounds good?
@@aris_azhar Thank you for your response, sir. Your Appsheet content is very useful and as my learning about this Appsheet Application. I will wait for version 2 of the tutorial from you.
👍 complete tutorial for this video
Ok coming soon! more to come! thank you for supporting me
Nice🎉
Thanks 🤗
@aris_azhar please consider to make dashboard for project tracking like to view the open project and budget available total cost etc. Thank you 😊
@@ianku5208 This is great! i will put it in my list as we go along..i have a few more basic episodes to cover before we go deep into scenarios like the one you mentioned..but nevertheless! this is great! thank you o friend!
@@aris_azhar 💚💙🩵💜
Great video 👍 I learned app sheet from you brother thanks a lot keep it up it makes my work simpler it helps me a lot In day to day activity iam waiting for next video ❤
That is awesome man! i'm glad you are enjoying my content! yes sir! i try to do daily if possible..thank you for your support
Question. We have Table A, Table B, Table C. Table A Row 1. Table B Row 1. We need to transfer some data from Table A and B to Table C. Is it possible ? Thank you
🥰
🥰
Can u please make a video on appsheet calculation on current inventory status
that i can do! stay tune for the next episode
Bro, jenuh aku carik kat video mana la aku tgk kat mana setup Transaction Id with unique ID 😂... Mintak Bro cut video kat situ dan buat satu video dgn tajuk baru yg sesuai, maybe "How to setup Transaction number with Unique ID", senang org lain nak refer. Apa pun TERBAIK cara Bro ngajar, senang faham👍. Terima Kasih utk ilmu²nya 😊...
Dear, is there any community group ? where we can solve our practice problems..
Thanks a lot ❤
You're welcome 😊 and thanks for being an awesome member! Appreciate your support brother
Absolute legend, pode até falar Português kk
Thanks for your video, it's very good and useful. Hope you have more good videos.
Thank you for supporting me! it means a lot! More videos to come..hundreds to go at least ;)
@@aris_azhar Thanks for your reply. Can you guide the login function with usersetting so that your appsheet series is richer and more complete?
This is cool. I used to see a person to show a permission matrix, which includes roles, views, actions, ... and something more i don't remember. I think that's for their commercial purpose so that we don't see sharing around.
I'm glad you find it cool and hopefully useful. I understand as to why this may be not a common knowledge but then again, my objective is purely to give back to the world on what i know. it's always nice to know at the end of the day people are doing amazing things with what they extract from my content. I personally would want to thank you for supporting me ;)
sir, kalu protype appshet boleh ke. atau kena sub beli pro..
Prototype pun boleh. App yang digunakan dalam video saya buat dalam prototype juga.
Very good information sir, please prepare video on how to make assembly bill of material relationship in appsheet.
Thank you! mind explaining in slight detail as for your request?
@@aris_azharSir, thanks for reply, my usecase is to create bill of material for assembly (parent), assembly includes many items (child) and also it may Include subassembly, subassembly Include many items, I want to form relationship between assembly,subassembly, items ans that all Present in master list, user need to create relationship by selecting entity from master list.
You're the best teacher, por favor teacher!
Thank you! 😃 Eres asombrosa!
Excellent, I have a question that I hope you can answer. I want to write an invoice that contains more than one product.
Here you go o friend! ruclips.net/video/kgp-mnsUQPQ/видео.html Enjoy! and thank you for supporting me!
🥰Nice
Thank you Nora 😉 hope you are well
I don't know how to thank you,💪
Happy to help! Appreciate your support too!
This video is very useful. I have a question. Is it possible extract Year and Month from Date without add another two colum? can you explain why do you prefer ad Year and Month colum? Thanks a lot for your instructive videos.
hello! well, it's for some reason to preserve app performance but mainly later on if you want to group your data or display in dashboard etc it'll come in handy if you have these two separated. to answer your question it is possible to not separate them too. anyways, thank you for your support!
@@aris_azhar Thanks a lot, you are right!
@@temyraverdana6421 the pleasure is always mine. Do let me know if you need anything else
dalam spreadsheet ada column profile pic..bagaimana hendak menukar file png appsheet kepada url gambar .
appreciate from indonesia bro
terbaik bossku! thank you for the support sahabat!
good tutorial sir
Many many thanks!
Mantap sekali. Terima kasih! Salute
Mantap bossku! terima kasih support! salute
thank you i really need this.
You're welcome 😊
Thank you for the tutorial! Can you make one where the running number just +1 from the prev number? Like whenever you press the add button the appsheet number column will have a new +1 number
Yes i can do that just for you! give me a moment..it'll be out shortly
@@aris_azharHelloo thanks for replying! I tried using the max(table(row)) +1 formula however whenever I edit the table, the appsheet will create a duplicate with a new number :( Is there anyway to prevent that? Love all your videos btw help me so much for my intern 😊
@@Name-sm8ns Hello! i am glad that most of my videos are helpful. Anyways for your case, maybe it's best to use initial values instead of app formula to generate the ID number. If you use formula it will replace the number with a new one +1 it seems. try it out and let me know the results!
Yupp I used the formula in initial value and it work! Thank you so much!!
@@Name-sm8ns LETS GO! Awesome man..keep it up..you are doing great!
Thank you 🎉
You’re welcome 😊
Thanks a lot!
You're welcome!
Thanks for the tutorial ❤
You're welcome brother! 😊
Zabardastttttt
Thanks Sir, but How about Making an attendance system (clock in, clock out) because were making HRIS, the clock in clock out also includes the tasks or what work he will do