You need to sign in to do that
Don't have an account?
jgreene.ax1178
Cross Object Formula Question
Hey all!
I have two custom objects that I created. I have a 'date' field in one of them and want to add the value of that date field to the 2nd custom object.
However, when I try to reference that object (new schools) to the 2nd object field, I get a field error. This is what my formula looks like:
new_schools__r.install_date__c
Any help would be much appreciated!!
-Jake
I have two custom objects that I created. I have a 'date' field in one of them and want to add the value of that date field to the 2nd custom object.
However, when I try to reference that object (new schools) to the 2nd object field, I get a field error. This is what my formula looks like:
new_schools__r.install_date__c
Any help would be much appreciated!!
-Jake
Have you checked the return type of your formul field. Otherwise the insert formula button and getting the result is pretty straightforward it you are trying to access parent from a child.
All Answers
Both custom objects are just that - objects. I don't have one as a master or anything. I do have a lookup field that references the New Schools object. That way it connects the 2nd object to the 'New Schools' object. Thoughts?
You can use a workflow rule to update the field. Can you please be more specific regarding the type of field you are trying to update and how?
The field I'm trying to bring over to the 2nd object is called 'Install_Date__c'
@Chinmay - I'm trying to make it formula fields only, I really don't want to make workflow rules for this.
Have you checked the return type of your formul field. Otherwise the insert formula button and getting the result is pretty straightforward it you are trying to access parent from a child.
Thanks so much for your help here - I really do appreciate it.