Can A New Recorded Be Created Automatically When A Field Is Change?

Hello Vince,


Yes possible. Create two more field one with same datatype other is formula field .

if both field not match then formula field showing "No". Then you can create a record using form rule .

and Update new field with same value .



Field1->"Value1" Existing field

Field2->"Value1" (Create new field update each time )

Field3->"Yes" (Compare Field1=field2") Formula field 

after update Field1->"Value2" 


Field3->"No" -> Create Record and then update Field2->"Value2" using Field1



Sunny Singla