I have an instance of an Object, which has the variables
type = x, number_of_exams = 2, previous_no_of_exams = 0.
In the next instance of the object, of the same type = x, I want the previous_no_of_exams to be = to 2, number_of_exams = 0.
So when an instance of the same object is created, I want it to check any previous record of that object, type 'x' and get the number_of_exams value and assign it to the new object instance's previous_no_of_exams variable.
Can this be done without APEX or triggers?.
Maybe through workflows or process automation?