Aris Azhar
Aris Azhar
  • 121
  • 903 009
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:
ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin
Переглядів: 2 722

Відео

Looker Studio Tutorial for Beginners: What It Is & How to Get Started
Переглядів 91228 днів тому
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!
Переглядів 2,5 тис.Місяць тому
Join this channel to get access to perks: ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin 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 acces...
Appsheet Episode 97: Basic understanding of labels for a better experience. Simple Steps!
Переглядів 1,1 тис.Місяць тому
Join this channel to get access to perks: ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin 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 #AppS...
Appsheet Episode 96: How to create custom running number with prefix. Simple steps!
Переглядів 932Місяць тому
Join this channel to get access to perks: ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin 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: Creat...
Appsheet Episode 95: How to calculate distance between two points. FREE Method!
Переглядів 3,5 тис.3 місяці тому
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,6 тис.3 місяці тому
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: ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin
Appsheet Episode 93: How to disable previous dates in data entry. Simple Steps!
Переглядів 1,2 тис.3 місяці тому
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,9 тис.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,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,6 тис.6 місяців тому
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 тис.6 місяців тому
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!)
Переглядів 8556 місяців тому
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: ua-cam.com/channels/hBCB5V1jKzMK40139idOmg.htmljoin
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
Переглядів 7437 місяців тому
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,8 тис.7 місяців тому
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,8 тис.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!
Переглядів 4377 місяців тому
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 тис.8 місяців тому
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 тис.8 місяців тому
How to Create a Website Monitoring Tool with Google Sheets and Apps Script
Appsheet latest rate using select
Переглядів 1,7 тис.8 місяців тому
Appsheet latest rate using select
Appsheet Episode 82: How to transfer data to another table using automation workflow in Appsheet.
Переглядів 9 тис.8 місяців тому
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,7 тис.8 місяців тому
Appsheet Episode 81: How to Master Multi-Email Recipients in AppSheet
Automatic Backup Spreadsheet with Google Apps Script
Переглядів 2,2 тис.8 місяців тому
Automatic Backup Spreadsheet with Google Apps Script
Delete old and unused files from Google Drive using Apps Script
Переглядів 6378 місяців тому
Delete old and unused files from Google Drive using Apps Script
Appsheet Episode 80: Understanding the new INPUT syntax update in Appsheet
Переглядів 7 тис.8 місяців тому
Appsheet Episode 80: Understanding the new INPUT syntax update in Appsheet
Appsheet Episode 79: Master Conditional Email Automation in AppSheet
Переглядів 2,9 тис.8 місяців тому
Appsheet Episode 79: Master Conditional Email Automation in AppSheet
Appsheet Episode 78: Crafting Multi-Box SVG Images in AppSheet: A Dynamic Visualization Guide
Переглядів 3,8 тис.8 місяців тому
Appsheet Episode 78: Crafting Multi-Box SVG Images in AppSheet: A Dynamic Visualization Guide
Appsheet Episode 77: Mastering SVG Scorecards in AppSheet
Переглядів 3,1 тис.8 місяців тому
Appsheet Episode 77: Mastering SVG Scorecards in AppSheet

