{"id":21850,"date":"2016-01-12T01:07:42","date_gmt":"2016-01-12T09:07:42","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=21850"},"modified":"2020-02-14T00:59:27","modified_gmt":"2020-02-14T08:59:27","slug":"configuring-and-using-calculated-fields","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/21850\/configuring-and-using-calculated-fields\/","title":{"rendered":"Configuring and using Calculated Fields"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Overview<\/h3>\n<div class=\"StepInstructions\">\n<p><i>Calculated Fields<\/i> are the fields that derive their values using some calculation performed on values of other fields of a record.<\/p>\n<p>This article explains how to create and use calculated fields.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">1. Creating a calculated field<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29791-media_1452150546181.png\" alt=\"wpid29791-media_1452150546181.png\" width=\"800\" height=\"537\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29790-media_1452151146241.png\" alt=\"wpid29790-media_1452151146241.png\" width=\"589\" height=\"356\" \/><\/div>\n<div class=\"StepInstructions\">\n<p><i>Calculated fields <\/i>can be of two types:<br \/>\n1. <strong>Text field:<\/strong> This type of field can display the result of a calculation formula that gives a text value.<br \/>\nE.g. You can concatenate values of two fields.<\/p>\n<p>2. <strong>Numeric Field:<\/strong> This type of field can display the result of a calculation formula that outputs a numeric value.<br \/>\nE.g. You can perform mathematical operations on different numeric fields.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29789-media_1452151458283.png\" alt=\"wpid29789-media_1452151458283.png\" width=\"638\" height=\"382\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29792-media_1452151530425.png\" alt=\"wpid29792-media_1452151530425.png\" width=\"646\" height=\"407\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29799-media_1452156122689.png\" alt=\"wpid29799-media_1452156122689.png\" width=\"423\" height=\"433\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>For more information on scripting calculated fields, refer <a href=\"http:\/\/res.technosolutions.com\/oc\/index.php\/s\/xTuSaw2OMI0qJSR\" target=\"_blank\" rel=\"noopener\">Calculated Fields Scripting Guide.<\/a><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29800-media_1452156293130.png\" alt=\"wpid29800-media_1452156293130.png\" width=\"627\" height=\"267\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">2. Viewing Calculated Fields on TopTeam Web<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29788-media_1452255434169.png\" alt=\"wpid29788-media_1452255434169.png\" width=\"584\" height=\"392\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29793-media_1452255768950.png\" alt=\"wpid29793-media_1452255768950.png\" width=\"781\" height=\"483\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29798-media_1452256042692.png\" alt=\"wpid29798-media_1452256042692.png\" width=\"800\" height=\"392\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">3. Viewing Calculated Fields on TopTeam Desktop<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29794-media_1452153378577.png\" alt=\"wpid29794-media_1452153378577.png\" width=\"627\" height=\"469\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29795-media_1452161767990.png\" alt=\"wpid29795-media_1452161767990.png\" width=\"800\" height=\"440\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29796-media_1452156446478.png\" alt=\"wpid29796-media_1452156446478.png\" width=\"773\" height=\"617\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2019\/02\/wpid29797-media_1452156795973.png\" alt=\"wpid29797-media_1452156795973.png\" width=\"781\" height=\"286\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">See Also<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/21286\/how-to-add-a-new-custom-field-to-form-layout-designer\/\" target=\"_blank\" rel=\"noopener\">How to add a new Custom Field to Form (Screen)<\/a><br \/>\n<a href=\"http:\/\/www.technosolutions.com\/kb\/1890\/defining-custom-fields-for-a-record-type\/\" target=\"_blank\" rel=\"noopener\">Defining Custom Fields for a Record Type<\/a><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: January 9th, 2017<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview Calculated Fields are the fields that derive their values using some calculation performed on values of other fields of a record. This article explains how to create and use calculated fields. Who should read this? TopTeam Administrators 1. Creating a calculated field Calculated fields can be of two types: 1. Text field: This type of field can display the result of a calculation formula that gives a text value. E.g. You can concatenate values of two fields. 2. Numeric Field: This type of field can display the result of a calculation formula that outputs a numeric value. E.g. You <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[297],"tags":[308,29],"class_list":["post-21850","post","type-post","status-publish","format-standard","hentry","category-configuration","tag-fields","tag-record-type"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-5Gq","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/21850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=21850"}],"version-history":[{"count":16,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/21850\/revisions"}],"predecessor-version":[{"id":49019,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/21850\/revisions\/49019"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=21850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=21850"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=21850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}