Trying to figure out whether using a dereference or creating an action to update one table from another table is better.
I have two tables,
Currently as an inspection takes place, [Date Inspected] and [Next Inspection] related to a specific [Equipment ID], columns are added to new inspection row, this happens for every new inspection and a row is added. However I want to also have these new dates for the relevant Equipment ID ie [Previous Inspection] and [Next Inspection], update and show in the Equipment table too.
Thus I can either create a dereference to the most recent inspection for that [Equipment ID] (not sure of a formula for this on the dereference formula input, it would need some sort of constraint for the most recent inspection/row for that specific Equipment ID). (might affect sync time)
Option 2, is to create a workflow update each time an inspection related to a particular [Equipment ID] takes place, it updates the [Previous Inspection] Date & [Next Inspection] date in the Equipment table for those two columns too. I prefer option 2.
However the issue I am experiencing, is that I have to create two actions for the workflow. The workflow,
any input or better way of doing this would be appreciated, thank in advance.
Solved! Go to Solution.
I believe you may create Referenced rows expression as
SELECT(Equipment[Equipment ID], [Equipment ID]=[_THISROW].[Equipment ID]) in โInspection Update Trigger (Inspections)โ action.
Also instead of workflow, is it possibe for you to trigger the โInspection Update Trigger (Inspections)โ action as an evernt action on inspections form save ?
I believe you may create Referenced rows expression as
SELECT(Equipment[Equipment ID], [Equipment ID]=[_THISROW].[Equipment ID]) in โInspection Update Trigger (Inspections)โ action.
Also instead of workflow, is it possibe for you to trigger the โInspection Update Trigger (Inspections)โ action as an evernt action on inspections form save ?
This worked 100%, thanks again for the awesome help @Suvrutt_Gurjar !
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |