Comindware Knowledgebase

Calculating custom text field values based on values in other fields

In certain cases you may need to automatically compose text field value using text you already have in other fields. 

For example, you may need to auto-generate a workflow task title to contain case id, employee name, date of the request and some custom text so all of your tasks are named using the same format. In this particular scenario you will need to go to the Workflow Scheme settings of your App and add an expression language formula to pre-define the value for the Title field in the first step in your workflow.

To calculate the custom text as described above, you need to use the FORMAT function when writing the expression language formula.

Example of the expression:


FORMAT("Request number {0} from {1} on {2}.", LIST ($id, $employee_1->cmw.account.fullName, $date_1))


where:

  • FORMAT - function used to calculate custom text using field values. 
  • {0} {1} {2} - placeholders that show where you want field values to be placed in the resulting text. Each number in {curly braces} takes data from the LIST operator according to its index number, starting with 0.
  • LIST - contains ids of fields to take data from. Value from the field that is listed first will be put in place of {0}, second one will go to {1} and so on.
  • $id - returns current item id.
  • $employee_1->cmw.account.fullName - returns account name of the user specified in the field with the id of "employee_1".
  • $date_1 - returns date from the field that has the id of "date_1".

 

Use this formula to pre-populate the Title field in the "Pre-populate Fields" settings tab in the first step of your workflow:

Save all your changes.

This is what the final result will look like in the product interface after you create a workflow task:

Send you request to Comindware Still need help? Contact us

See Also

Back to top

Cookies Settings

Privacy Basics

A cookie is a small file placed onto your device that enables website features and functionality.

A cookie is a small text file that a website asks your web browser to store on your device in order to remember information about you, such as your language preference, and enables a website features and functionality.

At Comindware, we believe in being clear and open about what data related to you we collect and how we use this data. And this policy provides detailed information about what cookies we collect and how we use data related to you. This cookies policy applies to Comindware website.

Always Active Cookies

Ensure your personalized experience and proper website work.

Always active cookies help us with giving you a personalized experience and cannot be switched off in our system. You can set your web browser to block or alert you about these cookies, but some parts of the website may not work then.

Comindware

Performance Cookies

Are used for continuous website optimization and improvement.

Performance cookies help us with continuous website optimization and improvement. This cookies make it possible for us to count website visits, track traffic sources, learn which pages are the most popular and helpful and see how visitors navigate around the website. All the data these cookies collect is aggregated and therefore anonymous.

Google Analytics

Yandex.Metrica

Functional Cookies

Enable functionality enhancement, such as videos and live chats.

Functional cookies allow functionality enhancement, such as videos and live chats. If you do not allow these cookies, then some or all of these functionalities may not function properly.

Wistia

JivoChat

AddThis

Comindware uses cookies to ensure you get a great experience on our website - click "OK" button to agree our Privacy Policy. You can change your cookies preferences here.