КОМЕНТАРІ

  • @FancyZardosi
    @FancyZardosi День тому

    Liked and subscribed❤👍

  • @tewchannel715
    @tewchannel715 3 дні тому

    Hi! Aris. Can you send a photo too?

  • @SantragoPipian
    @SantragoPipian 4 дні тому

    Great videos mate. Unfortunately, I did everything, but the app does not start at the welcome view I created. Can you point me where to look to fix it?

  • @sohaibasif
    @sohaibasif 4 дні тому

    When i connect supabase data to appsheet, my tables show up in appsheet but it gives an error that schema is not found, why is this

  • @cmsaskrindomedan5426
    @cmsaskrindomedan5426 4 дні тому

    bagaimana caranya agar kita bisa mengambil beberapa kalimat dari longtext tersebut untuk dimasukkan ke kolom yang lain?

  • @candidofreitas9284
    @candidofreitas9284 5 днів тому

    Perfect !!

  • @noranoranha8411
    @noranoranha8411 6 днів тому

    😘

  • @NgJingYing-y5x
    @NgJingYing-y5x 7 днів тому

    Hi, I am unable to open the Link to Expression. It showed this error: Oops, This Page Could Not Be Found! 404

    • @aris_azhar
      @aris_azhar 7 днів тому

      arisazhar.com/viewing-previous-balance-in-appsheet/ hello! i apologize for the technical error. Here's the link that you requested and thanks for pointing it out. I am fixing the link as we speak.

  • @comarastaman
    @comarastaman 7 днів тому

    Hello, I hope you can read this and shed light on this question. Is there a way that you can specify a color for a certain range? For example, 25 - 50% is red, 50.01% - 75% is yellow, and 75.01% - 100% is green?

  • @RaghuramanR-y5h
    @RaghuramanR-y5h 7 днів тому

    In the Appscript you've provided, can you pls confirm if the for loop is supposed to start from 1? I'm quite confused - Why? Array starts from 0 only right?. Or is it just a small mistake and I'm overthinking myself

  • @joelcbcc
    @joelcbcc 8 днів тому

    Thank you from Brazil

  • @JadiMudahID
    @JadiMudahID 8 днів тому

    Any recomend database? For long use, Input Daily up to 1000 row, Google spreadsheet just 100K

  • @SantragoPipian
    @SantragoPipian 9 днів тому

    Great video, great help thanks. I have a problem when the operators scroll down to give a score with the slider. Is it possible to use buttons instead of a slider? I tried to change the rage for another option but it doest work.

  • @Hero-z1d6w
    @Hero-z1d6w 9 днів тому

    2024 menonton videonya nice tapi bingung, halaman pertama (loginnya) tidak dijelaskan di video

  • @cmsaskrindomedan5426
    @cmsaskrindomedan5426 10 днів тому

    Can you make tutorial API fot Face detection in appsheet?

  • @deltaisistemas3380
    @deltaisistemas3380 11 днів тому

    Hello Aris. How are you? Could you help about one question? I have a panel view, where I select information in one of the panels and the view in the other panel is affected/updated with related information. The problem is that every time I access the dashboard view all the information from the other related view is loaded, how can I avoid this? I would like the view to be properly "filtered" when accessing the dashboard, as if the first record was selected.

  • @nelsonlim1389
    @nelsonlim1389 11 днів тому

    Can i have a follow up question for this topic?

  • @Fredmalta1910
    @Fredmalta1910 11 днів тому

    Dear Aris Azhar, With your help I succeeded. In addition to knowledge, you have another skill, you can simplify to teach. Your pauses and voice rhythm helped me in the learning process. Thank you very much.

  • @santosahernandezmendoza7147
    @santosahernandezmendoza7147 12 днів тому

    Una Aplicación digna de admirarse, espectacular, bien ordenada y con un trabajo impecable de programación apps script. Felicitaciones para Aris, y por supuesto me suscribo. muchas gracias.

  • @jakejordanserrano1306
    @jakejordanserrano1306 12 днів тому

    Does it work on a free account? Thanks!

  • @yasithagayan
    @yasithagayan 12 днів тому

    Hello friend. You are amazing. Could you please give me full tutorial about how to make an online store using appsheet.

  • @Fredmalta1910
    @Fredmalta1910 13 днів тому

    Aris, obrigado você com poucas palavras me ajudou, agora minha views funciona, consegui colocar essa restrição para quem pode ver a tabela e quem não pode..

  • @santosdeia25
    @santosdeia25 14 днів тому

    Eu quero bloquear o upload de um arquivo, se em uma coluna houver uma quantidade maior de caracteres além do permitido. É possível?

  • @IndraWidiharto
    @IndraWidiharto 14 днів тому

    subhanallah..this is fascinating! thanks brother

  • @daytodatainc
    @daytodatainc 14 днів тому

    Brilliant

  • @gztv8140
    @gztv8140 15 днів тому

    😮this is what i am looking for. Thank you for this from now on i am your subcribers❤. Looking forward to your videos about the appsheet tutorials.

  • @DanielCalle-s4w
    @DanielCalle-s4w 16 днів тому

    Useful information and well explained. Thank you.

  • @arevresmurf
    @arevresmurf 16 днів тому

    Hi Aris, good day!. can you do a tutorial on the preview feature on columns with longtext type to change the detail view of appsheet using html codes?

  • @ZannaMariya_21
    @ZannaMariya_21 16 днів тому

    Is there any way to remove or hide this application was created by Google apps script user .?

  • @tirtharajpaul1512
    @tirtharajpaul1512 17 днів тому

    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.

  • @lingarajcmgowdru3114
    @lingarajcmgowdru3114 17 днів тому

    Hi Aris, How to know the number of data's in appsheet? could you please help me in that.

  • @enqyonboat6426
    @enqyonboat6426 17 днів тому

    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 🙏🙏🙏🇮🇩🇮🇩🇮🇩

  • @grellguy
    @grellguy 18 днів тому

    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) )

  • @jillmalang4904
    @jillmalang4904 18 днів тому

    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?

  • @EdnaMedeiros-j5d
    @EdnaMedeiros-j5d 20 днів тому

    Very good! ❤ Thank you very much 😊

  • @saurabhmnair4290
    @saurabhmnair4290 21 день тому

    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👌👌✌

  • @SportsCentreLo
    @SportsCentreLo 21 день тому

    I wonder if the chart can go to -50 to +50 on both Y and X axis, thus creating new 4 quadrants.

  • @Beyond_Spirit
    @Beyond_Spirit 21 день тому

    great ! Thanks a lot : )

  • @vpapaioannou
    @vpapaioannou 25 днів тому

    In the formula, how do you add one more return column ? Role, category, and status = (Active-inactive). Thanks

  • @senthilramadhurai7616
    @senthilramadhurai7616 26 днів тому

    Thanks .... Was looking for such a user friendly report building tool.

  • @temyraverdana6421
    @temyraverdana6421 28 днів тому

    A great useful explanation, thanks a lot. See you next video

    • @aris_azhar
      @aris_azhar 28 днів тому

      Glad you liked it! See you too!

  • @artprintkyiv
    @artprintkyiv 28 днів тому

    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?

  • @ChawinSrabour
    @ChawinSrabour 28 днів тому

    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?

    • @aris_azhar
      @aris_azhar 28 днів тому

      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

    • @ChawinSrabour
      @ChawinSrabour 26 днів тому

      @@aris_azhar I see! I neglected the point that virtual column computes all the time! thanks!

    • @aris_azhar
      @aris_azhar 26 днів тому

      @@ChawinSrabour all is well brother..all is well. Exciting days ahead!

  • @anugrahbungolestari9276
    @anugrahbungolestari9276 28 днів тому

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

  • @abdullahazam
    @abdullahazam 29 днів тому

    Thanks ❤

  • @noranoranha8411
    @noranoranha8411 29 днів тому

    🥰

  • @Line.ofCode
    @Line.ofCode 29 днів тому

    Thank you for what you have done for me.💪

    • @aris_azhar
      @aris_azhar 29 днів тому

      Pleasure is all mine! hope it helps

    • @Line.ofCode
      @Line.ofCode 29 днів тому

      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

    • @aris_azhar
      @aris_azhar 29 днів тому

      @@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

    • @Line.ofCode
      @Line.ofCode 28 днів тому

      @@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

    • @Line.ofCode
      @Line.ofCode 28 днів тому

      ua-cam.com/video/8ZwBioVbjZM/v-deo.html Video explaining the problem

  • @robecala
    @robecala 29 днів тому

    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,

  • @stevearies8109
    @stevearies8109 29 днів тому

    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?

    • @aris_azhar
      @aris_azhar 29 днів тому

      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?

    • @stevearies8109
      @stevearies8109 29 днів тому

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

  • @fayasahamed5587
    @fayasahamed5587 29 днів тому

    👍 complete tutorial for this video

    • @aris_azhar
      @aris_azhar 29 днів тому

      Ok coming soon! more to come! thank you for supporting me