Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
prady Hi,
Can i create a formula using a lookup object fields? For instance i have a custom object and got a lookup with account
i need a formula which uses a field from the account object
For eg.
"PJ_"&SHORTNAME&"_"&UNIQUE-SEQ-NUM (UNIQUE)
Where shortname is a field in account object.. If using formaula is not possible is there anyway to achieve it?
Thanks
Prady
Account__r.Shortname__c should do it. If you switch to the Advanced Formula builder when creating the field, its Insert Field function lets you traverse relationships to select fields. Lookups and Master-detail relationships are denoted by a ">" after the field name, and clicking them shows you the parent object fields for selection.