You need to sign in to do that
Don't have an account?
mbolton
How do I reference a field from another object?
Forgive my density today, but I am drawing on blank on how to reference the value placed in a custom field from the Account Object. For example: The Cutomer No. is a custom field within Account, and I want to reference that Customer No. on a Sales Order (a custom object in itself.) Any help would be appreciated!
Thanks,
Mark
So assuming you have a lookup field on the sales order to the account, you can then just create a custom formula field (text) on the sales order object and enter something like:
Account.Customer_Number__c
Regards,
forcedotcom
I have the same question as mbolton
What if I want to reference the value of a picklist picked in a previous object? Thanks!!
Yeah, I used the TEXT(), it worked perect!
Thanks!
I actually think my question was different now looking at the answer...
I'm new to Salesforce, but familiar with formulas and programming
We have in several instances duplicate fields that are in different objects and being entered numerous times.
Such as...
Contact: Business Name & Businesses: Business Name
To reduce data errors and data entry time, I would like to be able to use a formula to feed the value from a field in the primary object to another (maybe several other) same fields in different objects.
Came across VLOOKUP today, but don't want to do any "testing" due to the fact that there is currently real data in the fields that would be lost if replaced by a formula which could be inconvenient as well ; )
It's would seem to be something simple to do, just not sure how to and hoping to get some help.
Thanks a bunch!!!!!!!!
If you have a parent object (called Account or Business) with a field called 'Business Name' and you want that to appear on related records, you need to create a text formula field on the related object called 'Business Name' and the formula should look like:
Account.Business_Name__c
The business name on the related object will then update when changes are made to the account / business record.
Regards,
forcedotcom
Thanks for the info : )
I understand I need to use a cross reference formula, but the object is custom "Business".
How do I tell if it's a parent object, and if it's not...
- how can I make it a parent object (it shows no master object and I'm trying to reference it in a custom field in Contacts)
- are there any implications to making it a parent object?
Tried using Help for "cross object formulas" and "parent objects" but didn't seem to find reference to this.
Thank you in advance for your assistance