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
+919855089359
Thanks Sunny. I will research Record Rules within the Form Rules feature.
1 Like