New answers tagged formula-field
1
A formula field value does not exist in the database - it is calculated at the time it is queried. You can, however, request an already queried formula on an already queried object to be re-calculated using:
SObject.recalculateFormulas
Formula.recalculateFormulas
Watch out for SOQL limit usage. From my perspective, use of the Formula class method is ...
0
No, what you're looking for is not possible with Criteria-Based Sharing Rules, at least not with the constraints you've listed. You must have the data on the Contact record in order to use this feature. Therefore, you're stuck with Apex Sharing instead.
3
No, you can't build formulas on child objects. You could use a trigger or rollup summary field to transfer the information up to the quote, which you could then reference in a formula.
0
You cannot use the Multi select pick list via normal pick list value formula.
You need to do it like
IF(INCLUDES( Multi_Picklist_1__c , "IT"), True, False)
https://help.salesforce.com/articleView?id=tips_for_using_picklist_formula_fields.htm
0
The API name is used everywhere. It is really unlikely you're relying on a label, especially since those are also translated depending on the language of the user. You should not be using or depending on picklist labels anywhere in your code, and if you are, you should fix that. If you change the API name, then you'd need to check your code for any ...
1
You can do it like this: LPAD(RIGHT(AccountNumber, 4), LEN(AccountNumber), '*')
RIGHT takes the last 4 characters from the account number
LPAD adds (AcocuntNumber character length - 4) '*' characters on the left of the string
0
You are receiving that error because the IF function is a parameterized function that takes three arguments.
IF(<expression_to_evaluate>, <expression_is_true>, <expression_is_false>)
Example:
IF(AND(Payment_Due_Date__c < TODAY(),Payment_Status__c ="UNPAID"), "PAYMENT OVERDUE", null)
You need to wrap your other logic in parentheses ...
1
According to the documentation, you cannot get the previous value in a formula field, as it is not available there.
This function is available only in:
Assignment rules
Validation rules
Field updates
Workflow rules if the evaluation criteria is set to Evaluate the rule when a record is: created, and every time it’s edited .
Formula ...
2
Following your example, something like ...
TEXT(FLOOR((Speed_to_Dial_main__c - CreatedDate)*24)) &' Hr '&
TEXT(MOD(FLOOR((Speed_to_Dial_main__c - CreatedDate)*24*60), 60)) & ' Mins '&
TEXT(MOD(FLOOR((Speed_to_Dial_main__c - CreatedDate)*24*60*60), 60)) & ' Secs'
0
According to the documentation present in this link [ https://help.salesforce.com/articleView?id=search_lookup_lex.htm&type=5 ] it states "As you type in the lookup field, you see a dynamic list of suggested matches. " can you check once.
0
You could conceptually do this with an auto-launched flow. You do not necessary need a developer to write any code.
0
Check critical updates for 'Lightning Experience Honors Target Values for Hyperlinks in Formula Fields'
Also you should use <apex:page renderAs="pdf"> instead of your JS approach.
https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_quick_start_renderas_pdf.htm
1
It sounds like you're asking to pull a text field from a parent record into its child record. The way to achieve this is creating a text formula field on the the child object. This field will exist beside the lookup field to the parent record.
Top 50 recent answers are included
