New answers tagged formula-field
0
The way your question is phrased makes it seem like you have a misunderstanding around formula fields.
A formula field is a calculated field - it doesn't exist in the database and the field's value is calculated each time the formula field is accessed (i.e. loaded from the database) or when explicitly recalculated. The formula doesn't define how the field is ...
0
The syntax of an IF logical function is similar to,
IF(logical_test, value_if_true, value_if_false)
It has three parameters. And AND has the following syntax,
AND(condition_first, condition_true) returns true if both condition are true,
So, in your case, you should use something like,
IF(
AND(
AND(f1__c == NULL, f2__c == FALSE),
$Profile.Name == 'System ...
4
Doing this is inefficient--you will need to query the entire table to filter for records. This will result in slow reports for large objects and is not scalable. Create a secondary field (date-time) and convert the string to a date using a trigger or Process Builder, then you can filter on that efficiently.
0
To display only the time, use:
LEFT(TEXT(TIMEVALUE(CreatedDate)),8)
This converts the TimeValue (“HH:MM:SS.MS”) of the DateTime field to text then uses just the leftmost 8 characters.
3
A formula won't get you there. You need to be able to query the user Id based on the name. This is a perfect use case for the Before Save Flow. In this flow, you first query the user to use with a Get Records element, then use an Assignment to assign the ID based on the Get Records by name. As a bonus, the Before Save Flow does not trigger a recursive save ...
1
You can try this formula:
DATETIMEVALUE(TEXT(DATEVALUE(CreatedDate))+ ' 05:00:00')
Where CreatedDate is your DT field. This will be in GMT though, so you have have to adjust for your time zone.
Top 50 recent answers are included
