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
-1
votes
1answer
664 views

how to get the week from date formulae field in salesforce? [closed]

i want to display the week in field labale by using the formulae field, in manually sdcsacascaDaDXCAScASC DADdasdq
2
votes
1answer
992 views

Formula field to calculate next working day excluding public holiday & weekend

How can I calculate next working day excluding public holiday configured in my saleforce org & weekend using formula field?
1
vote
2answers
1k views

Roll up summary trigger for formula field

I have two object which are in lookup relationship Opportunity_c(Parent) and Recipt_c(child). And i have Due_Amount__c(formula) field in child object i.e Due_Amount__c = Payment_Schedule_c - ...
2
votes
2answers
849 views

Want to change value of field, using a formula field, from Approval Process

I have an Approval Process that has three stages, pending, ready, completed. Based on what stage the Approval process is in, I want a field, probably a formula field that will display that value(...
1
vote
1answer
78 views

Refer to multiple records of an object in a formula

I am trying to create a formula field in salesforce.com that refers to a field value in two different records that are one above the other in a table. For example, ID | TEST | 123 | ...
2
votes
1answer
5k views

How to give two different if conditons in one formula field?

I need to put these two if conditions together in one formula field. Can any help me in this. OR(IF(AND((NSL_Number__c != NULL),(NSL_Number__c != '0')), HYPERLINK("https://c.cs14.visual.force.com/...
5
votes
1answer
2k views

Calendar Week Date Range as a formula field

Is there anyway to modify this to look at a different date versus Today? Such as a custom date field? Any help would be greatly appreciated! Is there a formula to display the calendar week I want ...
4
votes
1answer
939 views

calculate date(formula field) based on two fields

Start and End Dates need to be calculated date fields (formula) based on the Fiscal_Year_Start_Date__c field on the Account and the Fiscal_Year__c. Example: If Fiscal_Year__c = 2013 and Account....
2
votes
1answer
338 views

Show Formula Field Changes in Edit Form

My system setup involves Opportunities having an extra "Billing Contact" field, and when Sales Reps change this field, I want to be able for them to see, on the Opportunity Edit form/page, a property ...
4
votes
2answers
898 views

Hyperlink only in the list view not in the detail/edit mode

Im creating a cutom object 'Custom Case' exact replica of Case object. Subject is hyperlinked to the Case detail view in the list view. But it is not hyperlinked in the detail view and edit mode. How ...
5
votes
2answers
4k views

Counting multi-select picklist selections in a formula

I would like to ask something about FORMULAS. I have a multipick list field where the user select one or more options(text), i would like to count how many options he select and multiple that for one ...
1
vote
2answers
23k views

How to use OR within a IF Statement in Formula field

I am trying to use the following code snippet in a formula field. I am confused on how i would represent OR within a IF statement if(project_type__c == 'Billed' || project_type__c == 'UnBilled') { ...
4
votes
1answer
1k views

Formula: BlankValue function with CASE function

I am trying CASE function inside a BlankValue function and I'm having trouble with the second expression (the substitute one). The first expression works fine with the case function, but the ...
2
votes
1answer
376 views

Formula with depending picklist

I have a child object depending on Accounts. I am using the custom "type" field in accounts an have a depending picklist called "subtype". No all "types" have assigned "subtypes". I want to pull a ...
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
6k 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
411 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
630 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
7k 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
688 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
460 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
692 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
854 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
819 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
404 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 ...
5
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
804 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
855 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(...
2
votes
2answers
8k 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. ...