Make an Invoicing App
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- In this video I go over how to make an app to track customer transactions and create a monthly invoice from those transactions.
The app I made in this video can be viewed as an app template here:
www.appsheet.com/templates/a?...
0:00 Overview
1:05 Tables
3:11 Column Settings
6:21 Views
13:20 Automations
20:46 Email Template
22:21 Final Tweaks
24:46 Named Months (Not Numbers)
26:20 Finished Result - แนวปฏิบัติและการใช้ชีวิต
Hi Rich. Thank you so much for this video and all the other videos that you have made. I have been on other Apphsheet channels. And by far I have learned way more on your channel than all of the others combined. I like how you dive straight into the task at-hand and explore functions that are quite unique or not usually discussed by other experts. And most importantly you show the whole process of creating Appsheet app from beginning to end; which most other channels don't.
I hope my gratitude will encourage you to keep producing great tutorial videos! Keep up the great work sir!
Thanks for the kind words! I appreciate it.
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.🙂
Thank you for this excellent tutorial!
Awesome video. I was able to follow and duplicate from start to finish. Thanks so much.
Glad it helped!
Thanks Rich, succinct and useful, as always
My pleasure!
Rich!! Thank you very much!
You are great!
Glad it helped!
Thank you 🙏🏼🙏🏼🙏🏼🙏🏼
This is great. Wonderful presentation.
Pls can you make a video of multiple item POS system, that a customer selects an item and a pop-up requests for quantity and verifies amount. Is it possible? If is, Pls help a beginner.
Relative reference list items not appearing in pdf
Hello, many thanks for your valuable video. There is some point that when I add an unit from Invoices button but Invoice's total does not change in both google sheet and appsheet screen as well, how I can correct ?
If you are using an app formula it only computes when the record is updated. If you want the data to be updating in realtime in the Google sheet, then you need to create a column that has an Google sheet formula and regenerate the table in AppSheet. Appsheet will pickup this formula to ensure it is also added to all new records that are added too. This formula will show in the column settings under "Spreadsheet formula"
Hi Great tutorials! Im trying to copy your app but i keep get erorrs saying it can't find the sheets templates, have you removed them?
Sorry about that. It is fixed.
Peace!
Such a nice work!
I want know that, how can i make duplicate of a sheet including app..?
I've more then five clients, but their work is similar. So how can be possible that one time work can be applied to all copied/duplicated app...???
You can make a copy of an app under Manage>Author. You will see the option to copy. After clicking copy you can choose to copy the data as well.
Once you make a copy those apps are all independent. However you can make a reference app and use the Upgrade functionality under Manage>Version by targeting your reference app. However after you do that you need to take care and connect the app back to the appropriate data sources for each of the copies.
@@appify such a noice of...
Your means that do that work again like cell referance make again...
Actually i am travelling yet, therefore i did not practical...
please make clearify little bit more...
What programming language(s) can you use on the formula section?
It's a proprietary system. However it is very similar to Excel/Sheets.
Sir can you create a video on lookup function…. Its quite confusing please
here you go! th-cam.com/video/ixyj_UoRifI/w-d-xo.html
Great video but need help with a expression pls
Sure. What are you trying to do?
@@appify when I add a record to the Child’s table under (Trip) , I want the the (Dashboard ) table to update automatically with the new info . And hide the update button in the background.
Sorry Dashboard is the parent
To hide the update button go to Behaviors -> actions and click show system actions at the bottom of the page. This will show the edit system action which you can then hide.
Are you wanting to update a specific field in the dashboard table record? I would need a little more info on what from the child table you want to update in the dashboard.