@Phil
@Aleksi
Master Table contains child table records.
Master Table has one formula field and value as initially โIncompleteโ and once the child table records completed, the formula filed value will change as โCompletedโ.
I set a workflow on Master Table with โALL_CHANGESโ and tried with different type of conditions like
[Inspection Status] = โCompletedโ
AND(
[_THISROW_BEFORE].[Inspection Status]<> [_THISROW_AFTER].[Inspection Status],
[_THISROW].[Inspection Status] = โCompletedโ
)
There is no system error but workflow not triggered when the value has been changed. In Audit log, there is no such event occurred.
The below is the formula to set value for โInspection Statusโ.
IF(COUNT(SELECT(Inspection Template[Checkpoint], [Fleet Type]= [_THISROW].[Fleet Type])) = [Questions Attended], โCompletedโ, โIncompleteโ)
Please advise.
Solved! Go to Solution.
Instead of triggering the workflow rule based on a update to the Master Table, why not trigger it on changes to the Inspection Template table? If I understand correctly, it is the completion of the last of those inspections that seems to be the real triggering event.
Instead of triggering the workflow rule based on a update to the Master Table, why not trigger it on changes to the Inspection Template table? If I understand correctly, it is the completion of the last of those inspections that seems to be the real triggering event.
Indeed, you are right. The child table has no. of questions for the particular inspection record from the Master Table. The no. of questions may vary depends on the equipment type. If i make a workflow on the child table, is it correct way to do that? If so, can you tell me the logic to be applied?
Thanks.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |