Workflow Rule for Creating a Referral Call When a New Lead is Created

This topic provides details of the workflow rule and action that you must configure so that a task is automatically created when a lead record a saved for the first time. A referral call is created. It is scheduled on the next working day after the lead is created. For example, if the lead is created on a Friday or Saturday, the call is scheduled for the following Monday. The owner of the task is the owner of the lead record.

Note: The expressions in this topic might appear across several lines due to length. All expressions in this topic must be entered in Expression Builder as one line and cannot contain any spaces. Also, the language-independent field names and the field-name syntax used in the expressions in this topic are the field names and syntax that were used in Expression Builder in releases earlier than Release 29 Service Pack 1. These expressions are still valid in Release 29 Service Pack 1 and later releases. However, starting with Release 29 Service Pack 1, Expression Builder uses language-independent field names and a field-name syntax that are different from the field names and the field-name syntax used in earlier releases. So, if you select the corresponding fields from the field list in Expression Builder when you create or update an expression in Release 29 Service Pack 1 or a later release, then the field names in the expression will be different from the field names shown in this topic, and the fields will appear in the expression editor with the following syntax: [{FieldName}]. It is recommended that you always select the fields for your expressions from the list of fields in Expression Builder, so that the field names and the field syntax are always correct. For more information about Expression Builder, see Oracle CRM On Demand Online Help.

Workflow Rule Details

This topic describes the details of the workflow rule.

Record Type

The record type is a Lead record.

Trigger Event

The trigger event is When New Record Saved.

Rule Condition

Not applicable. Leave this section blank.

Workflow Action Details

This topic describes the details of the workflow action.

Action Type

The action type is Create Task.

Task Type

The task type is a Referral Call.

Due Date

The Due Date field contains a numeric value that is calculated by adding the value in this field to the date on which the task is created.

Enter the following expression in the Due Date field:

IIf((IfNull(Mid(1.0 * JulianDay(Today()+1)/7, 8, 1), "0")>="7"),IIf((IfNull(Mid(1.0 * JulianDay
(Today()+1)/7, 8, 1), "0")="7"),Today()+3,Today()+2),Today()+1)

Subject

The subject field contains the subject line for the task. You can embed functions and field names in the text. Three percent signs (%%%) before and after an embedded function or field name indicate that it is to be converted to a string.

Caution: In the Subject field, three percent signs (%%%) are placed before and after the functions and field names. If you type a function or field name directly in the Subject field, you must type three percent signs before and after it. If you use Expression Builder to embed a function or field name, the percent signs are automatically added and must not be pasted into Expression Builder. When percent signs are pasted into Expression Builder, Expression Builder displays an internal error.

For more information about expressions, see Oracle CRM On Demand Online Help.

Enter the following expression in the Subject field:

%%%LookupValue("TODO_TYPE", "Referral Call")%%%-%%%JoinFieldValue('<Lead>',[<LeadId>],
'<LeadFullName>')%%%