Need to copy value in one field to another when a status field changes all within the same record
I have a parent table (Projects) and a child table (Ops). Ultimately, what I want to happen is when the "Status" of a record in the parent table changes from "Not Started" to "In-Progress", then the d...
I tried this, but the automation will only allow me to copy values from the Projects table to the Ops table - I need to copy a value from Ops to another field also in Ops