New answers tagged formula-field
1
The ISPICKVAL takes two arguments separated by a comma, but you have instead tried using an equals sign.
Incorrect
ISPICKVAL(PRIORVALUE(...) = "value")
Correct
ISPICKVAL(PRIORVALUE(...), "value")
1
Just create a custom field of type URL and populate it with Apex (or however). Here's the documentation: https://help.salesforce.com/articleView?id=custom_field_types.htm&type=5
0
Workflow can not in most cases do Field Updates on related records. You need to use Process Builder (and optionally) Lightning Flow to update related records
0
I found the answer.
I had forgotten to provide the 'yesSmoke' and 'noSmoke' choice values as true or false.
The correct value is now set.
Thanks
2
For whatever reason, as noted here, you seem to get the label if you refer to the field, but you get the value if you pass the field into a record element/variable.
As @Mitesh stated, you should be able to store the Choice Value as a variable and get what you need.
Create the variable. Click on Manager --> New Resource
Select Variable for Resource Type. ...
0
This worked for me:
Create a custom field on User object "hasLoggedIn" (checkbox)
Set this to TRUE for all existing community users
Set this condition on your Process node for the notification
Additional to the notification, add an update action to set the hasLoggedIn checkbox to true
0
I would try this instead:
IF ( TEXT( Related_Contract_Record__r.Contract_Status__c ) == "Cancelled",
'Cancelled',
'NotCancelled')
and for your checkbox:
IF ( TEXT( Related_Contract_Record__r.Contract_Status__c ) == 'Cancelled' ),
TRUE,
FALSE )
You should see that your formula will then evaluate accordingly. The only time there would be any ...
1
The below seemed to work well except with regards to Daylight Savings Time. I'm hopeful, depending on how your UserTimezoneOffset field is set, that this might not be an issue.
For reference, this thread contains where I got the initial structure of the formula from and good discussion about doing what you're looking for. You'll be parsing through the ...
0
If they are different fields:
IF(ISPICKVAL(Field1, 'value1'), 'A',
IF(ISPICKVAL(Field2, 'value2'), 'B',
IF(ISPICKVAL(Field3, 'value3'), 'C',
null)))
If they are the same field:
CASE(Field, 'value1','A','value2','B','value3','C',null)
1
Editing this answer to reflect a better understanding of what you want to happen. I believe the ask is this:
When verified complete, update to 'B'
When ok for production, update to 'B+'
When activated, update to 'A'.
As mentioned by Derek, formula fields don't update anything; they're calculated dynamically every time that they are viewed, but no data is ...
0
I think that part of your confusion lies in what a formula field is.
A formula field is something that is computed every time it is accessed from a persisted SObject (i.e. when you query this field via SOQL, or view the field on a Visualforce page, the field value is re-computed). There's nothing that needs to be "updated", it happens automatically.
Let's ...
Top 50 recent answers are included
