What's up Matt? Been following along your build series for a few days trying to assess where I've been going wrong (blindly)....I've been out of the programming loop over 20 years since I started in MS Access VBA, sure has changed. Your build is a small peek at what foundation I am attempting to produce. I am an Automotive Diagnostician, I run the company solely. Labor, billing, inspections, service records, expenses, taxes etc.... I have so far started with the Appsheet Database (still buggy). I finally have my Customers and Vehicles tables able to mesh with a Vehichle Inspection Checklist, that took forever. I am now attempting to add in tables one at a time for billing (Vehicle Service Records). I Have a table built that contains a concatenated (not as an expression) "parts description" Has Part Manufacturer, Part Number, and Description typed out as one long string. Having so many columns for one part was killing me trying to get them to autofill. Next columns have part cost, part shipping and a virtual column that adds those together and adds the tax to get a Part Price. Service Record prices will include everything, no breakdown of costs. Will need to include Qty into the equation, as this will be a multi-line parts "order", with a Parts Total summary. THE ISSUE: I have parts, services(labor rates for different aspects of jobs), and fees (Battery Cores, subcontracted work, etc...) Labor and Fees are not taxed, just be ID#'s, Descriptions,and Hours/Quantities. I will need to somehow start my Service Record like your New Order Form,... Enter Customer,Vehicle,AutoDate,Record#(UniqueID()), Status, and what I'm thinking is "Category" to segregate the three different aspects of the service record and still be able to produce a final bill summary and still be able to run a process to convert to a PDF. Is there any rational way to do this with Appsheets or are these headaches I'm getting from another source, like cancer?...LOL. Appreciate your wisdom so far. --Dustin
Hi Matt, really nice work. I’ve been trying this for a while and watched all your shopping cart build, really great content. I also bumped into a great 2 hour video “google sheet POS system” that guy built a shopping cart with SCRIPT. Which now makes me think, maybe we can combine App Sheet and Google Sheet Script to make it very efficient
The easy of use, flexibility, and power of Google Drive, Google Sheets, AppSheet, and Apps Script is incredible. Being able to natively call a script, and get a return value, really ups the power of the AppSheet platform. - This is what's driving all the Ai stuff I've got recently. It's all handled through a script I'm calling through a bot. #Fire
I added a quantity column to add how many Items I want and a virtual columns called subtotal that only do quantity * price, all inside the products table. In the order table instead of getting the price from the product I`m getting the subtotal from all the item from order and wrap in a SUM. Something like this. ( sum([Related_Product][SubTotal]). Its working fine.
Mate.... I've just realized how woefully unhelpful the current version of the shopping cart part 7 is.... I'm redoing that today. I'll include this aspect into things while I'm doing that too.
@@MultitechVisions Hi Matt, Thanks for all the videos in this series as I've learnt a lot from them. I'm developing something similar but my app needs the user to be able to have multiple on-going order at the same time. I added a view where I show all on-going orders and the corresponding order details will reflect accordingly when I click on the different order. What I'm not able to do is to add the product into for any order which is not the first one on the list. :s I was trying to find a way to overcome this "INDEX(New_Orders[OrderID], 1)" in the action to add but failed miserably. Do you have any clue on how to fix that? Thanks again.
![Discount & Totals || Shopping-Cart [UPDATE] - Part 7.2](http://i.ytimg.com/vi/5j4yXq-iCco/mqdefault.jpg)
![Discount & Totals || Shopping-Cart [UPDATE] - Part 7.2](/img/tr.png)
What's up Matt? Been following along your build series for a few days trying to assess where I've been going wrong (blindly)....I've been out of the programming loop over 20 years since I started in MS Access VBA, sure has changed. Your build is a small peek at what foundation I am attempting to produce.
I am an Automotive Diagnostician, I run the company solely. Labor, billing, inspections, service records, expenses, taxes etc.... I have so far started with the Appsheet Database (still buggy).
I finally have my Customers and Vehicles tables able to mesh with a Vehichle Inspection Checklist, that took forever. I am now attempting to add in tables one at a time for billing (Vehicle Service Records). I Have a table built that contains a concatenated (not as an expression) "parts description" Has Part Manufacturer, Part Number, and Description typed out as one long string. Having so many columns for one part was killing me trying to get them to autofill. Next columns have part cost, part shipping and a virtual column that adds those together and adds the tax to get a Part Price. Service Record prices will include everything, no breakdown of costs. Will need to include Qty into the equation, as this will be a multi-line parts "order", with a Parts Total summary.
THE ISSUE: I have parts, services(labor rates for different aspects of jobs), and fees (Battery Cores, subcontracted work, etc...) Labor and Fees are not taxed, just be ID#'s, Descriptions,and Hours/Quantities. I will need to somehow start my Service Record like your New Order Form,... Enter Customer,Vehicle,AutoDate,Record#(UniqueID()), Status, and what I'm thinking is "Category" to segregate the three different aspects of the service record and still be able to produce a final bill summary and still be able to run a process to convert to a PDF.
Is there any rational way to do this with Appsheets or are these headaches I'm getting from another source, like cancer?...LOL. Appreciate your wisdom so far. --Dustin
Hi Matt, really nice work. I’ve been trying this for a while and watched all your shopping cart build, really great content. I also bumped into a great 2 hour video “google sheet POS system” that guy built a shopping cart with SCRIPT. Which now makes me think, maybe we can combine App Sheet and Google Sheet Script to make it very efficient
The easy of use, flexibility, and power of Google Drive, Google Sheets, AppSheet, and Apps Script is incredible. Being able to natively call a script, and get a return value, really ups the power of the AppSheet platform.
- This is what's driving all the Ai stuff I've got recently. It's all handled through a script I'm calling through a bot.
#Fire
Is it possible to add, item no x kgs x product price?
I added a quantity column to add how many Items I want and a virtual columns called subtotal that only do quantity * price, all inside the products table. In the order table instead of getting the price from the product I`m getting the subtotal from all the item from order and wrap in a SUM. Something like this. ( sum([Related_Product][SubTotal]). Its working fine.
@@djbokinha Thankyou. Template link pls
Mate.... I've just realized how woefully unhelpful the current version of the shopping cart part 7 is.... I'm redoing that today. I'll include this aspect into things while I'm doing that too.
@@MultitechVisions Hi Matt, Thanks for all the videos in this series as I've learnt a lot from them. I'm developing something similar but my app needs the user to be able to have multiple on-going order at the same time. I added a view where I show all on-going orders and the corresponding order details will reflect accordingly when I click on the different order. What I'm not able to do is to add the product into for any order which is not the first one on the list. :s I was trying to find a way to overcome this "INDEX(New_Orders[OrderID], 1)" in the action to add but failed miserably. Do you have any clue on how to fix that? Thanks again.
Hi Matt, Shop Cart 7 link is broken
What do you mean mate?
@@MultitechVisions when I clicked on the link it didn't open but this was in the morning, before you did a new version so I guess you've fixed it now.