0

I have a custom object. When receiving a second line item on that custom object I want a check box field to be updated to true.

I have tried using workflow rule but I couldn't find any relation for the 2nd line item.

Any suggestions? Maybe a trigger but how to lock the 1st line item and fire the trigger when the 2nd line item is in place

I am editing this to give more info. The custom object has a master detail relationship with Contacts. I then created a custom field on contacts(checkbox) where I want this to become true when a second record is on the custom object. I have then created a roll up field that counts that custom object's records and created a workflow rule where rollupfield>1 and the action was a field update of my checkbox to true, BUT still getting unchecked buttonenter image description here

  • howz ur custom object & line item related ? r they using master detail relationship ? – Vamsi Krishna Feb 19 '15 at 11:15
  • @Vamsi Krishna The custom object has a standard field for example res.id. After that I created all the necessary fields that with a number on the res.id the line item is filled. The custom object has a master detail relation with Contacts and the field that I want to update is a custom checkbox on Contacts – Tommy Georgiou Feb 19 '15 at 12:01
0

If you are using a rollup field to count the related objects I would use a formula field checkbox on the Contact that is true when the rollup field is greater than 1.

  • Good one. But what happens if I want 2 criterias. Like when rollupfield>1 and ResStatus(from the jpeg above)=Confirmed for the checkbox to become true? – Tommy Georgiou Feb 19 '15 at 13:43
0

So after a help from Geoffrey Flynn,

1)Roll up field on the master object to count the records. Filter on the rollup field to get the status. 2) Workflow on the master object with evaluation at created and everytime edited and a formula where rollupfield>1 3) Then a field update action where you update the checkbox to true

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.