KRRRRRAAAAAZY!!!!!! Matt, you are the MAN!...this is an incredible insight into a very much needed workaround! As the saying goes 'Once the problem is solved, it appears simple'.....thank you soooo much for this! keep scmilin'!
Hey Matt, this is such a cool function. I didn't even realise how powerful this was when we first worked through this but since then I've used it in three apps already. Thanks for the awesome work!
I'm going to try this tomorrow! 🥰 I have been deleting parent and re-starting orders again, only to fix this issue by hand 🖐️. I saw Qnty change, I believe this will help me.
Thanks Matt, very helpfull tutorial. But how to update child record from parent using the same method..im kinda lose track in " list([OrderDetail_Order_Link]) " part...can you elaborate more, thanks a lot
Did you see episode 17? (I'm trailing behind with my timestamps, but there's a section in there where I answer this question) - th-cam.com/video/f9nZV8WEN5w/w-d-xo.html Thanks for the good question!
Hey hey! Yes you need to include the LIST() portion inside the action like that; that space inside the action is looking for a list of records, so when you pass it one record ID you must convert the single value into a list... with a single value. (^_^)
In order to get things to work on the delete, you have to either implement a system client-side to handle certain order of operations... - Or implement the update via automation (on the delete event of the child record) I got the automation route, even though it means your user has to wait for the background sync in order to get the info.
your presentation is very nice .... but the result at that time not future proof 😂 You forgot something important !!!! whatif ... a child is deleted ? OK you will now say ... i have to put out system actions .... but how to delete then a child ? If i delete it ( not systemmenue ) manually with a group of actions, there is a problem. i can not execute an action on an deleted row.
Just used this to fix an issue with a Customer Enquiries App that has been holding me up for ages!. Many thanks once again Matt........
KRRRRRAAAAAZY!!!!!! Matt, you are the MAN!...this is an incredible insight into a very much needed workaround! As the saying goes 'Once the problem is solved, it appears simple'.....thank you soooo much for this! keep scmilin'!
Hey Matt, this is such a cool function. I didn't even realise how powerful this was when we first worked through this but since then I've used it in three apps already. Thanks for the awesome work!
Tip of the ice-burg mate (^_^)
Fantástic,Congrats Man, Hello from Barcelona
Cheers!
Thanks Matt! Your AppSheet content is fantastic!
Thank you so much!
Thanks, Matt! Good tip on Grouping the action to future proof the system. I literally ran into that problem yesterday!
I'm always trying to future proof!
I'm going to try this tomorrow! 🥰 I have been deleting parent and re-starting orders again, only to fix this issue by hand 🖐️. I saw Qnty change, I believe this will help me.
Great video, very good explanation
Thank you!
Happy Birthday dear Matt !
🎉
Hi, what function did you use on the parent table to calculate the child record?
This is great Matt, thanks again. I've been struggling for some time to solve this update issue.
Thanks Matt, very helpfull tutorial. But how to update child record from parent using the same method..im kinda lose track in " list([OrderDetail_Order_Link]) " part...can you elaborate more, thanks a lot
Did you see episode 17? (I'm trailing behind with my timestamps, but there's a section in there where I answer this question)
- th-cam.com/video/f9nZV8WEN5w/w-d-xo.html
Thanks for the good question!
Hi Matt can you explain bit more on " list([OrderDetail_Order_Link]) " , is "List" Type row in OrderDetails a must? video time stamp is 3.42
Hey hey! Yes you need to include the LIST() portion inside the action like that; that space inside the action is looking for a list of records, so when you pass it one record ID you must convert the single value into a list... with a single value. (^_^)
@@MultitechVisions thanks Matt.
Does this work on deleting the child record too? Thanks for your awesome content Matt, Cheers from India.
In order to get things to work on the delete, you have to either implement a system client-side to handle certain order of operations...
- Or implement the update via automation (on the delete event of the child record)
I got the automation route, even though it means your user has to wait for the background sync in order to get the info.
does this still work? seems like my other columns are not calculating the app formula but the update keeps going up :(
What happens when someone else is editing that parent record when you've updated the parent via the child record?
your presentation is very nice .... but the result at that time not future proof 😂 You forgot something important !!!! whatif ... a child is deleted ? OK you will now say ... i have to put out system actions .... but how to delete then a child ?
If i delete it ( not systemmenue ) manually with a group of actions, there is a problem. i can not execute an action on an deleted row.