4,401
edits
Changes
no edit summary
You can use arithmetic, string, comparison operators and functions within the calculated [[Custom Field|custom field]].
* References to other fields are always enclosed in square brackets: '''[variable1]'''. For example: '''[Salary]'''.
* The calculations are performed when you click the '''Save''' button and save the page.
* If the fields are ordered in this manner saving the page will not update the summary calculation, as summary formula will be executed BEFORE the subordinate calculations are performed.
All values are treated as strings. For arithmetic operations, PARSEINT and PARSEFLOAT function are used to convert the string value to a numeric value. For example: • * '''PARSEINT([Salary]) + PARSEINT([Bonus]) + PARSEINT([Car Allowance]) ''' - Add Salary to Bonus to Car Allowance and return an integer result. • * '''PARSEFLOAT([Salary]) / 26 ''' – Divides the Salary by 26 to show a bi-weekly amount.Exercise – ==Adding a Calculated Field== 1. Add a [[Custom Field ]] Type named '''Total Compensation ''' to the '''Compensation ''' tab. 2. Set the '''Field Type ''' to '''Calculated Value'''. 3. Add the following formula:
4. Set the '''Number Format ''' to '''Currency'''. 5. Save the '''Field'''. 6. Add another field named '''Pay Per Period ''' as shown below. 7. Set the '''Number Format ''' to '''Currency'''. The '''Field ''' list will look as follows:
8. Edit an '''Employee ''' record. 9. Click the '''Compensation ''' tab.
The calculated fields are blank as the record has not been saved with these fields.
10. Click the '''Save ''' button.
The values are calculated and saved.
=Web Page View Field= The [[Custom Field Type (110): Display Only – Web Page View|Web Page View ]] field provides the ability to display a fully formatted document or web page. In constructing this type of field HTML is used in conjunction with the following variables.
In this example you will create a simple letter of offer displaying the employee’s name and address plus details of their compensation.
1. Edit the '''Letter of Offer Field ''' field – currently set to a '''Link Single File Field''' field. 2. Change the '''Field Type ''' to [[Custom Field Type (110): Display Only – Web Page View|Display Only – Web Page View]].
The HTML Template is used to store the body of the document and will be a mix of HTML code, static text and references to fields associated with the underlying [[Entity|entity ]] – in this case the [[User|user ]] [[Entity|entity ]] and the employee [[Role|role]]. ==Basic HTML Tags RequiredThe following basic HTML tags should be added to the Web page View.==
<html><head></head>
</body>
</html>
The Variables are shown in bold.
Note the use of the “me” variable to reference the current user’s details.
2. Save the template.
3. Display an Employee record.
4. Click the Open button on the Letter of Offer field.
• All variables have been added, except the salutation field that is not set in the underlying entity.
• There are no options available for this document as you have yet to enable them.
5. Close the window.
Suppressing Missing Fields
A special tag is used to suppress any fields that are missing from the underlying entity - <!--hideifnotfound-->. Placing this tag in front of any field that may not be present will suppress the display of the variable name.
1. Display the Web Page View custom field.
2. Add this tag before the @salutation@ field.
<!--hideifnotfound-->@salutation@ @firstname@ @lastname@<br>
3. Save the Web Page View Field.
4. Display an Employee record.
5. Click the Open button on the Letter of Offer field.
The @salutation@ field is suppressed.
6. Close the Window.
Document Options
You control which options are available to the user of each Web Page View field. Each of the selected options will add a button to the top of the Web Page View field. The following example shows how the field will look with all options enabled:
• Show Menu – check box that defines if a menu should be shown in the document window.
• Save to Multiple File Field – enables the user to save the document as an HTML document into any multiple file type fields in the related entity.
• Save to Local Disk – enables the user to save a local copy of the HTML document.
1. Display the Web Page View custom field.
2. Select all the Document Options.
3. Click the Save button.
4. Display an Employee record.
5. Click the Open button on the Letter of Offer field.
The Letter of Offer document is displayed.
The document can now be printed, saved and emailed as either a PDF or an HTML document.
6. Close the window.
Using the Link – Multiple Files Field
The final custom field type will be the Multiple Files Field. This field stores multiple files into a single field and is used to store:
• Uploaded documents.
• Documents that are created using the Web Page View type field using the Store to Server option.
In this case the field will be used to store the letter you previously created, but can in fact be used to store any number of documents.
1. Add a new field to the Employee Role Field List named Employee Related Documents.
Multiple Files Field Options
The following options are available for this field type:
• Keep Version – provides for version control over documents added. When a second document with the same name is added, the name will be appended with V_# (where # is the version number starting at 1).
• No Deletion – suppress the user’s ability to delete any files stored in the field and Manager Permission is required by the user to delete a – Allow Delete Multiple Files Fields.
• Sort Order – files stored in the field can be ordered by File Name, File Size or Update Date (descending).
• Index – enables file indexing and full text searching on the embedded documents.
1. Enable all the options.
2. Set the Sort order to Upload Date.
3. Save the field.
4. Display an Employee record.
5. Click the Open button on the Letter of Offer field.
The Letter of Offer document is displayed.
6. Select the Folder Name Employee Related Documents.
7. Click the Save to Server as PDF tab.
You are prompted to rename the document – if required.
8. Click the OK button.
Because you enabled the Password Protection setting you are prompted for a document password.
9. Enter a password.
10. Click the OK button.
The Letter is saved.
11. Close the Window.
The document will not be displayed until the employee window is refreshed.
12. Refresh the Employee window.
The document is saved into the Employee Related Documents field.
If you were to create a second version of this file the name would be named V1_ and the file name.
Importing Data to Custom Fields
If you create custom fields for an object before you import information, then you can upload information into these custom fields. See the Module Importing Information on page 60 for more details on the import process.
