AppSheet POS System and Print Receipt Full Tutorial

Поделиться
HTML-код
  • Опубликовано: 7 сен 2024
  • Appsheet POS System and Print Receipt Full Tutorial
    Join this channel to get access to perks:
    / @joetayactac
    More Tutorials Below
    Scan to View Restaurant Menu
    • How To Create a Scan Q...
    Any Business Inventory Point of Sale Management
    • AppSheet Inventory Poi...
    Restaurant POS Sytem Multiple Item
    • AppSheet Restaurant Mu...
    Generate PDF Using Google Form in Appsheet and Send Email
    • Google Forms To PDF Ap...
    Generate Qr Code
    • How To Generate QR Cod...
    Calculate Age based on Date of Birth
    • How To Calculate Age U...
    Delete Rows of Another AppSheet App
    • How To Delete a Row Da...
    Add and Update Another AppSheet App
    • Add and Update Data in...
    Multiple Items POS System with Inventory Management
    • How To Create Your Own...
    Recover Deleted Row Data
    • AppSheet Copy Data Fro...
    Link PDF File to AppSheet
    • How To Link PDF File ...
    How to Send Whatsapp Messages
    • How To Send Whatsapp M...
    Generate Customize Report and Download in PDF
    • How To Generate a Cust...
    Create Your Own Inventory Management from Scratch using AppSheet
    • How To Make an Invento...
    Appsheet Edit a Table Using Another Table
    • How To Modify a Data T...
    Create your own payroll payslip in Appsheet
    • How To Create a Payrol...
    Create your own TAX Invoice App Printable Using Appsheet and Google sheet
    • How To Create a TAX In...
    Create Your Own POS Restaurant System
    • How to make your own P...
    How to Autofill Columns in AppSheet
    • How To Auto Fill Data ...
    Create a Dynamic Dashboard
    • Appsheet Dashboard View
    Generate Barcode and Random Numbers
    • How to Generate Barcod...
    #appsheet

