Tap to unmute

Quick Update System | How to Update Parent from Child Update | AppSheet Explained

  Рет қаралды 5,857

MultiTech Visions

MultiTech Visions

Күн бұрын

Пікірлер: 27
@markwilhelm1304
@markwilhelm1304 Жыл бұрын
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........
@markwilhelm1304
@markwilhelm1304 Жыл бұрын
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'!
@jaredmazzis9930
@jaredmazzis9930 2 жыл бұрын
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!
@MultitechVisions
@MultitechVisions 2 жыл бұрын
Tip of the ice-burg mate (^_^)
@adevela
@adevela 2 жыл бұрын
Fantástic,Congrats Man, Hello from Barcelona
@MultitechVisions
@MultitechVisions 2 жыл бұрын
Cheers!
@hamvasq
@hamvasq 2 жыл бұрын
Thanks, Matt! Good tip on Grouping the action to future proof the system. I literally ran into that problem yesterday!
@MultitechVisions
@MultitechVisions 2 жыл бұрын
I'm always trying to future proof!
@bradlegassick9327
@bradlegassick9327 2 жыл бұрын
Thanks Matt! Your AppSheet content is fantastic!
@MultitechVisions
@MultitechVisions 2 жыл бұрын
Thank you so much!
Жыл бұрын
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.
@עמירצין
@עמירצין 2 жыл бұрын
Hi, what function did you use on the parent table to calculate the child record?
@franciscosb4588
@franciscosb4588 2 жыл бұрын
Great video, very good explanation
@MultitechVisions
@MultitechVisions 2 жыл бұрын
Thank you!
@kjshskjs2209
@kjshskjs2209 2 жыл бұрын
Happy Birthday dear Matt !
@MultitechVisions
@MultitechVisions 2 жыл бұрын
🎉
@eloy001
@eloy001 2 жыл бұрын
This is great Matt, thanks again. I've been struggling for some time to solve this update issue.
@chandralim5860
@chandralim5860 2 жыл бұрын
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
@MultitechVisions
@MultitechVisions 2 жыл бұрын
Did you see episode 17? (I'm trailing behind with my timestamps, but there's a section in there where I answer this question) - kzbin.info/www/bejne/nGrRi4lujKqBa9k Thanks for the good question!
@SnooniSnoo
@SnooniSnoo Жыл бұрын
does this still work? seems like my other columns are not calculating the app formula but the update keeps going up :(
@dulipkar4758
@dulipkar4758 2 жыл бұрын
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
@MultitechVisions
@MultitechVisions 2 жыл бұрын
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. (^_^)
@dulipkar4758
@dulipkar4758 2 жыл бұрын
@@MultitechVisions thanks Matt.
@kunaljainx
@kunaljainx 2 жыл бұрын
Does this work on deleting the child record too? Thanks for your awesome content Matt, Cheers from India.
@MultitechVisions
@MultitechVisions 2 жыл бұрын
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.
@ncd9437
@ncd9437 2 жыл бұрын
What happens when someone else is editing that parent record when you've updated the parent via the child record?
@AlberichRheinmann
@AlberichRheinmann 11 ай бұрын
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.
Looping with Actions (Do-While & For Loops in AppSheet)  |  BUILD VIDEO
41:08
AppSheet Copy Child Records To Another Table
17:55
Joe Tayactac
Рет қаралды 8 М.
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
1% vs 100% #beatbox #tiktok
01:10
BeatboxJCOP
Рет қаралды 67 МЛН
Duplicate Inline Views (with different types)  ||  AppSheet Explained
10:38
Report Table [BUILD]  |  Foundation
50:00
MultiTech Visions
Рет қаралды 4,1 М.
AppSheet Update All Child Records When Parent Record is Updated
27:57
Take control over the 'Add' button | AppSheet Explained
16:43
MultiTech Visions
Рет қаралды 9 М.
Establishing Parent-Child Relationships or References in AppSheet
5:01
Appify Your Business
Рет қаралды 15 М.
How to Create Dependent Dropdown Lists in AppSheet ! Appsheet Dropdown List
9:12
Business Automation with Appsheet
Рет қаралды 277
Action Looping - As Easy As 1-2-3  ||  AppSheet Explained
8:46
MultiTech Visions
Рет қаралды 8 М.
AppSheet Add Rows To Another Table From EnumList
16:59
Joe Tayactac
Рет қаралды 14 М.
Building Strong Connections with Many-to-Many in AppSheet
22:54
Full Of Sheets
Рет қаралды 6 М.
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН