@@alexmeraru4364 I've got a good post describing all of this in the community: community.appsheet.com/t/use-enum-enumlist-base-type-ref-to-de-reference-data-reduce-reverse-reference-clutter/35867?u=multitech_visions
You're welcome! Make sure to thank Steve in the community, he's the originator of this process. (In fact, his original post on how to accomplish looping contains a few different ways to signal the "end" - it's definitely worth checking out.)
Thanks for the video and shearing this awesome techinque!! Really appreciated it! First video I watch in the channel, now subscribed and looking for more knowledge!
Amazing! I've been search an video like this sice two or trhee days in portuguese, but only this video has resolved my problem. thanks for that! Maybe i'll make a similar video in portuguese for brazilian appsheet comunity.
Amazing! A very efficient way of automating the creating of all those child records. I like this format of instructional.. just going with the flow while learning a lot along the way! I really enjoyed the whole video.. Thank you! :)
@@MultitechVisions Yeah I like watching how you navigate the Editor.. and just describing whats going through your mind while switching between the UX, Columns & Behaviour etc.. I think that these sorts of videos will have a lot of views in the future when Appsheet takes off! Thanks for sharing!
Hey, thanks for this video. I find your solution to looping very elegant. I have attempted to follow the video to incorporate this into an app I am building for my girlfriends food selling business. I have everything working except that it only runs the loop once. I think I know why. I am attempting to add a single row on my Orders table (these are the individual food items that she needs to make/deliver) for each Invoice Line Item that is a child to (a part of) Invoices. The common data from an Invoice (order date, client, source) are added to each new Table row, and then I add the first (using Index) Invoice Line Item to the Table row, then try to loop through using your method of list subtraction. The hope is that the Invoice is broken down into individual Order rows so that she can check them off as she makes or delivers them. Because all of my loop actions reside on the Invoice table, the loop action sees only a single record on the Invoice table (even though there are multiple Invoice Line Items under that Invoice record ), even when I set the Reference Rows to the Related Invoice Line Items column that is auto populated on the Invoice table. I expected the list I referenced to be seen as the set of rows to have an action performed on it but it seems like the “Action on a set of rows” will not use a set of rows that is one level removed from the table that the action lives. Make sense? I wonder of there is a way to reference the child set somehow rather than only the sets living on the Invoice table directly? Thanks for any response!
Fantastic demo and tutorial, mate! Much much appreciated! Wondering whether it is possible to push this to next level to achieve update child and grandchild records when the parent enumlist is changed so that 'order_details' and 'order_fullfillments' are synced to 'orders':)
Absolutely! All you'd need to do is create a Ref Update action on the parent, that runs the update action over each of the child record lists. You'll have to create a different Ref Update action for each separate table involved - one for each table. I would be careful with these updates back and forth like this though... it's really easy to end up with hundreds of "pointless" updates made back and forth. - Whenever I need to do something like this, I'll make sure I identify some sort of criteria I can put into the condition space; that way the updates only run they they need too vs. all the time.
Great video. Very helpful. Got an added wrinkle that I'm working out. I have 2 columns of enumlist data that I would like to put into the same final list. How would I augment the process steps to make this work?
Amazing explanation! I'm trying to make an iterative calculation and could be possible to do it with a looping action, but I got missed in how to do it as you explained in the video. Here's the thing! I have field which calculate a loan's mount and for that the calculation must consider the amount of the disbursement plus expenditure costs, and the expenditure costs must be calculated using the loan's mount multiplied by the expenditure percent. This turns into a looping calculation, but it could be ended at the 100th step. Is there an easy way to do it?
I feel like there's some faulty logic happening here.... perhaps the solution would be to include another variable, like a "Starting Amount" and another "Final Amount" or something? Did you ever get this working?
If you're trying to assign the same qty for each product, just include that column inside the columns to set for the action that actually makes the record. If you're trying to assign DIFFERENT qtys to each product, you'll need to not use this method and instead loop through forms.
Hi . Amazing video - everything work perfectly fine - I can automatically add new rows with new data with the loop = but, except - now my SYNC PROCESS takes forever . What maybe the reason for the stalling of SYNC to the datasource?
The problem you're likely running into is related to the difference between "client-side" and "server-side" in appsheet: - ruclips.net/video/sDS8l7k-2cY/видео.html
Great video!! I'm a rookie and still don't get the action thing! haha. I've got products, orders and detail and haven't been able to update de product stock qty any time I put the order status to "approved". Any ideas or some video I should watch?? thanks so much for your great work, keep it up!!!!!!!
Glad it was helpful! Unfortunately right now there is limited resources on this topic. - But honestly... that sort of build methodology carries with it an extra burden of having to "manage the qty update" - Instead you can create your inventory count as a VC inside AppSheet, this way it's always updated based on the data in the system. (Added to the list - I'm thinking a Part 2 to the Shopping Cart video will include something like a "current quantity" count for items.) ----------------------------------| A little bit of insight The reason people don't think to go this route is typically because they're likely still using Spreadsheets as a data interface - they've yet to see the true power of AppSheet, and still see spreadsheets as useful. So they're trying to build their sheets/columns so that things make sense wile looking at them in the sheet. - Eventually though, you'll find the usefulness of spreadsheets will diminish, as the true power of AppSheet becomes apparent and available to you. - Once you reach this point, the spreadsheet becomes nothing more than a data repository - and then ideas like "maintaining a physical column for something that should be virtual" isn't a barrier anymore.
My app freezes after modifying the 'Event Actions" to the Loop Create Action in the Orders Form View (after saving a new order) ( 25:00 ). Please help :(
Hello Omar. To better help troubleshoot the problem, and to bring in additional experts such as myself, please head on over to community.appsheet.com/t/looping-with-actions-sample-app-build-video and investigate further there.
You might be hitting the "edit" button instead of the "New" button; if you head on over to community.appsheet.com/ that's a better place to get assistance. ;)
I don't know what Im doing wrong. I did exactly what you showed, except instead of putting it as an action in firm saved, I had it as a prominent button. When I execute the group, my app freezes. It's like consuming all my pc memory.
Hey guys. Im sorry Im the newbie, but my repeater isnt repeating. I get an error "There is already a row with the key '12/30/1899 19:05:50'". Maybe I zigged when I should have zagged??
You can run into this problem when you're using a DateTime as your ID value. Try using UniqueID() instead, that should solve your problem. Ultimately what's happening here is that all the items are being created so fast that they can share a timestamp (since datetime rounds to the second) - which causes two records to have the same ID... which you can't do.
You are the first channel I really subscribe to!
Love picking your brain ;)
Kind of sounds like I should up my video game, 😂
@@MultitechVisions I have Steve's version in one of my apps.
I am trying yours in the one that I am working at now.
Great video!
Thanks!
@@MultitechVisions
Ref vs Enum - Base type Ref...?
Never user Enum like that.
How does it work?
What's the advantage?
@@alexmeraru4364 I've got a good post describing all of this in the community:
community.appsheet.com/t/use-enum-enumlist-base-type-ref-to-de-reference-data-reduce-reverse-reference-clutter/35867?u=multitech_visions
Thanks Matt....this is great....pretty kool stuff!
Thank you for sharing the great method in looping actions. I managed to use this in my app and it works perfectly.
You're welcome! Make sure to thank Steve in the community, he's the originator of this process. (In fact, his original post on how to accomplish looping contains a few different ways to signal the "end" - it's definitely worth checking out.)
Thanks for the video and shearing this awesome techinque!! Really appreciated it! First video I watch in the channel, now subscribed and looking for more knowledge!
Amazing! I've been search an video like this sice two or trhee days in portuguese, but only this video has resolved my problem. thanks for that! Maybe i'll make a similar video in portuguese for brazilian appsheet comunity.
Awesome! Thanks for sharing
Great job! Tank you for sharing your knowledge and experience....
You're very welcome!
Amazing!
A very efficient way of automating the creating of all those child records.
I like this format of instructional.. just going with the flow while learning a lot along the way!
I really enjoyed the whole video.. Thank you! :)
Thank you very much. (^_^) I wasn't sure if this format would work for people or not.
@@MultitechVisions Yeah I like watching how you navigate the Editor.. and just describing whats going through your mind while switching between the UX, Columns & Behaviour etc..
I think that these sorts of videos will have a lot of views in the future when Appsheet takes off! Thanks for sharing!
@@brand-ittechnologies8443 Thanks so much for the feedback.
Thanks Matt... That was really awesome... Cheers... :)
Amazing!
This really make life easier, thanks for sharing the method
😄
Very Good and educative. Matt can we have quantity column in product list. If yes can you guide. Thanks
Hey, thanks for this video. I find your solution to looping very elegant. I have attempted to follow the video to incorporate this into an app I am building for my girlfriends food selling business. I have everything working except that it only runs the loop once. I think I know why.
I am attempting to add a single row on my Orders table (these are the individual food items that she needs to make/deliver) for each Invoice Line Item that is a child to (a part of) Invoices. The common data from an Invoice (order date, client, source) are added to each new Table row, and then I add the first (using Index) Invoice Line Item to the Table row, then try to loop through using your method of list subtraction. The hope is that the Invoice is broken down into individual Order rows so that she can check them off as she makes or delivers them.
Because all of my loop actions reside on the Invoice table, the loop action sees only a single record on the Invoice table (even though there are multiple Invoice Line Items under that Invoice record ), even when I set the Reference Rows to the Related Invoice Line Items column that is auto populated on the Invoice table. I expected the list I referenced to be seen as the set of rows to have an action performed on it but it seems like the “Action on a set of rows” will not use a set of rows that is one level removed from the table that the action lives. Make sense? I wonder of there is a way to reference the child set somehow rather than only the sets living on the Invoice table directly? Thanks for any response!
Fantastic demo and tutorial, mate! Much much appreciated! Wondering whether it is possible to push this to next level to achieve update child and grandchild records when the parent enumlist is changed so that 'order_details' and 'order_fullfillments' are synced to 'orders':)
Absolutely! All you'd need to do is create a Ref Update action on the parent, that runs the update action over each of the child record lists.
You'll have to create a different Ref Update action for each separate table involved - one for each table.
I would be careful with these updates back and forth like this though... it's really easy to end up with hundreds of "pointless" updates made back and forth.
- Whenever I need to do something like this, I'll make sure I identify some sort of criteria I can put into the condition space; that way the updates only run they they need too vs. all the time.
Great video. Very helpful.
Got an added wrinkle that I'm working out. I have 2 columns of enumlist data that I would like to put into the same final list.
How would I augment the process steps to make this work?
Simply add the two lists together inside your "Remaining Items" list:
help.appsheet.com/en/articles/4575684-list-addition
Amazing explanation!
I'm trying to make an iterative calculation and could be possible to do it with a looping action, but I got missed in how to do it as you explained in the video.
Here's the thing! I have field which calculate a loan's mount and for that the calculation must consider the amount of the disbursement plus expenditure costs, and the expenditure costs must be calculated using the loan's mount multiplied by the expenditure percent. This turns into a looping calculation, but it could be ended at the 100th step.
Is there an easy way to do it?
I feel like there's some faulty logic happening here.... perhaps the solution would be to include another variable, like a "Starting Amount" and another "Final Amount" or something?
Did you ever get this working?
Very good. Thanks bro. When we select multi product with quantity. How can i do ?
If you're trying to assign the same qty for each product, just include that column inside the columns to set for the action that actually makes the record.
If you're trying to assign DIFFERENT qtys to each product, you'll need to not use this method and instead loop through forms.
@@MultitechVisions Thats sound nice. TKs Bro
Hi . Amazing video - everything work perfectly fine - I can automatically add new rows with new data with the loop = but, except - now my SYNC PROCESS takes forever . What maybe the reason for the stalling of SYNC to the datasource?
The problem you're likely running into is related to the difference between "client-side" and "server-side" in appsheet:
- ruclips.net/video/sDS8l7k-2cY/видео.html
Great video!! I'm a rookie and still don't get the action thing! haha. I've got products, orders and detail and haven't been able to update de product stock qty any time I put the order status to "approved". Any ideas or some video I should watch?? thanks so much for your great work, keep it up!!!!!!!
Glad it was helpful! Unfortunately right now there is limited resources on this topic.
- But honestly... that sort of build methodology carries with it an extra burden of having to "manage the qty update"
- Instead you can create your inventory count as a VC inside AppSheet, this way it's always updated based on the data in the system.
(Added to the list - I'm thinking a Part 2 to the Shopping Cart video will include something like a "current quantity" count for items.)
----------------------------------| A little bit of insight
The reason people don't think to go this route is typically because they're likely still using Spreadsheets as a data interface - they've yet to see the true power of AppSheet, and still see spreadsheets as useful. So they're trying to build their sheets/columns so that things make sense wile looking at them in the sheet.
- Eventually though, you'll find the usefulness of spreadsheets will diminish, as the true power of AppSheet becomes apparent and available to you.
- Once you reach this point, the spreadsheet becomes nothing more than a data repository - and then ideas like "maintaining a physical column for something that should be virtual" isn't a barrier anymore.
@@MultitechVisions Yes! Agree Thanks for your time
My app freezes after modifying the 'Event Actions" to the Loop Create Action in the Orders Form View (after saving a new order) ( 25:00 ). Please help :(
Hello Omar. To better help troubleshoot the problem, and to bring in additional experts such as myself, please head on over to community.appsheet.com/t/looping-with-actions-sample-app-build-video and investigate further there.
@@MultitechVisions will do, thanks
whenever we fill data in apsht, if data is repeated we showing only one entry... any one help me for solve it . i am just beginner
You might be hitting the "edit" button instead of the "New" button; if you head on over to community.appsheet.com/ that's a better place to get assistance. ;)
I don't know what Im doing wrong. I did exactly what you showed, except instead of putting it as an action in firm saved, I had it as a prominent button.
When I execute the group, my app freezes. It's like consuming all my pc memory.
Check the condition; what's happening here is the condition formula you've got doesn't result in an end - meaning it's an infinite loop.
Hey guys. Im sorry Im the newbie, but my repeater isnt repeating. I get an error "There is already a row with the key '12/30/1899 19:05:50'". Maybe I zigged when I should have zagged??
You can run into this problem when you're using a DateTime as your ID value. Try using UniqueID() instead, that should solve your problem.
Ultimately what's happening here is that all the items are being created so fast that they can share a timestamp (since datetime rounds to the second) - which causes two records to have the same ID... which you can't do.
Music.. 😰
What do you mean???