Комментарии • 90

  • @jonisarowar8424
    @jonisarowar8424 Год назад +15

    please make a complete video about the inventory. Include sell, purchase, stock, profit, loss

  • @c4rvalho582
    @c4rvalho582 Год назад +5

    For anyone having trouble with Select() Function, note that after the equals signal [_thisrow] and [Invoice_No] are separated by a ''.'' not a comma.

    • @marcofrencia7760
      @marcofrencia7760 Год назад +1

      I have been working on the app for a long time and it is impossible for me to calculate the stocks in the Items table

  • @YanuAriyantoSKom
    @YanuAriyantoSKom 11 дней назад

    Sir, in the scenario, namely a restaurant, a customer A comes and orders and says open card, then the customer sits down (card is still open)
    Then customer B comes, orders and sits down, the card is also open
    Then customer A adds to the card that was still open, then the customer will go home and pay and customer A's card is closed
    Likewise customer B, returns to the cashier and closes the card
    Then it is concluded whether customer A can save the item card but it is still open, then the application inputs customer B's item card to be saved
    So get a card with the open method if you are still going to add and close if you are going to pay....

  • @zawminsett
    @zawminsett Год назад +1

    Thanks sir 🙏
    I learn from Myanmar. It teach me a lot.

  • @justfateh9747
    @justfateh9747 Год назад +1

    Thank you from algeria 🇩🇿

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

    Thank you so much I learned more this from this

  • @relaxationradio2
    @relaxationradio2 Год назад +2

    Can you do a complete video of a resturant or cafe touch screen POS

  • @franklinsvideos
    @franklinsvideos День назад

    can appsheet directly send the print command to the default printer connected, on save or click of a print button?

  • @gorebantchiu6469
    @gorebantchiu6469 Год назад +1

    Sir, thanks for your teaching!

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

    Hi! great tutorial, any chance we can get this app as template?

  • @valofee
    @valofee 10 месяцев назад +1

    23:00 Status Sales _isblank status
    1:07:06 Triger to add Status Value
    1:06:15 Clear Cart History
    1:21:39 Preview the PDF

  • @RobertoOchoa-t6u
    @RobertoOchoa-t6u Месяц назад

    Hi! How did you achieve to have the referenced table into the form?

  • @vijayarajan1750
    @vijayarajan1750 Год назад +2

    Thank you from Kochi, India. Can you help me to create a Cloud based POS?

  • @franklinsvideos
    @franklinsvideos День назад

    58:56 - creating receipt

  • @user-fx1ft4mo5m
    @user-fx1ft4mo5m Год назад

    This Awesome.. i got it... the only thing it didn'ts show is the ICON FOR PAYment

  • @aishaaaa6735
    @aishaaaa6735 16 дней назад

    The status did not update to paid after confirm payment…i follow all the steps and rewatch many times but still do not automatically update to paid… if you can give advice i would appreciate it very much

  • @YanuAriyantoSKom
    @YanuAriyantoSKom 11 дней назад

    If the selected item is already in the cart and we intend to change the quantity, is that possible, sir?

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

    Great Lesson
    How Can I install Page Sizer Extension please give me its link

  • @krislukm
    @krislukm 11 месяцев назад +1

    dude thanks a lot. terima kasih banyak

  • @fainst
    @fainst Год назад

    That would be awesome to include VAT to this POS :)

  • @atrevisi
    @atrevisi Год назад

    Hi, thanks your videos please how i can process a payment with this app if its posible

  • @gstore.fruits
    @gstore.fruits 10 месяцев назад

    thanks alot @Joe Tayactac, but i want to set qty to zero become set qty to blank. its possible? how.

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

    Good job sir. Can we send the invoice pdf to whatsapp directly

  • @thanvaatnc.3939
    @thanvaatnc.3939 Год назад +1

    ty, im done my POS cus this

    • @JoeTayactac
      @JoeTayactac  Год назад

      Congrats

    • @najarofficial96
      @najarofficial96 Год назад

      Hey. Can you please share the app with me and allow me to clone it ?

  • @marcofrencia7760
    @marcofrencia7760 Год назад +1

    Porque dice usted en el minuto 0:43 que la app es single user? Que condiciona que la app sea de ese tipo?

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

    just found that google docs moved out page sizer addon, is there any other alternetives?

  • @marcofrencia7760
    @marcofrencia7760 Год назад

    Professor, good afternoon from Argentina, I would like to ask you, how could we add the stocks to the items? Could we save the input units in another table, and then in virtual columns in the "items table" (since the stock is a data inherent to each product) formulate the sums of the difference between the units bought and the units sold? Could you tell us if there is any other way to do it in this app that you propose in this video?

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

    Why there's no popping up for "Order Qty" even if I followed your action 1? 29:25

  • @marcofrencia7760
    @marcofrencia7760 Год назад +2

    How can purchases from suppliers be included in the menu? To later calculate the current stock based on sales?

    • @argyafathurendra1863
      @argyafathurendra1863 Год назад +1

      have u find the solution ??? or any link video that i can watch ?? im struggling too

    • @marcofrencia7760
      @marcofrencia7760 Год назад

      Not yet, but found a fórmula to cout movements

    • @argyafathurendra1863
      @argyafathurendra1863 Год назад +1

      can u share the formula to me ?

    • @marcofrencia7760
      @marcofrencia7760 Год назад

      switch(true(),
      [transType] = "buy" ,[qty],
      or( [transType] = "sell" ,[qty],) ,[qty]*-1 ,0)@@argyafathurendra1863

  • @zawminsett
    @zawminsett Год назад

    I appreciate it
    I suggest one action that really need. After we add to cart and then go payment form. Between adding the cart and payment form, I really need cancel button. After added to cart, I can't delete or undo without going payment form. How to create it. Provide with video sir

    • @fainst
      @fainst Год назад +2

      in views, go to cart, then behavior, then event actions select "delete"

  • @jesusbrea8807
    @jesusbrea8807 10 месяцев назад

    How to change the length of the PDF based on length of the invoice? To save paper when printing. The length of the pdf will be the same for a short or long invoice

  • @argyafathurendra1863
    @argyafathurendra1863 Год назад

    im struggling when im using a real data table already have stock qty ... can someone help,by sugest what should i do ?

  • @kirayagami9229
    @kirayagami9229 Год назад

    Thank you so much sir.

  • @TramitesNanos
    @TramitesNanos Год назад

    Very helpful!! 👌👌👌

  • @Anime-dd3tl
    @Anime-dd3tl Год назад +2

    hi if i want to make a multi price item how life a box and smaller box

    • @JoeTayactac
      @JoeTayactac  Год назад

      Hi, sorry i did not get what you mean

    • @Anime-dd3tl
      @Anime-dd3tl Год назад

      @@JoeTayactac what i meant if there is a way to make 2 values to one item a big one and a small one

  • @user-kv1xh4pe9i
    @user-kv1xh4pe9i Год назад

    My problem was that when I try to add more quantities with apples and then it didn’t automatically add up for apple, it showed one more list of apple order, is there any way to solve this issue, thank you,

  • @jigarsagar4450
    @jigarsagar4450 Год назад

    How can I add upload images for a single product in a (slice filtered) deck view option?

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

    How do i download the above appsheet?

  • @RubickDota-tk8oo
    @RubickDota-tk8oo 11 дней назад

    how to make it open billed

  • @user-rd1kx8cc5m
    @user-rd1kx8cc5m Год назад

    It's seem like my automation is not work. Is it available for plan free?

  • @junwathanaklit854
    @junwathanaklit854 18 дней назад

    REF column in video i,m not look

  • @TREVISOFT1
    @TREVISOFT1 Год назад

    Amazing thanks a lot

  • @newhuman9805
    @newhuman9805 Год назад

    can help me, related Sales not connect in payments

  • @casperdelport3427
    @casperdelport3427 10 месяцев назад +1

    10:12 How do I change the default value to 1?

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

      I also have the same question. Can you show me?

  • @junwathanaklit854
    @junwathanaklit854 18 дней назад

    where?

  • @user-oi7wd4ci9b
    @user-oi7wd4ci9b Год назад

    i notice that with 0 (zero) QTY also can accept. can it condition it minimun qty must 1?

    • @JoeTayactac
      @JoeTayactac  Год назад +2

      Yes You can set minumum value inside the column option

  • @fainst
    @fainst Год назад

    Hi ! thanks for this tutorial, but at 47:59 I don't have the payments form... I think you never showed when you created it in the video ? Please help :) thanks

    • @JoeTayactac
      @JoeTayactac  Год назад

      Hi,
      Payments form is auto generated by Appsheet

    • @fainst
      @fainst Год назад

      @@JoeTayactac thanks for your answer. I don’t know how but it didn’t do it automatically for me. But I’ve recreated it

    • @fainst
      @fainst Год назад

      @@JoeTayactac 1:14:50 the related sales , same thing... I don't see when you explain it, it appears like that ??

  • @user-yv2fn5pn7d
    @user-yv2fn5pn7d Год назад

    Add customer to POS?

  • @prosrath8980
    @prosrath8980 Год назад

    Why on my Appsheet interface there's no UX and Behavior section?

  • @MrPrincePatrick
    @MrPrincePatrick Год назад

    patulong lodz, paano pag isahin nyu same item name sa cart, at mag add nalang ung qty nya?

  • @benzin0007
    @benzin0007 Год назад

    bother it worked well thanks a lot but I failed in 1 thing - the PDF generated link is not displaying after submitting the payment form. the pdf generated and saved in the g drive. Is this because i am using free version?

    • @JoeTayactac
      @JoeTayactac  Год назад

      No even your free should display

    • @benzin0007
      @benzin0007 Год назад

      @@JoeTayactac thank you brother let me cross check again

    • @benzin0007
      @benzin0007 Год назад

      @@JoeTayactac thank you it worked

    • @najarofficial96
      @najarofficial96 Год назад

      @@benzin0007 hello . Can you please share the app with me and allow me to clone it ?

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

      @@benzin0007 how did you do it? after saving the payment, the pdf link won't open :< help

  • @KURAMABUKHGALTERIYA
    @KURAMABUKHGALTERIYA Год назад

    Hello Joe Tayactac,
    I'm experiencing an issue with creating PDF files when a new order is added to my "Order" table. I have set up an automated process where a PDF file is generated, which includes data from the "Order Details" table.
    However, I'm encountering an issue where the PDF is created before the synchronization of the newly added data in the "Order Details" table is completed. As a result, the generated PDF file does not include the most recent data from "Order Details".
    I understand that operations in AppSheet, including data updates and workflow actions, are asynchronous and do not necessarily complete in a specific order. But is there a way I can ensure the synchronization completes before the PDF is generated?
    I'm considering a delay function for the PDF generation action, but I'm unsure whether this is the best approach, as it might introduce unnecessary delays for the users.
    I'd appreciate any ideas or solutions that can help me address this challenge.
    Thanks

    • @JoeTayactac
      @JoeTayactac  Год назад +1

      Hi
      You need to create on form save data change action and set your pdf Automation on Update only

  • @adityanaufalghifari9112
    @adityanaufalghifari9112 11 месяцев назад

    Hey, can i get template receipt from u sir?

  • @learningstudent5283
    @learningstudent5283 Год назад

    Can you help me why doing all the steps still my STATUS is not showing paid ? PLZ

    • @sunnychickymilk
      @sunnychickymilk Год назад

      Mayve error syntax in pdf file

    • @c4rvalho582
      @c4rvalho582 Год назад

      @@sunnychickymilk Same error happened here, end the solution was exactly that, what happens is that the first action the bot does is to generate the pdf, and if the pdf is with a wrong syntax it does not generate, and the following actions also don't happen

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

      How to solve this?

  • @alialredaissa809
    @alialredaissa809 Год назад

    is it possible to choose the items by scaning the barcode ?

    • @claytonjsm
      @claytonjsm 10 месяцев назад

      I would like to know too. Did you get any response?

    • @alialredaissa809
      @alialredaissa809 10 месяцев назад

      @@claytonjsm yeah just turn on the scannable options on the barcode column

  • @pemudaharapanbangsyam-uv6lv
    @pemudaharapanbangsyam-uv6lv 10 месяцев назад

    why the action for update status to Paid not working

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

      Me to

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

      How to solve this?

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

    paano po for multiple users ? sent email po Sir!

  • @Anime-dd3tl
    @Anime-dd3tl Год назад

    1:00:0

  • @mouhmed767
    @mouhmed767 Год назад

    Very slow app. Customers will get tired of waiting and hate the store😅

  • @ResulfLee
    @ResulfLee 22 дня назад

    google play: Appsheetprint
    This app print no sync appsheet