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

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

I would like to have a new record automatically created when a field is changed.  Is that possible?

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 .

 

Ex.

Field1->"Value1" Existing field

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

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

after update Field1->"Value2" 

Field2->"Value1"

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

 

Regards,

Sunny Singla

ssingla1985@gmail.com

+919855089359