How do I setup conditional logic when exporting data?

Question

How do I setup conditional logic when exporting data?

Answer

Background

Sometimes, you need to create complicated export fields that include values that concatenate other data field values together with custom separators. A more challenging export requirement is when you need to have these expressions run based on certain conditions. In our export tools we have Custom Expressions available that can use basic expressions, or more complex conditional logic.   

How It Works

Our Custom Expressions use JavaScript to fully support the creation of custom expression fields for timesheet and asset entry exports.  This allows you to include conditional (boolean) logic and other complex expressions when creating custom export fields.

To use this feature for a timeheet export:

1. Navigate to System > Data Integration > Timesheet Export > Edit
2. When editing this export page, you can add a Custom Expression by clicking on the Plus (+) button and scrolling down the field pick list to the bottom of the list and click on Add Custom Expression to create a custom expression field.
3. An expression editor dialog will open
4. In the example below, you could create a custom expression export field that outputs a special value when the hours entered are greater than a certain value.

The applications of Custom Expressions are endless. To learn more click on the Help link in the custom expression dialog and to find more examples.  In addition, you can search Help Center for knowledgebase solutions. As well, you can always log a question or request in Help Center by clicking Submit a request.

Conditional logic is available in in Pacific Timesheet version 9.14 build 377.