Questions tagged [formula-field]

A formula field is a field that automatically calculates its value from other fields, expressions, or values.

Filter by
Sorted by
Tagged with
4
votes
2answers
6k views

Formula field for getting a first and last word from the string

i need a help with a formula. I want to create a formula that will select the firts name and the two last names and input them in a box. ps: i m portuguese and we have a lot of family names thats why ...
13
votes
2answers
7k views

Find line break in formula field

I noticed that the Contact.MailingStreet field can be accessed line-by-line in reports with the Mailing Address Line 1, Mailing Address Line 2, and Mailing Address Line 3 fields. I want to create ...
5
votes
2answers
420 views

Populating a formula field with a trigger

I have an object which is sometimes created by a user manually, or under some circumstances is created by a trigger. It has a formula field which gets populated by a related object's field when a user ...
0
votes
2answers
631 views

formula field help

i have a lookup field that selects a customer name and need to show in the other fields all information about this customer.. How can be the formula in one of this fields? in plsql will be select ...
7
votes
1answer
2k views

Rounding a Formula Field

I have a formula field that is returns a currency and is set to 2 decimals. It displays fine, but when I access the field through the API it returns 6 decimals. 12.493587 should round to 12.49 ...
4
votes
2answers
8k views

How can I use a formula field to retrieve a record in a lookup

I have created a lookup field between the Quote Line Items object and a custom Discounts object. I want to retrieve a certain discount dependent on discount code and product category. My Discounts ...
3
votes
1answer
724 views

Unable to create Custom Field of type MasterDetail or Formula(Number) through Apex's MetaData API

I am suppose to create a custom Summary object from a base object through MetaData API. The summary object will have some of the fields of the base object and few extra fields. I could create the ...
2
votes
1answer
500 views

Does field level security affect list view criteria?

Question Is it true the field level security of a field used in the criteria for a list view is ignored? Or is this a bug? Background I created a new formula field that's true if a user lookup on ...
4
votes
1answer
3k views

Reports and formula fields

I read this very helpful article, Designing Dashboards and Reports for Force.com Implementations with Large Data Volumes I have one question regarding formula fields - if I use formula fields instead ...
0
votes
2answers
586 views

Trouble with Trigger: wan to update child object field (which update via formula from other object)

I'm new with triggers and am having trouble with making one work. I have a child custom object called "Actividad" which has a formula field "Actor Principal Indicador" that gets updated from its' ...
5
votes
1answer
3k views

How to extract values using Salesforce Formula fields

I have one Text field on Custom Object as follows - Product_Info__c = 'DESKTOP:10,LAPTOP:20,MOUSE:20,PHONE:25' //sample value I want to create new formula field as DesktopCount__c which will result ...
2
votes
3answers
2k views

Multi-value CustomSettings field

My package has a CustomSetting object that contains all the configuration values needed to power my application. I would like to add a field that contains all "open" lead statuses, configurable by ...
11
votes
1answer
2k views

Are formula fields so inefficient?

I'm working with some colleagues on a project which the clients would like optimized, as they feels some things are too slow. One of my colleagues has suggested that we should cut down on the use of ...
1
vote
2answers
7k views

Would a formula field get evaluated in a Before trigger

I have a before insert trigger. In this trigger I am comparing a formula field which references the family of the product with a hardcoded value. If they match I display an error message. When run ...
5
votes
1answer
852 views

Partner Account ID-Lead Object

There is Partner Account field on lead object. Salesforce help says, Description:ID of the partner account for the partner user that owns this lead. Available only if Partner Relationship Management ...
2
votes
1answer
857 views

Error in formula field,

I have been trying for some time to add some type of an alert to our Approval page. So far everything that I've tried isn't possible. The person who requested the modification changed the request a ...
2
votes
2answers
838 views

Buttons with dynamic titles in formula Field Buttons?

Question Is there anyway to create an image for a button with a variable title for use in a formula field? Background A common request I get is to put buttons in the page layout itself as the ...
5
votes
2answers
410 views

Parent to child on trigger update

I have two object X and Y. Y is child of X. Object X is having a field called Title (Long Text Area). I want to show this field on Y also. Cross-reference formula field will not work since Title is a ...
4
votes
3answers
1k views

Dynamically get result of a VF field's formula, using Apex

How can I get the result of a formula ("field update"/"workflow rule"), in Apex, without hard-coding it? There is a field whose value (calculated on upsert) is the formula result. I have dismissed ...
4
votes
2answers
817 views

Determine character length of formula fields prior to dynamic SOQL

My application constructs dynamic SOQL queries based on user interaction. The query can get quite large so I split the query into multiple queries based on the character count. However, formula ...
2
votes
2answers
910 views

Formula for finding business days since last interaction

Trying to figure out why this formula is only returning a 1 or a 6. I am trying to figure out how many business days from when a case was created or from the last update. IF( ISBLANK(...
3
votes
2answers
9k views

How do we get user's time zone offset integer in Apex or Formula Field?

How do we get user's time zone offset integer in Apex or Formula Field? For example, a user's personal information time zone (GMT-04:00) Eastern Daylight Time (America/New_York) should return -4. ...

1
15 16 17 18
19