You need to sign in to do that
Don't have an account?
Glenn Nyhan 54
Cross Object Formula Solution
Not sure why I'm having trouble with this but here goes. I am trying to create a Cross Object formula which is a simple one, but don't seem to be getting it right.
I have two related objects the Contact object with a related object called Board Member Tracking. On the Board Member Tracking object there is a section called Member Position and Service Duration which has 10 individual picklists, one for each type of Board Member. I've been asked to make the contents of these fields visible on the Contact object, so they can be used in creating List Views that show those results. I can't seem to get this to work. Can anyone help with the solution and an example of how this can be executed as a Cross Object formula. Thanks in advance.
I have two related objects the Contact object with a related object called Board Member Tracking. On the Board Member Tracking object there is a section called Member Position and Service Duration which has 10 individual picklists, one for each type of Board Member. I've been asked to make the contents of these fields visible on the Contact object, so they can be used in creating List Views that show those results. I can't seem to get this to work. Can anyone help with the solution and an example of how this can be executed as a Cross Object formula. Thanks in advance.
If there is a lookup relationship between the contact and Guest student information object you cannot populate the Arrival date on contact with formula field.Best option is to create a process builder on guest student information object and in that process builder you can action to field update(GuestStudent__r.ArrivalDate__c). It worked for me. Let me know if you have any questions.
All Answers
Thanks!
Thanks for you're reply. My boss has decided she wanted it done another way, so we have abandon this. But I do have another question. Is it not possible to create a formula field from the Parent object to the Child object? I have a Contact related object called Guest Students Information. On that object is a date field called Arrival Date. I wanted to pull that date field info over to the Contact object so I could use it in a List View. But the Guest Students Information object is not shown when I try to create a Cross object formula. Am I assuming correctly that a Cross object formula field can only be set on the Child object, and not the Parent?
Thanks for your help.
Warmly,
Glenn
If there is a lookup relationship between the contact and Guest student information object you cannot populate the Arrival date on contact with formula field.Best option is to create a process builder on guest student information object and in that process builder you can action to field update(GuestStudent__r.ArrivalDate__c). It worked for me. Let me know if you have any questions.