We have 2-objects called A,B and A is the parent and B is child. We need to update X-field value(Date data type) on B object with A object's Y-field value(Date) whenever A-object's STATUS changes to certain values(pick list) . Can we achieve this by using formula field. I'm bit confuse to choose correct solution.Please help me here.Thanks.

  • This is not very clear on your data model. Which object as a lookup to which object? Which is the parent and which is the child? – David Reed Sep 10 '18 at 21:00
  • Hi @DavidReed ,updated my query accordingly – User1511 Sep 10 '18 at 21:06

If I understand you correctly, you have a Date value field on both the parent and child, and you want to update the value on the child if and only if another field on the parent is changed. You do not want the fields to be kept in sync otherwise.

If this is correct, you cannot use a formula field, because formula fields are always "live" connections. They do not store values; they are calculated at the time of viewing the record based on their formulae.

If your records have a master-detail relationship, you can use a Process on the parent object to update field values on all of its children based on criteria that you specify. Your process can run whenever the parent object is modified and perform Date updates only when your picklist field contains specific values.

  • Yes @DavidReed,your understanding is correct.As you mentioned Process means Process builder ? – User1511 Sep 10 '18 at 21:32
  • Yes, Process Builder. – David Reed Sep 10 '18 at 21:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.