Question
How do I add a line number to an export?
Answer
You can add a line number field to Pacific Timesheet exports using a field configured as a custom expression.
The field is TimeEntry.exportRowNumber and you can use it in an expression such as:
This expression will generate a row number in the export file, starting from 1.
As with any field in an expression, you can format it to your liking. For instance, if you need to append the letter 'R' to it you would simply modify the express to be:
If you need to pad the value with leading zeros to make an 8 digit number you would need a bit more complicated JavaScript for your expression:
For asset entry exports a similar new field has been added:
MaterialEntry.exportRowNumber
It can be handled in exactly the same way in an express field as for TimeEntry.exportRowNumber.
Comments
0 comments
Please sign in to leave a comment.