@@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.)
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.
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! 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!
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?
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.
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.
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?
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: - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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.
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.
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.
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 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. ;)
