In the screen designer, you can dynamically transform data in columns. This can help when the data stored in the table, does not match the format you’re hoping to present to the user. In this example, we will highlight how we manage to convert a ‘duration’ stored in a Workcenter History table in Milliseconds, to Minutes, and also round the value to 2 decimal places. You can also dynamically add text to these cells like “uom” by changing the display type to text, rather than an integer or float.

Instructions

1. Navigate to the Screen Designer
   
2. Locate teh Table Screen taht you wish to modify (open or create a new one)
   
3. within the canvas area - select the table element
   
4. After you have selected the table containing the column you want to modify - find the Additional Fields section and add the field you want to modify to the additional fields - in this example we've added "duration".
5. Now go back to the canvas and select the column you’re modifying
6. Scroll to the “Advanced” section
   
1. Find the Data option and flip this to advanced using the </> to the top right, which then exposes additional properties for the field to be edited
   
2. Dynamic Fields - this need to contain a reference to the payload from the table - in this example what we need is the “duration” data from the query
   
3. 1

   2

   3

   4

   5

   6

   {

   "payload": [

   "data.duration"

   ],

   "context": []

   }
7. Now you need to tell the system what you want to do with this payload data, now that it knows the specific data you’re referencing - In the “Actions” transform window, you can enter a jsonata transform that will use the data you’re providing it and format it/ perform calculations and even add labels, text, etc.
   
1. 1

   $round($sum((data.duration)/60000),3) & " Min"

   
   

End Result: