New to Notion and Make with beginner background in coding so forgive my simple question and would appreciate a layman explanation!
I have 2 independent databases, namely the “Master Database” and 'Engineer Database".
I have already devised an automation on Make where the “Engineer Database” will periodically feed information (rows) into the “Master Database”. The screenshot below shows the “Master Database” fed from “Engineers Database”.
From here, what I need is that whenever a manager updates the “status” (it is a Select property) of a specific row, from Raised to any other Status value, Make will automatically delete that specific row only in “Engineer Database”. Below is an example of the “Engineer Database”
From the 2 pictures above, it is noted that the Manager has updated B001, B002 and D001 into any status other than ‘Raised’, but in ‘Engineer’s Database’, the affected data is only B001 and D001, so I want to create a workflow that only deletes B001 and D001 and remain A001 because its status remained as “Raised” and has not been updated to any other Status.
Below is the overview of the workflow module on what I’ve done and the problem I’ve encountered.
When I run the workflow above, it deletes all 3 rows; B001, D001 and A001 so I suspect the filter I set up in module 2 (Search Object) is wrong, but I just don’t know what is wrong and what to key in to make it right. Below is the Settings in Module 2.
I only want Make to delete the row in “engineer database” if Status is not equal to “Raised” in Master Database.
Sorry for the long explanation and any help is appreciated!