Perfect, I was looking for a way to do it and with great simplicity you brought the divine solution. Thank you for sharing and I wish you much success. Congratulations👏
Thanks Matt, helped me to complete a Master-->Child app, with generated child records, which were then updated en masse to feed an email bot on change event for doing emails to each child email column. Good to mention order-of-operations, it helps me to understand the event model of appsheet, which I'm new to.
Hi Matt I have run into an infinite loop problem in automations & have been unable to resolve it in automations. I have solved it using client side action looping. This works using the same logic on the "Behaviour" however if I use automations for the looping I get an infinite loop. Simple scenario description: From the Suppliers table I am trying to create Venue_Suppliers in the Venue_Supplier table. The process: Activate the "Hot Linking" tapping the icon next to the Venue name for the destination. You can choose multiple venues. These are held in a slice. Then you select the Supplier you want copied to the Venue_Supplier table. The Supplier selected is held in a slice. The looping action is part of the stack of actions that kick off when you select the Supplier. My logic for the Behaviour condition on the looping set of actions is "COUNT([Remaining Venue_Suppliers]) > 0" the reason I am using this is, I figure once all the Venue_Suppliers are created the Remaining Venue_Suppliers list should be 0 (there is always another way!). The process runs fine client side, but moving the process to automations results in the infinite loop recreating the very first Supplier_Venue record again & again. I think it has something to do with the value for the link_Venue value I am using in the "Make" loop action. This is the action that creates the Supplier_Venue record. My formula for this field is Index(Destination Venue_Supplier Copy Supplier[Venue_ID],1) where the Destination Venue_Supplier Copy Supplier is the slice holding the selected Venues who need the Venue_Suppliers created. How do I get the value to change on each iteration of the loop to the next venue in the lists venue_ID? I think that may be something causing the issue! Thanks for all the tremendous content & I look forward to seeing the simple solution you come up with!! PS I have tried changing the formula for the link_Venue value to INDEX([Remaining Venue_Suppliers],1) this works on the client side loops, but again moving to automations this generates the same result I mentioned earlier. First venue record in the list has the Venue_Supplier created hundreds of times. Cheers
I have the same issue. For now, I think I might just make 2 bots that trigger each other and have the option "Wait for execution to complete" unchecked for both so that each bot syncs back to the database and reduces the list of the items to be created. Unless Matt has another option :)
Hey Matt, thanks a lot for you content. In terms of efficiency would you pick this method instead of the “remaining products list” you teach in the other videos? You could use the count to change your index of the list items and stop when it reaches the total amount of items in the list.
Absolutely! There's really no "one size fits all" solution for looping like this; it's really dependent on the actual implementation you're doing. In this instance I simply needed to create X number of records, and this was the path that got me there. :) I could have easily taken this route, or a couple of others - all would get me to the same place, provided the logic is setup correctly.
I've followed this before with great results, but today I get an error on the repeat. "The value '=LIST([_THISROW])' of data action 'labelRepeat' does not match the expected type List or its expected type details" I'm totally stumped.
In instances like this, I prefer to NOT automatically delete the records. - But you're right, if you wanted to, you could add in a delete action right after the creation loop.
Hi Sir do you have a tutorial about if the data table is status and the columun value is completed and it will not be editable or unable to update. what possible expresion should i use for this sir. Thanks sir, god bless. sample but not working : IF(ANY(Ticket[Status]='Closed', TRUE, [Email]=USEREMAIL()))
There are many ways you might go about this; I address a few in this video: ruclips.net/video/p0b2FuIwrjI/видео.html You can also find another video here (ruclips.net/video/ry5MqgraVSw/видео.html) that might help
i've build a loop by actions, but coun't limited the number of repets. In my case, the loop criated a number infinit of new rows in other table. I know what I need to do and where, but I couldn't build an effective formula. Someone here can help me?
Loops are definitely something that can be tricky to get right. The key is to make sure you've got a formula inside the looping actions that will eventually come to a "stop" - that's where the list subtraction stuff comes into play. IsNotBlank( [Items_To_Make] - [Related Items][Item_Made] ) Without something like this (which eventually evaluates to true when all the items have been made) the system will run infinitely. - These formulas can be difficult to get right - You might reach out for help here: www.MultiTechVisions.com/answers
Matt you're a gifted trainer. Always impressed with your work.
Thanks so much!
This were really helpful. Thank you so much for share your knowledge. One more subscriber!!
Thanks it has helped me a lot
Perfect, I was looking for a way to do it and with great simplicity you brought the divine solution. Thank you for sharing and I wish you much success. Congratulations👏
Thanks Matt, helped me to complete a Master-->Child app, with generated child records, which were then updated en masse to feed an email bot on change event for doing emails to each child email column. Good to mention order-of-operations, it helps me to understand the event model of appsheet, which I'm new to.
This was extremely helpful! Well done. Thanks.
Hi Matt
I have run into an infinite loop problem in automations & have been unable to resolve it in automations. I have solved it using client side action looping. This works using the same logic on the "Behaviour" however if I use automations for the looping I get an infinite loop. Simple scenario description: From the Suppliers table I am trying to create Venue_Suppliers in the Venue_Supplier table. The process: Activate the "Hot Linking" tapping the icon next to the Venue name for the destination. You can choose multiple venues. These are held in a slice. Then you select the Supplier you want copied to the Venue_Supplier table. The Supplier selected is held in a slice. The looping action is part of the stack of actions that kick off when you select the Supplier. My logic for the Behaviour condition on the looping set of actions is "COUNT([Remaining Venue_Suppliers]) > 0" the reason I am using this is, I figure once all the Venue_Suppliers are created the Remaining Venue_Suppliers list should be 0 (there is always another way!). The process runs fine client side, but moving the process to automations results in the infinite loop recreating the very first Supplier_Venue record again & again.
I think it has something to do with the value for the link_Venue value I am using in the "Make" loop action. This is the action that creates the Supplier_Venue record. My formula for this field is Index(Destination Venue_Supplier Copy Supplier[Venue_ID],1) where the Destination Venue_Supplier Copy Supplier is the slice holding the selected Venues who need the Venue_Suppliers created. How do I get the value to change on each iteration of the loop to the next venue in the lists venue_ID? I think that may be something causing the issue!
Thanks for all the tremendous content & I look forward to seeing the simple solution you come up with!!
PS I have tried changing the formula for the link_Venue value to INDEX([Remaining Venue_Suppliers],1) this works on the client side loops, but again moving to automations this generates the same result I mentioned earlier. First venue record in the list has the Venue_Supplier created hundreds of times. Cheers
I have the same issue. For now, I think I might just make 2 bots that trigger each other and have the option "Wait for execution to complete" unchecked for both so that each bot syncs back to the database and reduces the list of the items to be created. Unless Matt has another option :)
Thanks, Matt!
Great video! Would be awesome to also show the inside of the Sync Action.
You can find more here: ruclips.net/video/p0b2FuIwrjI/видео.html
Hey Matt, thanks a lot for you content. In terms of efficiency would you pick this method instead of the “remaining products list” you teach in the other videos?
You could use the count to change your index of the list items and stop when it reaches the total amount of items in the list.
Absolutely! There's really no "one size fits all" solution for looping like this; it's really dependent on the actual implementation you're doing. In this instance I simply needed to create X number of records, and this was the path that got me there. :) I could have easily taken this route, or a couple of others - all would get me to the same place, provided the logic is setup correctly.
Awesome
I've followed this before with great results, but today I get an error on the repeat. "The value '=LIST([_THISROW])' of data action 'labelRepeat' does not match the expected type List or its expected type details" I'm totally stumped.
also important adding an action to delete the extra rooms if the new number is less than the current
Cheers mate! You're 100% correct! ruclips.net/video/p0b2FuIwrjI/видео.html
What if they decrease the amount of rooms and you need to delete?
In instances like this, I prefer to NOT automatically delete the records.
- But you're right, if you wanted to, you could add in a delete action right after the creation loop.
Hi Sir do you have a tutorial about if the data table is status and the columun value is completed and it will not be editable or unable to update. what possible expresion should i use for this sir. Thanks sir, god bless.
sample but not working : IF(ANY(Ticket[Status]='Closed', TRUE, [Email]=USEREMAIL()))
There are many ways you might go about this; I address a few in this video: ruclips.net/video/p0b2FuIwrjI/видео.html
You can also find another video here (ruclips.net/video/ry5MqgraVSw/видео.html) that might help
i've build a loop by actions, but coun't limited the number of repets. In my case, the loop criated a number infinit of new rows in other table.
I know what I need to do and where, but I couldn't build an effective formula.
Someone here can help me?
Loops are definitely something that can be tricky to get right. The key is to make sure you've got a formula inside the looping actions that will eventually come to a "stop" - that's where the list subtraction stuff comes into play.
IsNotBlank(
[Items_To_Make]
- [Related Items][Item_Made]
)
Without something like this (which eventually evaluates to true when all the items have been made) the system will run infinitely.
- These formulas can be difficult to get right
- You might reach out for help here: www.MultiTechVisions.com/answers