Difference between revisions of "Workflow Task Type: Update Standard Field Value"
| Line 14: | Line 14: | ||
==Examples== | ==Examples== | ||
| − | To populate the current date (for example, a workflow triggered at status '''Submitted''' could be configured to put today's date into a | + | To populate the current date (for example, a workflow triggered at status '''Submitted''' could be configured to put today's date into a standard field, for example the "Start Date" standard field: |
* '''@date(currentdate)@''' | * '''@date(currentdate)@''' | ||
| Line 20: | Line 20: | ||
* '''<!--@sscalculation(date_add(CURDATE(), INTERVAL 1 YEAR))-->''' | * '''<!--@sscalculation(date_add(CURDATE(), INTERVAL 1 YEAR))-->''' | ||
| − | To populate with a system variable value (for example, to put a submission deadline into | + | To populate with a [[system variable]] value (for example, to put a submission deadline into a standard field when a record is created) |
* '''@system.Submission Deadline@''' | * '''@system.Submission Deadline@''' | ||
Revision as of 15:16, 22 August 2013
The Update Standard Field Value workflow type can be used to write values to standard fields on the object against which the Workflow is triggered.
Standard fields on the following object types can be updated using this method:
- Level 1s
- Level 2s
- Companies
- Contacts
- Transactions
These values can be hard-coded values, or can also use variables.
You can also use MySQL syntax to manipulate values using sscalculation
Examples
To populate the current date (for example, a workflow triggered at status Submitted could be configured to put today's date into a standard field, for example the "Start Date" standard field:
- @date(currentdate)@
To populate a date 1 year from the current date (for example, for a progress report that is due 1 year after the application is submitted)
- <!--@sscalculation(date_add(CURDATE(), INTERVAL 1 YEAR))-->
To populate with a system variable value (for example, to put a submission deadline into a standard field when a record is created)
- @system.Submission Deadline@
