You need to sign in to do that
Don't have an account?
Olavo Zapata
Update child records Lookup ID from parent using Process Builder
Hello guys,
I have a custom object that I need to update it via API with our product's information.
For this, we create an Object ('Tests1intgre') with an External ID ("RDStationID") that the external ID also exists in the Account object.
My question is, how to reference these objects? There is already a Lookup Relationship field of the Account in the Test object.
What I tried was to create a process builder to identify the RD Station ID in the 2 objects and bring me the account into the test object.
However, show me that it isn't possible to register.
Process Builder print 1: http://prntscr.com/jxbqme
Process Builder print 2: http://prntscr.com/jxbq5v
I hope you can help me. Thanks,
I have a custom object that I need to update it via API with our product's information.
For this, we create an Object ('Tests1intgre') with an External ID ("RDStationID") that the external ID also exists in the Account object.
My question is, how to reference these objects? There is already a Lookup Relationship field of the Account in the Test object.
What I tried was to create a process builder to identify the RD Station ID in the 2 objects and bring me the account into the test object.
However, show me that it isn't possible to register.
Process Builder print 1: http://prntscr.com/jxbqme
Process Builder print 2: http://prntscr.com/jxbq5v
I hope you can help me. Thanks,
Try this
All Answers
When RDStationID gets updated via API, you wanted the same value get updated on the Account Level.
Confirming:
- Tests1intgre (Custom Object)
- AccountId (Lookup Account)
- RDStationID (External ID)
- Account (Standard Object)
- RDStationID (External ID)
What I want is when the RDStationID gets updated via API in the Test object a process automatically insert de AccountID in Test Object as well to make the lookup.If that is true then what is my filter point of selecting which Account to pick?
What is you process of updating the RDStationID via API for example a trigger or a webservice etc. Can you share?
I could update both in the same time RDStationID and AccountID, but in our product (what will send the information) we don't have SFDC Account ID So we would need to first match the RDStationID in Account to get back the AccountID and after save to Test Object both in the same time.
I would like to request the API just one-time, upserting information and not just selecting the Account ID.
Just sharing my connections is almost like this:
The issue here is that you want to update the AccountId on the custom Object Test1intgre based on RDStationID__c which are basically linked with Account. This is what I understood.
Keeping this perspective I don't think you can achieve that through Process builder because you need to match the Tests1intgre record to the Account record based on RDStationID in order to get the AccountId. You can only do that through Referencing AccountId on Tests1intgre object but that value is null which is actually you wanted to update. The process builder will fail because of the AccountId null, which make sense.
For now I think you can do that through triigger and here is that. Not sure if you want to go through this route
First of all, I would like to say many thanks for your attention.
My application is in Ruby because this is a bit different. Anyway, you are completely right with my intentions to update the AccountId on the Custom Object.
But from what I understood of your code, the logic is basically what I have today in my integration.
The combining of account and rdstationID fields are done externally, not in Salesforce.
What I would like to try is for Salesforce to do this.
That when I enter my External ID into a custom object it checks the account for the respective accountID and writes this to me in the custom object.
The benefits I see are:
Reduced connection to the API.
Performance Improvement, avoiding getting access to the Account to get the ID I can be writing to different objects in parallel.
I can't believe it is not possible to do this. Even if it is not for Process Builder there must be some way.
What I would like to try is for Salesforce to do this.
That when I enter my External ID into a custom object it checks the account for the respective accountID and writes this to me in the custom object.
Now I understood what you mean.
You are suggesting to do trough Trigger Apex, aren't you?
I'm totally newbie in this feature, I taught your suggestion was to try something similar in our integration side.
I will get to study the apex and try your code.
Thanks for the moment.
I tried you trigger in the Test1 Object.
But when I tried to insert a new record shows me a warning message: So I tried many combinations to try to fix it but I didn't understand what happened.
Have any idea what could be?
Thanks.
Try this
Abdul works perfectly! It was exactly what I was looking for.
You were amazing!
Thanks a lot for that man.