How do i create a workflow with target data named โDetailsโ with the โIf this is trueโ condition is depends on the column that is exist on table named โPMCโ.
Table โDetailsโ contain column: ID, Name, Date, address.
While table โPMCโ contain column: PMC date, Status, Need corrective action?.
So that the workflow will generate a notification with the โDetailsโ detail in the notification, only when column โNeed corrective actionโ is equal to โyesโ.
Solved! Go to Solution.
The reason is probably missing [_THISROW]โฆ
LOOKUP([_THISROW].[ID],โPMC detailโ,โPMC IDโ,โNeed corrective action?โ)=โYesโ
You can use LOOKUP() expression but first you need to have some kind of relationship so you can find the correct record from the PMC table. Are you using a REF field?
Not sure but this might help
How many PMC records can you have that belongs to Detail record?
At least this could workโฆ IN(TRUE,[Related PMCs][Need corrective action])
LOOKUP([ID],โPMC detailโ,โPMC IDโ,โNeed corrective action?โ)=โYesโ
the formula is correct but it does not trigger the workflow, where did i do wrong?
The reason is probably missing [_THISROW]โฆ
LOOKUP([_THISROW].[ID],โPMC detailโ,โPMC IDโ,โNeed corrective action?โ)=โYesโ
Thank you
Youโre welcome
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |