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.🙂
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!
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"
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.
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.
You can use the transactions table for this as well. I didn't cover this in the video but, when you setup a REF type column there is the option to set "is a part of". This will add the function of allowing you to add multiple items when creating a new invoice. Check out the bottom part of this help article. support.google.com/appsheet/answer/10106510?hl=en
@@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.
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.
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.🙂
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.
great rich , that is great , i have an esue how can i deal with the changing of price of product without crupted old data with the old price ?
Awesome video. I was able to follow and duplicate from start to finish. Thanks so much.
Glad it helped!
Relative reference list items not appearing in pdf
What programming language(s) can you use on the formula section?
It's a proprietary system. However it is very similar to Excel/Sheets.
Thank you for this excellent tutorial!
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.
Rich!! Thank you very much!
You are great!
Glad it helped!
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...
Thanks Rich, succinct and useful, as always
My pleasure!
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.
If a customer would want to buy more than one thing in an invoice how could this be made possible?
You can use the transactions table for this as well. I didn't cover this in the video but, when you setup a REF type column there is the option to set "is a part of". This will add the function of allowing you to add multiple items when creating a new invoice. Check out the bottom part of this help article. support.google.com/appsheet/answer/10106510?hl=en
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
Thank you 🙏🏼🙏🏼🙏🏼🙏🏼
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.