Question how do i get a workflow to work when...

(Segolene Sansom) #1

Question how do i get a workflow to work when a child/related record gets updated? I can’t seem to find the documentation to do it or any posts for it so if someone knows how, it will be much appreciated.

(Aleksi Alkio) #2

I believe the easiest solution could be an action with a suitable condition check.

(Segolene Sansom) #3

@Aleksi_Alkio how would I go about doing that?

(Aleksi Alkio) #4

Or… reading the last DateTime value from your child records with the virtual column and then trigger the workflow if the MAX DateTime value is changed.

(Aleksi Alkio) #5

If you have a DateTime field in your child table with an appformula NOW(), you can then read the max value with the virtual app formula like MAX(SELECT([VirtualColumnList][DateTime],TRUE)). If this virtual column name is [MAX], you could fire the workflow with a formula like AND(ISNOTBLANK([MAX]),[_THISROW_BEFORE].[MAX]<>[_THISROW_AFTER].[MAX])

1 Like
(Segolene Sansom) #6

ok i got everything except the condition on the workflow - and i guess if i dont put a condition it will seriously increase the sync time if i just left it to all changes with max value updating…right?

(Aleksi Alkio) #7

That’s correct. If you need to check only few columns in your child record, instead of using normal app formula, you should think about the ChangeTimestamp field because with that you can control columns.