Difference between revisions of "Workflow Task Type: Update Custom Field Value"
From SmartWiki
| Line 1: | Line 1: | ||
| − | The '''Update Custom Field Value''' workflow type can be used to write values to custom fields on the object against which the Workflow is triggered. | + | The '''Update Custom Field Value''' workflow task type can be used to write values to custom fields on the object against which the Workflow is triggered. |
| − | These values can be hard-coded values, or can also use variables. | + | These values can be hard-coded values, or can also use [[variables]]. |
| − | You can also use | + | You can also use MySQL syntax to manipulate values using [[sscalculation]]. |
==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 custom field called '''Date Submitted''': | + | To populate the current date (for example, a workflow triggered at status '''Submitted''' could be configured to put today's date into a custom field called '''Date Submitted'''): |
* '''@date(currentdate)@''' | * '''@date(currentdate)@''' | ||
| − | To populate a date | + | To populate a date one year from the current date (for example, for a progress report that is due one year after the application is submitted): |
* '''<!--@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 custom field when a record is created) | + | To populate with a system variable value (for example, to put a submission deadline into a custom field when a record is created): |
* '''@system.Submission Deadline@''' | * '''@system.Submission Deadline@''' | ||
| − | |||
==See Also== | ==See Also== | ||
Revision as of 14:03, 21 August 2013
The Update Custom Field Value workflow task type can be used to write values to custom fields on the object against which the Workflow is triggered.
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 custom field called Date Submitted):
- @date(currentdate)@
To populate a date one year from the current date (for example, for a progress report that is due one 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 custom field when a record is created):
- @system.Submission Deadline@
