Skip to main content

​
What is Computation?

Computation - is a field module to assist you in designing your template with “computed fields”. It can bring the ability to define fields on an object whose value is computed from the values of other fields. Most of the formulas in Excel apply to Computation in RDrive. E.g.: SUM, VLOOKUP, AVERAGE, LEN, IF, etc.

​
How to set up the computation to an issue template?

First, you have to edit /create fields and assign field types to design the template layout in the issue wizard. ✨ Edit an issue/record template Tips: If you want the Output field uneditable manually, you may set the field type as “Read Only”. Computation - Issue Computation - Issue Computation - Issue Click the Computation option (or ⌘/Ctrl 6) in the more tools list to bring up the Computation dialogue. Computation - Issue Computation - Issue Click EDIT to open the spreadsheet. Computation - Issue At the very beginning, the spreadsheet should be blank. Please click the ⋮ and Download the Excel file for edit. ⚠️ Warning:  Please do not attempt to create the spreadsheet from the web. Do it in the downloaded Excel and import it. The whole purpose of the spreadsheet is to check if the system supports the formulas you inputted. Computation - Issue Computation - Issue

​
-

Open excel, design the input and output cell and enter the formula. Click here ? to download the excel for reference. Spreadsheets Size Limit: 100KB Computation - Issue Upload the excel file. Computation - Issue Excel uploaded. Have a look at the spreadsheet. If there have any not applicable functions, it will pop Error. The spreadsheet will automatically save. Click ? to go back to the computation dialogue. Computation - Issue

​
Assign value

INPUT & OUTPUT An input field can be any field type.
An output field can be any field type except image, signature, team list, user list and dropdown list. Click SELECT to select fields from the form to assign the spreadsheet cells for the input value. Computation - Issue Click on the field to choose, the selected field will highlight in blue. Press the ✔️ on the bottom right to confirm; or clicking outside of the dialogue to cancel. Computation - Issue Click to select the cell for mapping. Computation - Issue Computation - Issue May proceed as follows. Computation - Issue Done for INPUT. Please repeat the above actions for the OUTPUT to assign value. Computation - Issue OK to complete. Computation - Issue SAVE. Computation - Issue

​
⭐️ Remember to PUBLISH the template after changed!!

Below is an example of the computed field behaviour for your information. The value of the “Due By” date is updated by the selection of “Priority”. Computation - Issue

​
? What if the priority day needs to be project specific?

The spreadsheet is able to edit on the project level!! Click here to continue to see how.
If you are interested in how to setup up computation on the process template, click here.