Skip to Content

Articles Search Results

Converting discussion into text

In order to convert all the comments in the discussions tab of an item to a separate text field (for instance, to use for export), enter the following expression:   @prefix cmw: <>. @prefix comment: <>. @prefix sort: < … Read More

Auto numbering

In order to pre-populate a certain field with the count of all IDs in the current app +1, thus, getting a unique consecutive number for an item (invoice no, request #, etc.), enter the following expression: @prefix cmw: <>.@prefix cmwmath: <>.@prefix math: <http://ww … Read More

Converting attachments into text

In order to convert attachments into text attribute (for example, to get the list of names of these attachments, or to have clickable links to them), enter the following expression: Attachments from current item only (subtasks attachments not included): Link: @prefix cmw: <>.@prefix xsd: <http://www.w3.or … Read More

Calculating next recurrence date

In order to calculate next recurrence date for a certain item, enter the following expression: Date format: @prefix cmw: <>.@prefix str: <>.@prefix schedule: <>.{  ?item cmw:schedule ?scheduleId.  ?scheduleId schedule:las … Read More