I posted a related question a couple of weeks ago, and was able to implement the Script Block (Add new (semi-duplicate) record when checkbox selected) - super awesome, and THANK YOU!
Here is what i need to do next:
Current Item Title
Current Item Desc
Curr Editor Item Title Direction
Curr Editor Item Desc Direction
Curr Editor Item Title Modified
Curr Editor Item Desc Modified
Curr Edits Complete (checkmark box)
Curr Edits Implemented (checkmark box)
Each item is updated monthly. I need to copy the existing record to a NEW record, over writing the CURRENT TITLE/DESC with the MODIFIED TITLE/DESC, while also clearing out the “direction” fields, “modified” fields and the “Complete” & “Implemented” checkmark boxes.
The script from the last solution creates a duplicate record, but doesn’t move/clear out certain fields.
What’s the easiest way to implement something like this. I’m managing hundreds of items a month, and do it manually is both time consuming and leaves so much room for human error…